sql 大神请进

asuka0099

final 来了  老师给的复习题不会肿么办？ 求各位学霸帮忙。

1.Create a table Movie_Stars, which has the following columns:

Movie Number           numeric

Movie Title                varying character        25  

        Year Released           date and time              (required)

        First Name                varying character        15      

        Last Name                varying character               15

Be sure that the movie_number column is used as a way to uniquely identify a particular movie.

2.A) WITHOUT recreating the table again, add the column Movie_Category

      varying character 15 to the Movie_Stars table.

B) Make the movie_Category be required.  You MUST present two different         solutions for this part of the question）

3.Create a sequence, which starts with 10 and goes 10 numbers at a time.  Make sure that your sequence does not cache any values. e.g. 10,20,30….

4.Write the SQL statement to insert the following row into the Movie_Stars table structure:

The row values are:

Sequence #, New York Stories, January 1 1984, Nolte, Nick, Drama

Sequence #, Speed, 1999, FEB 12, Keanu, Reeves, Action

Sequence #, Bowfinger, 2001, August 03, Eddie, Murphy, Comedy

Make sure that you use the sequence you created in question 3 above to assign the sequence numbers to the three records.

bibimaybe2

你有ERwin 吗，我都是先在ERwin create the table then forward engineer to SQL.
第一个问题你就把Movie_Number 设成primary key 就好了, 2A 直接加在原来的table 就好了，2B 是设置问题而已
3 你的话，你自己把data 放到SQL 上，我都是在ERwin 弄好table, forward the SQL 上，再用
INSERT INTO MOVIE_STARS_t (MovieNumber, MovieTitle.......)...
4 把data弄上去以后就可以写４的statements 啦

子涵是个死小孩

楼主。。。我只想说这些难道不是SQL的基本语法么？？？？？你随便百度一下都能出现类似的

778小铺

那么多人学数据库