ssd7 ex6.zip_9XG_postgresql_ssd7_ssd7 ex6

Publisher(PublishID,PublisherName,Address) PK(PublishID) AK(Publisher_Name,Address) FK��none Book(ISBN,Title,Edition,DateOfPublication,Price,BookDescription,PublisherID) PK(ISBN) AK:none FK(PublisherID)->Publisher(PublisherID) Author(AuthorName,AuthorID) PK(AuthorID) AK:none FK:none Customer(CustomerID,firstName,middlename,lastname,MailingAdress,CCNED,PhoneNumber,EmailAdress) PK(CustomerID) AK(CCNED) FK:none Shipment(DateOfShipment,TrackingNumber,DateOfExpectedDelivery) PK(CustomerID) AK:none FK:none Order(OrderNumber,MailingAddress,MethodOfShipment,DateAndTimeOfOrder,CustomerID,TotalPrice) PK(OrderNumber) AK:none FK(CustomerID)->Customer(CustomerID) Promotion(PromotionID,PercentageDiscountPoints,Duration) PK(PromotionID) AK:none FK:none LineItem(Quantity,ISBN,TotalPrice,OrderNumber,ShipmentID) PK(OrderNumber,ISBN) AK:none FK(ISBN)->Book(ISBN) FK(Ordernumber)->Order(OrderNumber) FK(ShipmentID)->Shipment(trackingnumber) Category(CategoryID,CategoryName) PK(CategoryID) AK:none FK:none Categoryre(CategoryID,SuperCategoryID) PK(CategoryID) AK:none FK(SuperCategoryID)->Category(CategoryID) FK(CategoryID)->Category(CategoryID) Book_Author(ISBN,AuthorID) PK(ISBN,Authorid) AK:none FK(ISBN)->Book(ISBN) FK(AuthorID)->Author(AuthorID) Book_Category(ISBN,CategoryID) PK(ISBN,CategoryID) AK:none FK(ISBN)->Book(ISBN) FK(CategoryID)->Category(CategoryID) Book_Promotion(ISBN,PromotionID) PK(ISBN,PromotionID) AK:none FK(ISBN)->Book(ISBN) FK(PromotionID)->Promotion(PromotionID)