Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Submit a word document with screen shot or pictures of relational database schema using excel The database needs to record students (ID, first name, last
Submit a word document with screen shot or pictures of relational database schema using excel
The database needs to record
students (ID, first name, last name, and gender),
section(section number, classroom),
course (ID, course description)
instructor (ID, first name, last name, office location)
SQL report will be
How many students in the school?
how many students are enrolled in one particular section? "
"who is teaching a particular section?"
1 Publisher 2 PublisherID Author 1 David 2 Lee Publisher Book Name StreetAddress aa Random House 4 b Norman ac 1 David 3 David 2 Lee 8 Book 9 ISBN 10 Title Price PublisherID 1 Holes 4 12 13 14 Author 15 Author Number FirstName 16 aa 4 LastName DOB David Lee 18 ac 19 20 Teach 21 WriteID orman Author Number ISBN 1001 1002 1003 1004 24 1 Publisher 2 PublisherID Author 1 David 2 Lee Publisher Book Name StreetAddress aa Random House 4 b Norman ac 1 David 3 David 2 Lee 8 Book 9 ISBN 10 Title Price PublisherID 1 Holes 4 12 13 14 Author 15 Author Number FirstName 16 aa 4 LastName DOB David Lee 18 ac 19 20 Teach 21 WriteID orman Author Number ISBN 1001 1002 1003 1004 24
Step 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