2. (15 pts) For the following relational schema, ProductId ProductName Catld Cat

Question

2. (15 pts) For the following relational schema, ProductId ProductName Catld CatName Price And the following given functional dependencies (besides the one implied by the primary key, for which fields are underlined): Catld CatName . (a) (5 pts) specify which normal form this schema is in (b) (10 pts) if the schema is not in 3NF, convert it to 3NIF 3. (20 pts) For the following relational schema, me And the following given functional dependencies (besides the one implied by the primary key, for which fields are underlined) InmateNo Name CrimeCode Description · (a) (5 pts) specify which normal form this schema is in (b) (15 pts) if the schema is not in 3NF, convert it to 3NF,

Explanation / Answer

Answer1) It is 2NF.

Following is a step by step process to determine the same:

a)A table is in 1NF if each attribute of a table have single values; hence it passes 1NF.

b)A table is in 2NF if no non-prime attribute(Product Name,CatId,CatName,Price) is dependent on the proper subset of any candidate key(ProductId) of table hence it passes for 2NF as well.

c)A table is in 3NF if it is in 2NF and for each functional dependency X-> Y(CatId-->CatName) at least one of the following conditions hold:

Both of the above conditions are not satisfied hence it is not in 3NF(CatId is not super key and CatName is not a prime attribute).

3NF version will be something like this:

Table 1:ProductId,ProductName,CatId,Price

Table 2:CatId,CatName

Answer2) It is 1NF.

Following is a step by step process to determine the same:

a)A table is in 1NF if each attribute of a table have single values; hence it passes 1NF.

b)A table is in 2NF if no non-prime attribute(Name,Description,Disposition) is dependent on the proper subset of any candidate key(InmateNo,CrimeCode,Arrestdate) of table hence it does not pass for 2NF.

3NF version will be something like this:

Table1: InmateNo,Name

Table2:CrimeCode,Description

Table3:InmateNo,CrimeCode,ArrestDate,Disposition,Counts

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.