Question: Please read the question carefully! Design an Entity-Relationship diagram that models a department management system and considers the requirements listed below. That means that you

Please read the question carefully!

Please read the question carefully! Design an Entity-Relationship diagram that models a

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. NOTE: Use ERDPlus to draw your ER diagram. This will help you become prepared for Exam 1 where we will use ERDPlus. Create an account on the ERDPlus web page to be able to store ER diagrams so that you can continue or modify them later. Notice that the graphical notation is slightly different compared to Chen's notation. ERDPlus uses the crow's foot notation. The textbooks will help you understand and distinguish the two different notations

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!