华南农业大学期末考试试卷A.doc

《华南农业大学期末考试试卷A.doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、华南农业大学期末考试试卷(A)————————————————————————————————作者：————————————————————————————————日期：华南农业大学期末考试试卷（A卷）2006　学年第一学期　考试科目：数据库原理与方法　考试类型：（闭卷）　　　考试时间：120分钟学号姓名年级专业2004题号一二三四五六七总分得分评阅人_____________________________________________________________________________Instructionsto

2、candidates:1.Thispaperconsistsof7questions.2.Answerallquestionsontheanswersheets.3.Handintheanswersheets,andthispapercanbetakenaway.Question1:(20marks)Definethefollowingterms.Eachtermisworth2marks.a.DBMSb.Metadatac.Entity-relationshipdatamodeld.CandidateKeye.DDLandDML

3、f.ACIDg.Deadlockh.Concurrencyschedulei.Timestampj.LogQuestion2:(21marks)Considerafactorymanagementdatabaseincludingthefollowingdataobjects:lfactory:Eachfactoryhasaname,alocation,andafactorydirectorname.Afactoryhasworkshopsanddepositories.lworkshop:Eachworkshophasauniq

4、ueid,aworkshopdirector,alocationandatelephonenumber.Accessoriesandproductsaremanufacturedintheworkshops.ldepository:Eachdepositoryhasauniqueid,adepositorydirectorandatelephonenumber.Accessoriesandproductsarestoredinthedepository.laccessory:Eachaccessoryhasauniqueid,aw

5、eightandaprice.lproduct:Eachproducthasauniqueidandaprice.lworker:Eachworkerhasauniqueid,aname,anage,atypeofwork.Start_dateindicatesthedateofstartingtoworkinaworkshop,andemployee_lengthindicatesthelengthofworkinginaworkshop;Thesystemrequirementsare:lAfactoryhasmorethan

6、oneworkshopandmorethanonedepository.lAworkshophasmorethanoneworkersandeachworkeronlyworksforoneworkshop.lAworkshopcanmakevariousaccessoriesandproducts.Thenumberofaccessoriesandthenumberofproductsmanufacturedineachworkshopisrecordedrespectively.lAdepositorstoresvarious

7、accessoriesandproducts.Thenumberofaccessoriesandthenumberofproductsstoredineachdepositorisrecordedrespectively.lEachaccessorycanbemanufacturedbymorethanoneworkshop.Similarly,eachproductalsocanbemanufacturedbymorethanoneworkshop.lAproductcanbemadebyvariousaccessoriesan

8、dakindofaccessorycanbeusedtomakevariousproducts.Thenumberofaccessorieseachproductismadebyshouldberecorded.a.DrawanE-Rdiagram