Database Reference
In-Depth Information
A payroll log keeps track of remuneration paid out to employees.
Each employee is assigned to at least one project; the number
of employees assigned to a project depends on the size and
complexity of the project.
1.
Identify all information entities (object types) mentioned or
implied in the case.
{10}
2.
Identify all relationships among the entities (object types) and
represent them on an ERD or ORD.
{20}
3.
Use the information in the case, combined with the
information conveyed by the E-R diagram and your own
intuitive design skills to propose relations and their associated
attributes for each of the entities represented on the E-R
diagram. You may also introduce additional relation(s) to take
care of M:M relationship(s) which may exist.
{60}
26.3 Sample Assignment 2B
1.
What are the possible advantages of using distributive
processing in a database system environment?
{06}
2.
What are the problems that can be experienced from having
non-normalized files in a system?
{06}
3.
Relation R(A B C . . . K) is in 1NF only. The following FDs hold:
a.
Primary key is (ABC)
b.
A → D
c.
B −> E
d.
F → G,H,I
e.
J → B
f.
K → C
g.
(AF) −>> J/K
By repeatedly using Heath's or Fagin's theorems, decompose
R into a set of 5NF relations. Show how the new relations
will be keyed.
{15}
 
Search WWH ::




Custom Search