問題一覧
1
ALTER TABLE
2
Complete the code to create the table Departments (dep id, dep_name), where dep_name attribute has the unique constraint: CREATE TABLE Departments dep_id int PRIMARY KEY, dep_name varchar(10)
);
unique
3
Complete the code to create the table Courses (course id, name): CREATE TABLE Courses course_id int, name varchar(10), ..
_ (course_id));
PRIMARY KEY
4
Complete the code to create the table Students (stud id, last_name): CREATE TABLE Students stud_id int, last_name varchar(20), _
_ (stud_id));
PRIMARY KEY
5
Complete the code to create the table Groups (group idPK, group_name):Groups( group_id int PRIMARY KEY, group_name varchar(20));
CREATE TABLE
問題一覧
1
ALTER TABLE
2
Complete the code to create the table Departments (dep id, dep_name), where dep_name attribute has the unique constraint: CREATE TABLE Departments dep_id int PRIMARY KEY, dep_name varchar(10)
);
unique
3
Complete the code to create the table Courses (course id, name): CREATE TABLE Courses course_id int, name varchar(10), ..
_ (course_id));
PRIMARY KEY
4
Complete the code to create the table Students (stud id, last_name): CREATE TABLE Students stud_id int, last_name varchar(20), _
_ (stud_id));
PRIMARY KEY
5
Complete the code to create the table Groups (group idPK, group_name):Groups( group_id int PRIMARY KEY, group_name varchar(20));
CREATE TABLE