数据库模拟试
题
快递公司问题件快递公司问题件货款处理关于圆的周长面积重点题型关于解方程组的题及答案关于南海问题
及
答案
八年级地理上册填图题岩土工程勘察试题省略号的作用及举例应急救援安全知识车间5s试题及答案
(英文)
Exam of Database Technology & Applications
1. Describe the three levels and data independence.
2. What are key constraints and foreign constraints?
3. Explain LEFT JOIN, OUTER JOIN and INNER JOIN.
4. For the following relation schema and sets of FD’s: R is (A, B, C, D, E, F,G) with
FD’s A-> B, B-> C, A-> E, CD->G.
1) Identify the candidate key(s) for R.
2) Identify the best normal form that R satisfies
3) Decompose it in 3NF if necessary.
1
5. Explain the ACID properties.
6. Notown Records has decided to store information about musicians who perform on its albums (as well as other company data) in a database. The company has chosen to hire you as a database designer.
, Each musician that records at Notown has an SSN, a name, an address, and a
phone number.
, Each instrument used in songs recorded at Notown has a name (e.g., guitar,
synthesizer,flute) and a musical key (e.g., C, B-flat, E-flat). , Each album recorded on the Notown label has a title, a copyright date, a format
(e.g.,CD or MC), and an album identifier.
, Each song recorded at Notown has a title and an author.
, Each musician may play several instruments, and a given instrument may be
played by several musicians.
, Each album has a number of songs on it, but no song may appear on more than
one album.
, Each song is performed by one or more musicians, and a musician may perform a
number of songs.
, Each album has exactly one musician who acts as its producer. A musician may
produce several albums, of course.
1) Defining the completed E-R diagram.
2) Defining information for each relation.
2
7. Consider the following relational schema and give T-SQL expressions for the following queries.
Sailors(sid, sname, age)
Boats(bid, bname, color)
Reservers(sid, bid , day)
1)Create the table Sailors (sid, sname , age). It includes the domain of values associated with each attribute and integrity constraints.
NOT NULL PRIMARY KEY sid INT
sname VARCHAR(10) NOT NULL
age INT NULL 0
本文档为【数据库模拟试题及答案(英文)】，请使用软件OFFICE或WPS软件打开。作品中的文字与图均可以修改和编辑，
图片更改请在作品中右键图片并更换，文字修改请直接点击文字进行修改，也可以新增和删除文档中的内容。
该文档来自用户分享，如有侵权行为请发邮件ishare@vip.sina.com联系网站客服，我们会及时删除。
[版权声明] 本站所有资料为用户分享产生，若发现您的权利被侵害，请联系客服邮件isharekefu@iask.cn，我们尽快处理。
本作品所展示的图片、画像、字体、音乐的版权可能需版权方额外授权，请谨慎使用。
网站提供的党政主题相关内容(国旗、国徽、党徽..)目的在于配合国家政策宣传，仅限个人学习分享使用，禁止用于任何广告和商用目的。
浙公网安备 33021202002483