Currently im trying to do an assignment question which is assigned to me which is asking me the normalization process. im aware of the 3 normal form. but im stuck with the 2nd and 3rd normalisation form because i feel that im going to get the similar answer. Am i doing something wrong? My UNF and 1NF forms are below:
UNF:
Employee_Id, Employee_Gender, Employee_Position, Employee_Name, Employee_First, Employee_Last, Member_Id, Member_ Name, Member_ First, Member_ Last, Member_ Feedback, Location_Branch_Id, Dvd_Branch_Stock, Branch_Location, Location_Area, DVD_Id, DVD_Title, DVD_Quantity, DVD_Genres, DVD_Released_Date, Rental_ID, Rental_Borrowed_Date, Rental_Due_Date, Rental_Overdue, Rental_Dvd_Title,Rental_Status
1NF:
Employee_Id
Employee_Gender
Employee_Position
Employee_Id
Employee_Name
Employee_First
Employee_Last
Member_Id
Member_ Feedback
Member_Id
Member_ Name
Member_ First
Member_ Last
Location_Branch_Id
Location_Area
Location_Branch_Id
Dvd_Branch_Stock
Branch_Location
DVD_Id,
DVD_Quantity
DVD_Id
DVD_Title
DVD_Genres
DVD_Released_Date
Rental_ID
Rental_Dvd_Title
Rental_ID
Rental_Borrowed_Date
Rental_Due_Date
Rental_Overdue
Rental_Status
2NF:
Employee_Id
Employee_Gender
Employee_Position
Employee_Id
Employee_Name
Employee_Name
Employee_First
Employee_Last
Member_Id
Member_ Feedback
Member_Id
Member_ Name
Member_ Name
Member_ First
Member_ Last
Location_Branch_Id
Location_Area
Location_Branch_Id
Dvd_Branch_Stock
Dvd_Branch_Stock
Branch_Location
DVD_Id,
DVD_Quantity
DVD_Id
DVD_Title
DVD_Title
DVD_Genres
DVD_Released_Date
Rental_ID
Rental_Dvd_Title
Rental_ID
Rental_Borrowed_Date
Rental_Borrowed_Date
Rental_Due_Date
Rental_Overdue
Rental_Status
What should i do for 3NF???
Currently im trying to do an assignment question which is assigned to me which is asking me the normalization process. im aware of the 3 normal form. but im stuck with the 3rd normalisation form because i feel that im going to get the similar answer. Am i doing something wrong? My UNF and 1NF forms are below:
UNF:
Employee_Id, Employee_Gender, Employee_Position, Employee_Name, Employee_First, Employee_Last, Member_Id, Member_ Name, Member_ First, Member_ Last, Member_ Feedback, Location_Branch_Id, Dvd_Branch_Stock, Branch_Location, Location_Area, DVD_Id, DVD_Title, DVD_Quantity, DVD_Genres, DVD_Released_Date, Rental_ID, Rental_Borrowed_Date, Rental_Due_Date, Rental_Overdue, Rental_Dvd_Title,Rental_Status
1NF:
Employee_Id
Employee_Gender
Employee_Position
Employee_Id
Employee_Name
Employee_First
Employee_Last
Member_Id
Member_ Feedback
Member_Id
Member_ Name
Member_ First
Member_ Last
Location_Branch_Id
Location_Area
Location_Branch_Id
Dvd_Branch_Stock
Branch_Location
DVD_Id,
DVD_Quantity
DVD_Id
DVD_Title
DVD_Genres
DVD_Released_Date
Rental_ID
Rental_Dvd_Title
Rental_ID
Rental_Borrowed_Date
Rental_Due_Date
Rental_Overdue
Rental_Status
2NF:
Employee_Id
Employee_Gender
Employee_Position
Employee_Id
Employee_Name
Employee_Name
Employee_First
Employee_Last
Member_Id
Member_ Feedback
Member_Id
Member_ Name
Member_ Name
Member_ First
Member_ Last
Location_Branch_Id
Location_Area
Location_Branch_Id
Dvd_Branch_Stock
Dvd_Branch_Stock
Branch_Location
DVD_Id,
DVD_Quantity
DVD_Id
DVD_Title
DVD_Title
DVD_Genres
DVD_Released_Date
Rental_ID
Rental_Dvd_Title
Rental_ID
Rental_Borrowed_Date
Rental_Borrowed_Date
Rental_Due_Date
Rental_Overdue
Rental_Status
What should i do for 3NF???