数据库作业答疑.pptVIP

数据库作业答疑 向小岩 刘沾沾 2006年5月 第一次作业 P18 1.3、1.5、1.7 P36 2.4、2.5、2.6 1.3 参见课本P19 1.5 参见课本P9 1.7 参见课本P20 2.4 参见课本P29 2.5 参见课本P27 如果用户和用户的应用程序能相对于数据库物理结构的改变而保 持不变，则实现了物理独立性；如果用户和用户的应用程序能相 对于数据库逻辑结构的改变而保持不变，则实现了逻辑独立性。 2.6 参见课本P30 “数据字典”相关内容 第二次作业 P52 3.2、3.3 3.3 见P.54参考答案 3.2 TABLE 第二次作业 第三次作业 讲义Chapter 4 SQL(1)第90面 题目： Write the following queries, based on the following database example： Movie (title, year, length, inColor, studioName, producerC#) StarsIn (movieTitle, movieYear, strName) MovieStar (name, address, gender, birthdate) MovieExec (name, address, cert#, netWorth) Studio (name, address, presC#) Classes (class, type, country, numGuns, bore, displacement) Ships (name, class, launched) Battles (name, date) Outcomes (ship, battle,result) 第三次作业 In SQL. 1. Find Sandra Bullock’s birthdate 2. Find all executives worth at least $10,000,000 3. Find all the stars who either are male or live in Malibu 4.Which stars appeared in movies produced by MGM in 1995? 5. Who is the president of MGM studio? 6. Find the countries whose ships had the largest number of guns. 7. Find the names of the ship with 16-inch bore. 8. Find the average number of guns of battleship classes. 第三次作业 1． select birthdate from MovieStar where name = ‘Sandra Bullock’; 2. select name from MovieExec where netWorth = 3. select name from MovieStar where gender = ‘male’ or address = ‘Malibu’; 4. select distinct StarsIn.starName from StarsIn, Movie where StarsIn.movieTitle = Movie.title and Movie.year = 1995 and Movie.studioNmae = ‘MGM’; 第三次作业 5. select MovieE from MovieExec, Studio where MovieExec.cert# = Studio.presC# and S = ‘MGM’; 6. select country from ( select country, sum (numGuns) sumGuns from Classes group by country ) where sumGuns = max (sumGuns); 另一种方式： select country from Classes where numGuns = max (numGuns); 7. select S from Ships, Classes