Write create table statement to create student, course, and registration tables. For each table, you...

Question

Write create table statement to create student, course, and registration tables. For each table, you can decide the attributes and data types of attributes based on your own understanding.

David · Accepted Answer

Student Table 
CREATE TABLE student ( 
StudentNo INT NOT NULL , 
StudentName VARCHAR(30) NOT NULL , 
DOB DATE NOT NULL , 
Section VARCHAR(1) NULL , 
Address VARCHAR(45) NULL , 
City VARCHAR(20) NULL , 
State VARCHAR(20) NULL , 
Zip INT NOT NULL ,

Write create table statement to create student, course, and registration tables. For each table, you can decide the attributes and data types of attributes based on your own understanding.

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment