Question
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
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