数据库SQL基础作命令业及答案(国外英文资料).docVIP

数据库SQL基础作命令业及答案(国外英文资料) First, the definition and deletion of the basic table Problem 1: Create the following three tables using the SQL statement: the students (Student), the course schedule (Course), and the student choice table (SC). The structure of the three tables is shown in Table 1-1 through table 1-3. Answer： Create, table, Student Sno nchar (7) primary key, Sname nchar (10) not null, Ssex nchar (4) check (Ssex=male or Ssex=female), Sage number (3) check (Sage=15, and, Sage=45), Sdept nchar (20) default (Computer Department) ); Create, table, course CNO nchar (10) primary key, CNAME nchar (20) not null, Ccredit number check (ccredit0), Semster number check (semster0), Period number check (period0) ); Create, table, SC SnO nchar (7), CNO nchar (10), Grade, number, check (grade=0, and, grade=100), Primary key (SnO, CNO), Foreign, key (SnO), References, student (SnO), Foreign, key (CNO), References, course (CNO) ); Table 1-1 Student table structure Column name data type constraint Sno student string, length 7 yards Sname name string, length 10, non empty Ssex gender string, length 2, take male or female Sage age integer value 15~45 Sdept is a string of length 20 and defaults to computer system ------------------------------------------------------------------------------------------------------------------- Table 1-2Course table structure Column name data type constraint Cno course number string, length 10 master code Cname course name string, length 20, non empty Ccredit credits, integer values greater than 0 Semster semester integer values greater than 0 Period integer values greater than 0 ------------------------------------------------------------------------------------------------------------------- Table 1-3 SC table structure Column name data type constraint Sno number of students string, length of 7 master code, citing the outer Student code Cno course name string, length 10, master code, reference Course Grade scores integer values 0~100 -----------