Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.
P.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 3Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started