CSIS3310 – quiz

Matching

Functional Dependency = j	a) A Table that is at least in 1NF
Relation = a	b) A Table that is at least in 2NF
All non-key attributes are dependent on nothing but the key = d	c) Implements referential integrity
Primary key = h	d) A Table that is at least in 3NF
Candidate key = g	e) Something that users want to track
Composite Key = k	f) autonumber in MS-Access
All non-key attributes are dependent on the whole key = b	g) UNIQUE
Surrogate Key = f	h) the key chosen to be a unique identifier of a table
Foreign Key = c	i) a field that holds a list of values, such as phone numbers.
Multivalued attribute = i	j) When you know the value of one attribute, you can determine the value of another attribute. For example, by knowing the value of ssn of an employee, you determine the value of salary (only one value)
All non-key attributes are dependent on the key= a	k) A field that contains other fields, such as address
Entity = e

For the example below we have one big table. Put the table in 3^rd normal form.

Eid = Employee id, Pid = project id, Mid = Manager id

Functional Dependencies are:

Eid -> ename eid -> pid pid -> mname

Pid -> pname Pid -> mid Mid -> mname

Eid Ename Pid Pname Mid Mname

E01 John p1 Eco DBMS m1 Becky

E02 Mary p2 Admin. m2 Joe

E03 Mark p2 Admin m2 Joe

E04 Travis p3 Educ. m1 Becky

Employee [eid, ename, pid ]

Project [pid, pname, mid]

Manager [mid, mname]