A database has been designed to store data about programmers and the programs they have developed.
These facts help to define the structure of the database:
– Each programmer works in a particular team.
– Each programmer has a unique first name.
– Each team has one or more programmer.
– Each program is for one customer only.
– Each programmer can work on any program.
– The number of days that each programmer has worked on a program is recorded.
The table ProgDev was the first attempt at designing the database.

a) State why the table is not in first normal form (1NF).
b) The database design is changed to:
Programmer (FirstName, Team)
Program (FirstName, ProgramName, No Of Days, Customer)
Using the data given in the first attempt table (ProgDev), copy and complete these revised table designs to show how these data are now stored.

c) i) A relationship between the two tables has been implemented.
Explain how this has been done.
ii) Explain why the Program table is not in third normal form (3NF).
iii) Write the table definitions to give the database in 3NF.

Transcribed Image Text:

FirstName Team WC NoofDays ProgramName TV control Customer Alice 3 SKM Ice alert 2 WZP Digital camera 6 HNC Charles PC Oil flow 1 GEB Rescue Pack BGF Ahmad QR TV control SKM Accounts 8 ARC Digital camera 4. HNC Test Pack GKN 3