Question: Based on this data dictionary implement normalisation of all tables to 3rd Normal Forms. Branch P/F Field Name Data Type Size Notes P Branch ID
Based on this data dictionary implement normalisation of all tables to 3rd Normal Forms.



Branch P/F Field Name Data Type Size Notes P Branch ID Number/int 10 Unique ID 250 Street Text City Text 20 Tele No Text 15 Staff P/F Field Name Data Type Size Notes P Staff ID Number/int 10 unique ID Staff Name 20 Text Text 20 Designation Number/int F Branch ID 10 Salary 10 int Branch P/F Field Name Data Type Size Notes P Branch ID Number/int 10 Unique ID 250 Street Text City Text 20 Tele No Text 15 Staff P/F Field Name Data Type Size Notes P Staff ID Number/int 10 unique ID Staff Name 20 Text Text 20 Designation Number/int F Branch ID 10 Salary 10 int
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
