Question: Insert those information below: 1 student which includes exact your information. Find the student id which you add, and declare into a variable. 4 random

Insert those information below: 1 student which includes exact your information. Find the student id which you add, and declare into a variable. 4 random gradebook with the inserted student as a foreign key using the declared variable.

Insert those information below: 1 student which includes exact your information. FindP.S. Tables normally have more entries

There is a database with student information system. Tables are given be- low. student_id PRIMARY KEY student number TEXT student student_name student surname TEXT TEXT Thomas Rhodes Lam Thompson Fuller Cherry 1 2 3 6063 2176 2945 gradebook_id PRIMARY KEY 1 lettergrade_id FOREIGN KEY gradebook student_id course.id FOREIGN KEY FOREIGN KEY 1 1 6 1 20 4 2 8 2 3 lettergrade lettergrade_id letter PRIMARY KEY TEXT 1 A 2 A- 3 B+ average DOUBLE 4. 3.7 3.3 lecturer_id FOREIGN KEY course_id PRIMARY KEY 1 2 3 course course.name AKTS TEXT INT UNSIGNED Calculus I 8 Calculus II 9 Physics I 8 4 9 9 lecturer_id PRIMARY KEY lecturer lecturer_name TEXT Colt Colon Bennett Frey Haley Swanson 1 lecturer_surname TEXT Tyler Solis Munoz 2 3

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!