Question

Analyze the following scenarios and mention in which normal form it is with reason.

a) Book - bookID, bookTitle, Publish Name, Publisher Address
b) Order - Order_No, Product_ID, Product Description
c) Part - Part_ID, Part Description, Part Price
d) Student - S_ID, CNIC, Address, S_Name
e) Department - Dep_No, Location, Dep_Name, Manager_Name, Manager_ID

Answer 1

The scenarios are categorized as being in the First Normal Form (1NF). However, the 'Department' scenario is in the Second Normal Form (2NF).

Step-by-step explanation:

a) The scenario of 'Book' can be categorized as being in the First Normal Form (1NF) because it contains repeating groups of data. To normalize it, we would separate the repeating data into a separate table with a primary key.

b) The scenario of 'Order' is also in the First Normal Form (1NF) because it contains repeating groups of data. To normalize it, we would separate the repeating data into a separate table with a primary key.

c) The scenario of 'Part' is in the First Normal Form (1NF) as well because it contains repeating groups of data. To normalize it, we would separate the repeating data into a separate table with a primary key.

d) The scenario of 'Student' is in the First Normal Form (1NF). There are no repeating groups of data in this scenario.

e) The scenario of 'Department' is in the Second Normal Form (2NF) because it has a composite primary key and there is a partial dependency existing. To normalize it, we would separate the data into two tables, with one table containing the composite primary key and the other containing the dependent attributes.