Hi i need help to get ERD diagram done for DATAbase class.
You need to keep track of students and courses.
A student has to take at least four courses.
A course is cancelled if there are less than three students in it.
Each course is offered only once.
Courses have ID's such as AC101 and titles such as "Introduction to Accounting".
Students are assigned a student number up to 5 digits long. Other information that is
recorded about each student includes: first name, last name, gender, address, city, state, zip, student income, family income, date of birth, and grade point average
Show the tables with columns, their relationships, show the PK and FK columns, and indicate if they are 1:1, 1:M, or M:M
No comments:
Post a Comment