(1) Create a clustered index on the student number sno of the student table; (2) In...

 

Transcribed Image Text:

(1) Create a clustered index on the student number sno of the student table; (2) In the student table, create a non-clustered index for the name sname; (3) Create a unique index on the course number Cno of the curriculum; (4) Establish a composite index on the student number sno and grade grade of the course selection schedule, requiring the student number to be in ascending order, and the grade in descending order when the student number is the same; (5) Delete the index of the student table with drop; Analytical summary Lab 1 Database definition Purpose of the experiment 1. Master SQL data definition functions: database definition, table definition, index definition (optional) Experimental content 1. Create a school database (1) Student Form Column name illustrate SNO SNAME SGENDER SAGE SDEPT Student number CNO name GRADE age (2) Course Schedule Column name illustrate CNO CNAME CCREDIT Credits SEMSTER semester PERIOD Hours Department (3) Course Selection Table SC Column name illustrate SNO Course number Course name Student number Course number grades data type CHAR(7) CHAR(10) CHAR(2) SMALLINT VARCHAR(20) data type CHAR(10) VARCHAR(20) SMALLINT SMALLINT SMALLINT data type CHAR(7) CHAR(10) SMALLINT restraint Master code NOT NULL Take "female" The values are 15-45 Default Computer Department or restraint Master code NOT NULL Greater than 0 Greater than 0 Greater than 0 restraint The main code, which refers to the foreign code of Student The main code, which refers to the foreign code of Course Greater than 0 (1) Create a clustered index on the student number sno of the student table; (2) In the student table, create a non-clustered index for the name sname; (3) Create a unique index on the course number Cno of the curriculum; (4) Establish a composite index on the student number sno and grade grade of the course selection schedule, requiring the student number to be in ascending order, and the grade in descending order when the student number is the same; (5) Delete the index of the student table with drop; Analytical summary Lab 1 Database definition Purpose of the experiment 1. Master SQL data definition functions: database definition, table definition, index definition (optional) Experimental content 1. Create a school database (1) Student Form Column name illustrate SNO SNAME SGENDER SAGE SDEPT Student number CNO name GRADE age (2) Course Schedule Column name illustrate CNO CNAME CCREDIT Credits SEMSTER semester PERIOD Hours Department (3) Course Selection Table SC Column name illustrate SNO Course number Course name Student number Course number grades data type CHAR(7) CHAR(10) CHAR(2) SMALLINT VARCHAR(20) data type CHAR(10) VARCHAR(20) SMALLINT SMALLINT SMALLINT data type CHAR(7) CHAR(10) SMALLINT restraint Master code NOT NULL Take "female" The values are 15-45 Default Computer Department or restraint Master code NOT NULL Greater than 0 Greater than 0 Greater than 0 restraint The main code, which refers to the foreign code of Student The main code, which refers to the foreign code of Course Greater than 0

Answer rating: 100% (QA)

Code for Creating a school database with three tables Student Form Course Schedule and Course Select... View the full answer