SSD7EX7

1. BookTitle(B_ISBN,B_Title,B_Author,Pub_num,B_Edition,B_DatePublished,B_Price,B_Discount,B_Description,B_qutlnStore,Categ_num); PK (B_ISBN) FK (Pub_num)->Publisher(Pub_num) FK (Categ_num)->Category(Categ_num) 2. Categ_contain_Categ(Large_Categ_num,Small_Categ_num); PK(Large_Categ_num,Small_Categ_num) FK(Large_Categ_num)->Category(Categ_num) FK(Small_Categ_num)->Category(Categ_num) 3. Category(Categ_num,Categ_name); PK(Categ_num) 4. CreditCard(CredCar_num,CredCar_ExpDate,CredCar_type,C_num); PK(CredCar_num) FK(C_num)->Customer(C_num) 5. Customer(C_num,C_Email,C_Fname,C_Mname,C_Lname,C_addrCountry,C_addrState,C_addrCity,C_addrAvg,C_zipCode,C_phNum,C_loginPaWo); PK(C_num) AK(C_Email) 6. DeliveryAgency(DA_num,DA_name,DA_phone); PK(DA_num) AK(DA_phone) 7. OrderLine(O_num,B_ISBN,OL_btQUT,S_sum); PK(O_num,B_ISBN) FK(B_ISBN)->BookTitle(B_ISBN) FK(O_num)->Order(O_num) 8. Order(O_num,C_num,O_mailAddress,credCar_num,O_shippingdate,O_placedate,O_shipmethod,O_totalcost); PK(O_num) FK(C_num)->Customer(C_num) FK(credCar_num)->CreditCard(credCar_num) 9. Promotion(B_ISBN,P_DueDate); PK(B_ISBN) FK(B_ISBN)->BookTitle(B_ISBN) 10. Publisher(Pub_num,Pub_name,Pub_Address); PK(Pub_num) 11. Shipment(S_num,O_num,S_date,DA_num); PK(S_num) FK(O_num)->Order(O_num) FK(DA_num)->DeliveryAgency(DA_num)