Question
ok so im trying to create a database for a website that handles university classes but am having trouble in my sql ER DIAGRAM SHOWN
ok so im trying to create a database for a website that handles university classes but am having trouble in my sql
ER DIAGRAM SHOWN BELOW
can someone please help my write the mySQL query to create the tables for the above diagram.
i need to create 4 tables user, class, wants, has
"user" being the student
"class" being the classes
"has" being the classes that the student currently has
"wants" being the classes that that the student doesnt have but wants
the tables "student" and "classes" must also have the attributes shown in the er diagram
user table must have attributs First_name, Last_name, password and email
class table must have attributes professor_name, start_time, end_time, days, and class_name, with class name having the attributes course_number and section_number
can someone please help me write a my SQL query to create the tables explained above/shown in the er diagram
please help
Professor Name Password Last Name Start Time Has Email End Time O,M) (O,M) Class User First Name (O,N) Wants Days Course_Number) Section NumberStep 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