Question A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (M170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, M 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The class number of the grade you got for a course. The business rules for this City College are: A course can have many class sessions; each class must associate with only one course. A student can take many classes; each class can have many students. A faculty can teach many classes; each class only have one instructor. A faculty can advise many students; each student can only have one specific faculty advisor. Complete the following tasks: Draw the ER diagram using Crow’s Foot Model

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

A city college would like to maintain their academic information in a MySql database system. The following are the interested information:

Courses:

Classes:

Faculty:

Student:

The business rules for this City College are:

A course can have many class sessions; each class must associate with only one course.
A student can take many classes; each class can have many students.
A faculty can teach many classes; each class only have one instructor.
A faculty can advise many students; each student can only have one specific faculty advisor.

Complete the following tasks:

Draw the ER diagram using Crow’s Foot Model

Expert Solution