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

 

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) 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)

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