er.txt

SSD7 EXCISE 5 大家应急一下哈 本人学生

Entities:
1 BOOKTITLE:Author,Title,ISBN, Publisher, Edition, Date of Publication, Price, Book Description, Categories;
2 PUBLISHER: Publisher Name, Address;
3 CUSTOMER: Name(Fname,MI,Lname), Mailing Address, Credit Card Number, Expiration Date, Phone Numbe, EmailAddressr;
4ORDER:OrderNumber,Customer{Name(Fname,MI,Lname)},MailingAddress,CreditCard,Shipment(delivery,post), ShippingDate, Date, TimeOrder, PriceOrder{ISBN, TitlePrice (price, PurchasePrice), Quantity, ShippingCost, Tax};
5FULLFILLEDORDER:OrderNumber,DateofShipment,TrackingNumber,DateofExpectedDelivery,TitlesShipped,TitlesQuantity;

Weak Entity:
DELIVERY: TrackingNumber, DateofExpectedDelivery;
PROMOTION:BeingPromoted, PercentageDiscountPoints, Duration(Sdate,Edate);
Relationships:
1.	ORDER:< CUSTOMER, BOOKTITLE>,M:N,PARTIAL/PARTIAL;
2.	PUBLISH:<BOOKTITLE,PUBLISHER>,M:N, PARTIAL/PARTIAL;
3.	HOLD:< CUSTOMER, ORDER >,1:N, PARTIAL/PARTIAL
         < CUSTOMER, FulfilledOrder>,1:N,PARTIAL/PARTIAL;

4.	PROMOTE:<BOOKTITLE,PROMOTE>,1:N, PARTIAL/PARTIAL;
5.	DELIVER:<PUBLISGER,ORDER>,1:N, PARTIAL/TOTLE
  < PUBLISGER,FULLFILLEDORDER>,1:N, PARTIAL/TOTLE;
6.CHECK:<PUBLISHER,DELIVERY>,1:N,TOTLE/TOTLE;

Some Assumptions/Clarification:
1.	One author writes one or more titles.
2.	Several co-authors write one or more titles.
3.	Not all titles need necessarily be of books ,howerver,all books must have a title and only one title.
4.	One title only has one isbn.
5.	One publisher can have one or more delivery.
6.	One book has a edtion during a fixed time.
7.	A book has aunique title.
8.	A book has fixed promote during a fixed time.
9.	A customer can order one or more books into one order or more orders at a time..
10.	A publisher can publish one or more books.
11.	A publisher make ture that one or more delivery agency deliver orders.
12.	A customer can hold one or more orders.
13.	A delivery agency will deliver different orders.