Tasks 7 - 9
TASK 7 Look back to your answer for a bank’s customer database in TASK 2. Convert the four tables you finished with into the alternative notation. The first two have been done for you.
CUSTOMER (Cust-ID, Surname, Postcode, PhoneNumber)
CUST_ACCOUNT (Cust-ID, AccountNumber)
TASK 8 Look back to your answer for a student record database in TASK 3. Convert the four tables you ended up with into the alternative notation.
TASK 9 Brown Owl keeps a record of the Brownies in her pack and what badges they have collected in a relational database. The design of the relational database is shown below.
BROWNIE: (Brownie-ID, FirstName, Surname, Address, ContactNo)
BADGE: (Brownie-ID, FirstName, Surname, Address, ContactNo, Badge-ID, BadgeDescription)
a) Describe the problems with this design.
b) Design a typical record for each Brownie.
c) Normaise the Brownie database using an analysis table.
d) Use the alternative notation to describe each table.