Keys+Questions

Questions
1. Choose a suitable primary key for each of the following tables. In each case write a short sentence explaining why you chose that primary key, and whether there were other keys you considered before making your choice.

(a) BOOK (ISBN, Author, Publisher, Publication Date, Title)

(b) DVDMEMBER(Member Number, Name, Telephone Number)

(c) COMPUTER(Serial Number, Make, Model, Processor, RAM)

(d) CUSTOMER(Customer Number, Name, Address, Postcode)

(e) ORDER(Customer Number, Item Number, Date, Quantity)

(f) ORDER(Order Number, Customer Number, Item Number, Date, Quantity)

2. Here are three entities which are part of a hospital database system:

PATIENT (PatientName, PatientMob, NatInsNo) CONSULTANT (ConsultantNo, ConsultantName) BED (BedNo, WardNo)

Indicate in each case a suitable primary key. Write down any assumptions that you make about the data.