relational-schema.txt

卡耐基梅陇大学网上教程ssd7 exercise7的答案。绝对正确 满分

Exercise Six

Relational Schema(use the uniform names):

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)