资源描述:
《《数据库原理与应用》复习大纲(review outline of database principles and applications)》由会员上传分享,免费在线阅读,更多相关内容在应用文档-天天文库。
1、《数据库原理与应用》复习大纲(ReviewoutlineofdatabaseprinciplesandApplications)Reviewoutlineofdatabaseprinciplesandapplications!ReviewoutlineofdatabaseprinciplesandApplicationsThefirstpartofthequestiontypeThistestisahundredpointsystem,includingfourquestions:choosequesti
2、ons,fillintheblanks,answerquestions,answerquestions.Pleasefilloutalltheanswersontheanswersheetandanswerthequestionsonthetestpaper.Herearethefollowingquestions:Asinglechoice(tochooseacorrectansweroptionsineverydaythenumbersintheparentheses,everyday2points,
3、atotalof40points)Example:inthedatabase,thephysicalindependenceofthedatarefersto(1)ThemutualindependencebetweenAdatabaseanddatabasemanagementsystemThemutualindependencebetweenBuserprogramandDBMSTheCuser'sapplicationisindependentofthedatastoredonthediskdata
4、baseThelogicalstructureofdatainDapplicationsanddatabasesisindependentofeachotherTwo,fillintheblanks(1pointsperminute,atotalof13points)Example:datamodelconsistsofthreeparts:datastructure,(1)and(2).Three,simpleanswer(twoquestions,10points)Examples:abriefdes
5、criptionofeachstageofthedatabase.Four,answerquestions(37points)1,databasedesignquestions(11points)2,therelationshipbetweenalgebra(4items,8points)3,SQLstatementquestions(write)(18points)Example:ifthereisarelationaldatabaseasfollows:Employee(employee.name,s
6、treet,city)Works(employee.name,company.name,salary)Company(company.name,city)Manages(employee.name,managers.name)Forthefollowingquery,arelationalalgebraexpressionandaSQLqueryexpressionaregiven.(1)findoutthenamesofallemployeesinFirstBankCorporation;(2)find
7、outallthestaffnamesandresidencecitiesofFirstBankCorporation;(3)findoutthenamesofalltheemployeeswholiveinthesamecityandworkinthesamecity.ThesecondpartisthemainpointsofeachchapterChapter1.Introductiontodatabasesystem1,masterthedifferencebetweendataandinform
8、ation2,thecharacteristicsofdatabasemanagementphase3.Thecompositionofdatabasesystem4.Thethreelevelschemastructureofdatabase5.Thecharacteristicsofdatabasesystem6,DBMS7,entity,connection,attribute8.Thedatabaselanguagei