longborough community college is a new educational institution in the midwest. you have been asked to create a database to keep track of the students, faculty, course offerings, and class registration. use the concepts and techniques presented in this module to design a database to meet the following requirements: Part 1: The Longborough College database must support the following requirements:
a. For each faculty member, store his or her faculty ID. last name, first name, street address, city, state,
postal code, telephone number, and date hired.
b. For each student, store his or her student ID, last name, first name, street address, city, state, postal
code, telephone number, and birthdate
c. For each course offered, store the course ID, name of the course, the department the course resides
in, the number of credits, the day and time of the week the course meets and the faculty teaching
the course. To simplify the design, assume that only one section of each course is run, as this is a
startup college.
d. For each course registration, store student ID and the course ID.
