Database Class Name: College: CREATE DATABASE Class; USE Class; CREATE TABLE Students( StudentID INT NOT NULL FirstName VARCHAR (20) NOT NULL LastName VARCHAR (20) NOT NULL Address CHAR (25) Phone NULL SelfJoin VARCHAR (25) NOT NULL PRIMARY KEY (CourseID) ); CREATE TABLE Term( TermID INT NOT NULL Season VARCHAR (25) NOT NULL Date DATE NOT NULL PRIMARY KEY (TermID) ); [...]
Create a SQL script for a database class. I will provide the ER Model which the script will be based off of. The ER model is in MS Visio and the script should be in SQL developer or Oracle. The site would not allow me to upload the Visio (.vsb) file so I renamed the file to .txt. You will need to rename it back to a .vsb.