Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Step: 3

blur-text-image

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

Excel As Your Database

Authors: Paul Cornell

1st Edition

1590597516, 978-1590597514

More Books

Students also viewed these Databases questions