Implement the following ER model and sample data using Oracle SQL Developer and your CDM Oracle database account. You will submit a SQL script file and its entire outputs. The table name should be STUDENTS (plural). Each StudentID should be a five-digit number. LastName and FirstName must be entered.
Implement the following ER model and sample data using Oracle SQL Developer and your CDM Oracle
The table name should be STUDENTS (plural).
Each StudentID should be a five-digit number.
LastName and FirstName must be entered.
- 12341, Doe, Jane
- 12342, [last name of your choice], [first name of your choice]
- 12343, [last name of your choice], [first name of your choice]
Enrollment
The table name should be ENROLLMENTS (plural).
Quarters should be something like 2021Fall, 2022Winter, 2022Spring, 2022Summer1, 2022Summer2, 2022Summer10, and so forth.
Grades in future quarters are entered as null.
- 2021Fall, 12341, IS411, A
- 2022Winter, 12342, IS421, null
- 2022Summer10, 12343, [course number of your choice], null
Course
The table name should be COURSES (plural).
CourseNumbers should be strings of up to seven characters (e.g., IS411, DSC411, CSEC440).
The course and instructor names should be strings of characters.
CourseName must be entered.
Instructor may be undetermined at the time of initial data entry.
- IS411, Introduction to Programming for Business Applications, Xiaowen Fang
- IS421, Systems Analysis, Steven Rubinow
- ADD IN [course number of your choice], [course name of your choice], [instructor of your choice]
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
