资源描述：
《数据库兰茜苏浩辉魏杰小组作业二.doc》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、SchoolofEconomics&BusinessAdministrationChongqingUniversityGroupProjectMilestone#02CourseNameDatabasePrincipleandApplicationProjectNameOnlyBooksInc.DatabaseMissionTeamMembersStudentIDNameClassMajor20100375魏杰01信管20100357兰茜01信管20100373苏浩辉01信管InstructorDr.YongLiTuto
2、rBowenZhangCompletedDate2012-4-16ScoreBOOK（ISBN,Name,P_Name,Date_Published,Edition,List_Price,Cost_Price,Kind,Type）ConstraintNameUNIQUENOTNULLConstraintDate_PublishedNOTNULLConstraintEditionNOTNULLConstraintList_PriceNOTNULLConstraintCost_PriceNOTNULLConstraintKi
3、ndIN(‘Art’,‘Business’,‘Management’,‘Children’,‘Computers’,‘Fiction’,‘Health’,‘Home’,‘Garden’)ConstraintTypeIN(‘paperback’,‘hardboundvolumes’)Foreignkey(P_Name)ReferencesPUBLISHERCHILDREN_BOOK(ISBN,Suitable_For_Age_Group)Foreignkey(ISBN)ReferencesBOOKConstraintSui
4、table_For_Age_GroupIN(‘infant’,‘earlyreader’,‘olderreader’,‘teenclassics’)B&M_BOOK(ISBN,Specialization)Foreignkey(ISBN)ReferencesBOOKConstraintSpecializationNOTNULLCOMPUTER_BOOK(ISBN,CD_INSIDE)Foreignkey(ISBN)ReferencesBOOKConstraintCD_INSIDEIN(‘yes’,‘no’)BOOK_AU
5、THOR(ISBN,A_Name,Auther_Order)Foreignkey(ISBN)ReferencesBOOKForeignkey(A_Name)ReferencesAUTHORAUTHOR(A_Name,Age)ConstraintAgeNOTNULLPUBLISHER(P_Name,Address,Phone_Num,Discount_List_Price)ConstraintAddressNOTNULLConstraintPhone_NumNOTNULLConstraintDiscount_List_Pr
6、iceNOTNULLCUSTOMER(C_Name,Address,Phone_Num,Email_Add,Cre_Card_Num,Cre_Card_Exp)ConstraintAddressNOTNULLConstraintPhone_NumNOTNULLConstraintEmail_AddNOTNULLLREVIEWS(C_Name,Name,Submission_Date,Comment,Star_Rating)Foreignkey(C_Name)ReferencesCUSTOMERForeignkey(Nam
7、e)ReferencesBOOKConstraintSubmission_DateNOTNULLConstraintCommentNOTNULLLConstraintStar_RatingIN(‘one’,‘two’,‘three’,‘four’)DEFAULT‘four’ORDER(Order#,C_Name,ISBN,Date_Plased,Selling_Price,Copy_Num)ConstraintDate_PlasedNOTNULLConstraintSelling_PriceNOTNULLConstrai
8、ntCopy_NumNOTNULLForeignkey(C_Name)ReferencesCUSTOMERForeignkey(ISBN)ReferencesBOOKBUY(P_Name,ISBN,Quantity,Date_Buy,Cost_Price)Foreignkey(ISBN)ReferencesBOOKF
