Question
Did I Do the ER Diagram Correct? Submit a word document with screen shot or pictures of ER diagram , relational database schema, database structure
Did I Do the ER Diagram Correct?
Submit a word document with screen shot or pictures of ER diagram, relational database schema, database structure in SQL server and SQL report.
This mini project is a small section of student registration database.
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?"
Students Course Instructor StudentID InstructoriD CourseiD Firstname FirstName CourseDescription Lastname LastName Gender OfficeLocatior SectionNumber Section CourseiD CourselD Section SectionNur Classroom
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