Create these tables using Oracle SQL Developer. Please share all code plus snapshots of all results even statements you…

Create these tables using Oracle SQL Developer. Please share all code plus snapshots of all results even statements you…

Question:

 

Transcribed Image Text:

Create these tables using Oracle SQL Developer. Please share all code plus snapshots of all results even
statements you used for creating tables.
Bdbo.Campus
Columns
Campus ID (PK, int, not null)
Campus Name (varchar (24), null)
Campus Address (varchar(24), null)
Campus City (varchar(12), null)
dbo.Course
Columns
Course ID (PK, int, not null)
Course Name (varchar(24), null)
Course Semester (varchar(24), null)
Program ID (FK, int, null)
Teacher ID (FK, int, null)
dbo.Teacher
Columns
Teacher ID (PK, int, not null)
Teacher Name (varchar(24), null)
Teacher Salary (numeric(3,2), null)
Bdbo.Program
Columns
Program ID (PK, int, not null)
Program Name (varchar(24), null)
Program Description (varchar(2000), null)
Tuition Fees (numeric(7,2), null)
Program Coordinator ID (FK, int, null)
Campus ID (FK, int, null)
1 dbo.Student
Columns
Student ID (PK, int, not null)
Student Name (varchar(24), null)
Student Type (varchar (24), null)
Student Admission Date (date, null)
Student GPA (numeric(3,2), null)
Program ID (FK, int, null)

Expert Answer:

Answer rating: 100% (QA)

To create a table named Campus with the given columns in Oracle SQL Developer you can use the follow
View the full answer