Question: Now that we have a relatively good understanding about creating tables. We will need to go a step farther and start using them. This assignment

Now that we have a relatively good understanding about creating tables. We will need to go a step farther and start using them. This assignment will consist of a few requirements - You will be creating a Registration table and a Course Instructor table Registration will be used to register student into a section. Course Instructor will be used to register faculty with a section. Both tables will require Primary Keys so that a student cannot register for same section more than once and same for faculty. Both tables will need to maintain referential integrity. You need to be an instructor in order to register to teach a section and a section needs to be valid, etc. This should be done through Foreign Keys. You should create the parent keys before trying to create the child records. - You will need to add 5 rows of data to each table, which is 35 total records across your schema. - For the records in each table. You will need to use sequences. This will enable you to create a surrogate key for all your records. CREATE SEQUENCE student_id_seq START WITH 1000 INCREMENT BY 1; INSERT INTO STUDENT (STUDENT_ID, FIRST_NAME, LAST_NAME) VALUES (student_id_seq.nextval, Ryan, Kramer);

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!