Question
As an experienced database designer, you are charged with the task of building a database for student enrollment in the college. Each department in the
As an experienced database designer, you are charged with the task of building a database for student enrollment in the college. Each department in the college has a course inventory that includes a list of the courses that the department can offer for enrollment. Also, each department has instructors who will be teaching the courses when they are offered. Once an instructor is hired, she/he will be assigned to teach in one department. It is important to note that an instructor can teach more than one class (i.e. course offering) each semester and there might be instructors in the database who hasnt started teaching yet. Additionally, no classes will be taught by more than one instructor.
Before the beginning of each semester, each department publishes their schedule for the semester. The schedule includes the course offerings for that semester. Each course offering in the semester contains the course number, the instructor who will be teaching the class, the days and times the class meets, the classroom, and the maximum number of enrollment. The schedule also includes a unique identifier for each offering called the CRN number. Some courses are offered each semester while others are offered every other semester. There will be courses that exist in the database for a while before they are offered for the first time.
When students are admitted to the university, they must declare a major in one of the departments. Once they declare a major, students can enroll in classes (i.e. course offerings) when they are offered. Each student can enroll in more than one class each semester with a maximum of 5 classes in any given semester. There will be cases where student information is stored in the database for a while before the student is enrolled in her/his first class.
Use the information provided above to answer the following questions:
1- Identify all the entities that will exist in this database.
2- Draw the ERD that captures all the business rules you identified.
i got an answer and it was wrong one
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started