Question

#1 Create a MySQL Model and EER Diagram based on the information below.

Create a new database/schema called university and design the following tables and relationships.
Make your best guess on data types and size of the fields.
Table: student
studentID (primary key)
lastName
firstName
major
credits (# of credits already earned)
Table: faculty
facultyID (primary key)
lastName
department (Art, History, etc.)
title (Professor, Instructor, etc.)
Table: class
classID (primary key)
facultyID foreign key
schedule (MW, MTh, etc.)
room
Notes:
one faculty can teach many classes
One student can enroll in many classes. One class can have many students enrolled. To deal with this many-to-many relationship you can use nim relationships to create a linking table enroll with the following fields:
a. studentID foreign key
b. classID foreign key
c. grade

Answer 1

To create a MySQL model and EER diagram based on the given information, design tables and relationships for a university database, including student, faculty, class, and enroll tables.

Step-by-step explanation:

To create a MySQL model and EER diagram based on the given information, you will need to design tables and relationships for a database/schema called university. The tables to be created are: student, faculty, class, and enroll. The student table will have columns for studentID (primary key), lastName, firstName, major, and credits. The faculty table will have columns for facultyID (primary key), lastName, department, and title. The class table will have columns for classID (primary key), facultyID (foreign key), schedule, and room. To handle the many-to-many relationship between students and classes, a linking table called enroll will be created with columns for studentID (foreign key), classID (foreign key), and grade.