数据库模拟试题及答案(英文).docVIP

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. 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