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

ok so im trying to create a database for a website that

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 Number

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!