ssd7 exercise7 答案

/*
*@author:wangzhesi
*053597
*/
*****Step1*****
For strong entity,Create a new table.Including as its columns, all the simple attributes and simple components of the composite attributes . 
We map all the entities types into tables and define their primary keys PKs and alternate keys AKs.Do not include any multi-valued attribute as a key. 

Book(Author,Title, ISBN, Edition, PublicationDate, Price, BookDescription)
PK(ISBN)

Publisher(Publisher_id, PublisherName, PublisherAddress)
PK(Publisher_id)

Author(Author_id, AuthorName)
PK(Author_id)

Categories(Categories_id, CategoriesName)
PK(Categories_id)

Promotion(Promotion_id, Discount, StartDate, EndDate)
PK(Promotion_id)

Orders(Order_num, MailAddress, MethodShipment, ShippingDate, DateOrderTime)
PK(Order_num)

Customer(Customer_id, CustomerName, MailAddress, CreditNumer, EmailAddress)
PK(Customer_id)

Shipment(Tracking_num, ShipmentDate, Order_num, ExpectedDate)