SSD7 unit3 exercise7

S1:
T1:Customer(ID,mailAdrr,PhoneNumber,EmailAddr)
   PK(ID)
   AK(EmailAddr)
   AK(PhoneNumber)
T2:Orders(OrderNum,ShipType,OrderDate,willShipDate)
   PK(OrderNum)
T3:BookTitle(Author,Title,ISBN,Edition,DateOfPublication,Price,descriptionOfBook)
   PK(ISBN)
T4:Publisher(Name,Addr)
   PK(Name)

S2:
T1:Customer(ID,mailAdrr,PhoneNumber,EmailAddr,fname,mname,lname,CardNum,expirationDate)
   PK(ID)
   AK(EmailAddr,PhoneNumber,CardNum)
T8:Promotion(ID,percentage,startDate,endDate)

S5:
T2:Orders(OrderNum,ShipType,OrderDate,CustmerId,willShipDate)
   PK(OrderNum)
   FK(CustomerId)->Customer(ID)
T3:BookTitle(Author,Title,ISBN,Edition,DateOfPublication,descriptionOfBook,Publisher,Price)
   PK(ISBN)
   FK(Publisher)->Publisher(Name)

S6:
T5:Order_Book(OrderNum,ISBN,quantity)
   PK(OrderNum,ISBN)
   FK(OrderNum)->Order(OrderNum)