CSIS3310 – quiz

 

Matching

 

Functional Dependency

a) A Table that is at least in 1NF

Relation

b) A Table that is at least in 2NF

All non-key attributes are dependent on nothing but the key

c) Implements referential integrity

Primary key

d) A Table that is at least in 3NF

Candidate key

e) Something that users want to track

Composite Key

f) autonumber in MS-Access

All non-key attributes are dependent on the whole key

g) UNIQUE

Surrogate Key

h) the key chosen to be a unique identifier of a table

Foreign Key

i) a field that holds a list of values, such as phone numbers.

Multivalued attribute

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

k) A field that contains other fields, such as address

Entity

 

 

 

 

For the example below we have one big table. Put the table in 3rd 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