Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedP.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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Joseph J. Adamski

7th edition

978-1111825911, 1111825912, 978-1133684374, 1133684378, 978-111182591

More Books

Students also viewed these Databases questions

Question

Define text analytics.

Answered: 1 week ago