Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need help can somebody help me with this what would the answer be my digram is about basketball keeping the teams organize their teams roster,

need help can somebody help me with this what would the answer be

my digram is about basketball keeping the teams organize their teams roster, coaches, and games

help please can you draw it out thanks in advance

Our second part is designing the database. All you need to do for this part is to provide an ER

model for your database and then convert it into relations (tables).

Draw an ER diagram using DIA: This ER diagram should reflect the proposal you have submitted. You should start with the same relations you described in your proposal, and then add (or modify) more entities if required. You need to identify the entities, their attributes and how those are related (relationships). For this project, you are only allowed to use Chen Notation. Model the entities, attributes, and relationships. Find if few of these entities are weak. Is there any class hierarchy in your ER diagram? If yes, model those as is-a relations. Provide the cardinality, total participation, and (min, max) constraint for each entity (for each relation). Write your assumptions. Save the ER diagram. We will use it later for further tuning. (12 pts)

Convert your ER diagram into relations: Once the ER diagram is ready, you need to convert the ER model into relations. Your report should have the following components:

2.1. A list of relations and their attributes (10 pts)

Indicate the primary key and foreign keys (if any) for each relation. Justify your choice.

Write the detailed description of each attribute (for each table), its purpose and datatype.

Indicate each attributes default value (if any) or if the attribute can be set to null.

Explain the actions taken on any foreign key when the primary key (that the foreign

key refers to) is deleted (For example: no action, delete cascade, set null, set default). 2.2. A mapping from the ER diagram to the Relations. (6 pts)

For each relation (table), provide the correspondence between the relation and the entity and/or relationship in the ER diagram that the relation is derived from. Justify your decision.

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

How To Build A Million Dollar Database

Authors: Michelle Bergquist

1st Edition

0615246842, 978-0615246840

More Books

Students also viewed these Databases questions