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!

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
Get step-by-step solutions from verified subject matter experts
