QUESTION 79

For the given relation schema,

EMPLOYEE(SSN, PNUMBER, NAME, PNAME)

Set of functional dependencies: SSN ? NAME

PNUMBER ? PNAME

Key: SSN, PNUMBER

What is the highest normal form for the given relation schema EMPLOYEE?

	a.	The first normal form (1NF).
	b.	The second normal form (2NF).
	c.	The third normal form (3NF).
	d.	The Boyce-Codd normal form (BCNF).

For the given relation schema,

EMPLOYEE(SSN, NAME, DNUMBER, DMGRSSN)

Set of functional dependencies: SSN ? NAME, DNUMBER

DNUMBER ? DMGRSSN

Key: SSN

Which attribute(s) is(are) the prime attribute in the relation schema?

	a.	NAME,SSN
	b.	SSN
	c.	DMGRSSN
	d.	DNUMBER

QUESTION 80

For the given relation schema,

EMPLOYEE(SSN, NAME, DNUMBER, DMGRSSN)

Set of functional dependencies: SSN ? NAME, DNUMBER

DNUMBER ? DMGRSSN

Key: SSN

Which attribute(s) is(are) the non-prime attribute in the relation schema?

	a.	SSN
	b.	NAME
	c.	DMGRSSN
	d.	DNUMBER

QUESTION 81

For the given relation schema,

EMPLOYEE(SSN, NAME, DNUMBER, DMGRSSN)

Set of functional dependencies: SSN ? NAME, DNUMBER

DNUMBER ? DMGRSSN

Key: SSN

What is the highest normal form for the given relation schema EMPLOYEE?

	a.	The first normal form (1NF).
	b.	The Boyce-Codd normal form (BCNF).
	c.	The third normal form (3NF).
	d.	The second normal form (2NF).