Answered step by step
Verified Expert Solution
Link Copied!

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!

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Moving Objects Databases

Authors: Ralf Hartmut Güting, Markus Schneider

1st Edition

0120887991, 978-0120887996

More Books

Students also viewed these Databases questions

Question

Define organizational culture.

Answered: 1 week ago

Question

2. How will the team select a leader?

Answered: 1 week ago