Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q3) This question is about the Database Schema and Entity-Relationship Diagram (ERD). A municipality intends to build a relational database management system to manage and

Q3) This question is about the Database Schema and Entity-Relationship Diagram (ERD). A municipality intends to build a relational database management system to manage and control the city purchased construction materials that are used in several construction projects. Information about a construction material includes a unique material identifier and the material name. For each uniquely identified material, information about its suppliers, including a unique supplier number, a name, and a phone number is needed. Several suppliers may supply a specific construction material as identified by its identifier. The final information kept about a construction project is project identifier, project description, construction location address, and the date the project was started. The municipality is interested in producing several queries that show information about the material and the projects where these materials are used, and the suppliers that are involved in each project. The database schema must allow for this query to be always successful (i.e., foreign keys can be shared among tables to allow for the feasibility of this query). You are required to DRAW and EXPLAIN an Entity-Relationship Diagram (ERD) that clearly shows all the entities and the relationships between these entities. Show the type of relation in the entity-relationship diagram (weak, strong, one-to-one, one-to-many, many-to-many). It is required to underline the PRIMARY KEYS in your ERD [20 points] If you make any assumptions about your design, write them down and make sure that these assumptions do not contradict any facts given in the description above.

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

Auditing An International Approach

Authors: Bahram Soltani

1st Edition

9780273657736

More Books

Students also viewed these Accounting questions

Question

What was the biggest data breach in history?

Answered: 1 week ago

Question

Define organization development (OD)

Answered: 1 week ago