Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 2 (ER Model) [20 points) Design an Entity-Relationship diagram that models a department management system and considers the requirements listed below. That means that
Question 2 (ER Model) [20 points) Design an Entity-Relationship diagram that models a department management system and considers the requirements listed below. That means that you have to identify suitable entity sets, relationship sets, at- tributes, keys of entity sets (if not specified), and so on. Further, add the cardinalities (1:1, 1:m, m:1, m:n) to the relationship sets and write down your assumptions regarding the cardinalities if there could be a doubt. Consider the following requirements about a car dealership system: A professor has a SSN, name, age, rank, and specialty. A department has a department number, name, and office. A graduate has a SSN, name, age, and degree progress. A project has a project ID, sponsor, start date, end date, and budget. There is a professor who runs a department. A professor may advise many graduates and a graduate can be advised by one professor. A professor can be belonged to many departments and a participation time for each department is stored. A graduate majors in a department. A graduate must have another graduate as an advisor. A project is managed by a professor. A project is worked in by many professors. Many graduates may work on many projects
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