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

Computer Networking: A Top-Down Approach (7th Edition)
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...
icon
Related questions
Question

   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
 
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY