Question
Create an E-R and Relational Model based on the following description. The model should include entities, their relationships, and attributes (full signature). Use UML notation
Create an E-R and Relational Model based on the following description. The model should include entities, their relationships, and attributes (full signature). Use UML notation either in a software tool (e.g. LucidChart, Visio) or in a hand exercise.
A local College requires a database to tracks students and courses they take.
The College has a course catalog listing all of the courses by department with their course number, number of credits and a brief description.
Courses are offered each semester in Fall and Spring and a course can have multiple sections.
A Course section meets on a particular schedule such as every Monday and Wednesday of the week at 2:30. Students register for courses each semester.
Faculty are assigned to teach particular courses listed in their departments.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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