Question: Lab 3-Structured Query Language. Student Lecturer Courses Modules Firstname Lastname . Title . Title Firstname Lastname Student Number Date of birth Level Code Level Staff

 Lab 3-Structured Query Language. Student Lecturer Courses Modules Firstname Lastname .

Lab 3-Structured Query Language. Student Lecturer Courses Modules Firstname Lastname . Title . Title Firstname Lastname Student Number Date of birth Level Code Level Staff Number Date of birth * Code . Credits Description: A student has many lecturers A lecturer may have many students A student may have one course A student can have many modules A lecturer teaches one or more modules Requirements: 1. The database must be named TUDublin Create four database tables for students, lecturer, courses and modules. You must use the fields described above The relationships should be defined using primary and foreign keys Create the SQL INSERT statements for the following Create 5 students records Create 5 lecturer records Create two courses records Create 6 module records (3 on each course) (60%) 2. (40%)

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!