- 76
- 0
- 约1.95万字
- 约 42页
- 2018-09-14 发布于湖北
- 举报
分布式数据库系统
06工硕作业
2007.02.03 csli整理
第一次作业 PPT4 关系数据库语言
Exercise
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#)
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 m
原创力文档

文档评论(0)