Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1.create the following table , make sure you add primely key and secondary ( forging ) key when needed b. write a join query to

1.create the following table , make sure you add primely key and secondary ( forging ) key when needed

image text in transcribed

b. write a join query to retrieve all the data from students and grades .

note using https://downloads.mysql.com/archives/workbench/

my sql worbrench

Example simpsons database id name id name teacher id student id course id grade nameemai 123Bart bartQfoxcom1234 Krabappe 10001 Computer Science 142 1234 45 Milhouse mihouse Ofox.com 568 Hoover 1002 Computer Science 10001 B 10002 0001 B 12 435678 23 456 uselwtox.com isoxw.com 902 Stepp 10003 Computer Science 190M 9012 404 Ralph ralph@fox.com teachers 10004 Informatics to0 234888 1002 A students 888 0003 A 404 10004 D+ grades courses

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

Database Concepts

Authors: David Kroenke, David Auer, Scott Vandenberg, Robert Yoder

8th Edition

013460153X, 978-0134601533

More Books

Students also viewed these Databases questions