Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 notationsStep 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