Answered step by step
Verified Expert Solution
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
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 coursesStep 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