Question: QUESTIONS: 1. List all the relations derived from the entity types of the ERD (Shown Below), and their initial attributes 2. For each relationship type

QUESTIONS:

1. List all the relations derived from the entity types of the ERD (Shown Below), and their initial attributes

2. For each relationship type in the ERD justify whether it leads to a new relation, a new attribute in a relation derived from an entity type, or to a merger of two relations derived from two entity types.

ANSWER IN THIS FORMAT:

RELATIONSHIP NAME was derived by adding RELATION with attribute and attribute as foreign keys to link with RELATION and RELATION because of MULTIPLICITY and/or PARENT/CHILD

RELATIONSHIP NAME was derived by merging RELATION and RELATION because of MULTIPLICITY and/or PARENT/CHILD

RELATIONSHIP NAME was derived by adding attribute to RELATION as a foreign key to link with RELATION because of MULTIPLICITY and/or PARENT/CHILD

3. List all the relations in the final relational model, and all their attributes

4. List all the constraints included in the conceptual schema in addition to the relevant primary keys and foreign keys

ANSWER IN THIS FORMAT:

Primary Keys

The primary keys are the attributes underlined in relations listed above 3.

Foreign Keys

Relation (attribute) is dependent on Relation (attribute). Relation (attribute) is dependent on Relation (attribute).

Other Constraints

The X attribute of the Y relation can only be from 1000 to 9999.

QUESTIONS: 1. List all the relations derived from the entity types of

0..n Account Player Badges advanced quests Quests QuestID[PKy BeaconID Assigned to 1..1 Treasure ID

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Derive a Relational model from the below conceptual schema (It should match exactly). Only derive the part of the database that stores information about players, quests, beacons and treasures...

Derive a Relational Model from the conceptual schema you provided in Task 1 (it should match exactly). For the purpose of this assignment, only derive the part of the database that stores the...

Given Scenario: Treasure Hunters - An augmented reality Game In order to play the game, each player creates their account. They must choose a unique username, provide their name (first and last...

TASK IS TO: Derive a Relational model through 4 BROKEN UP SECTIONS (DON'T ACTUALLY DRAW THE MODEL) From the conceptual schemea shown above. However do not include the information about stores and...

I've made the ER model above. But am not sure how to go on to make a relational model from here. Derive a Relational Model from the ER-model above. List all the relations derived from the entity...

I have created an ERD for the provided scenario, however I am having some trouble changing it into a Relational Model table, any help would be appreciated. The task is below, along with the ERD I...

Based off the scenario provided below create an ERD. The Scenario Treasure Hunters, an augmented reality online game. In order to play the game, each player creates their account. They must choose a...

YYC Connections, a rapidly growing private school for K - 6 , needs a database to organize their student and staff information. They have provided the following specifications: Students are at the...

This case study is two parts - as shown & marked in the table- I have completed part one, the other attachment. However, i need help with part two - Scemarav smpliverinent at the MrS Moywat. at the...

This is my college Database coursework. I have a problem regarding making the erd diagrams and normalization(UNF, 1NF, 2NF, 3NF). I hope you would help me in making this along with the final erd...

An apple loses 4.5 kJ of heat as it cools per C drop in its temperature. The amount of heat loss from the apple per F drop in its temperature is (a) 1.25 kJ (b) 2.50 kJ (c) 5.0 kJ (d ) 8.1 kJ (e) 4.1...

1. Name at least 12 Post-Romantic, Impressionistic, andTwentieth-Century composers and list what characteristics theyadded to each period and include a list of 4 compositions for eachcomposer....

For each scenario, indicate whether Federal estate and gift tax consequences "Occurred" or "Did not occur". In all cases, assume Gene and Mary are married and that Tanisha is their daughter. a . Mary...

Alan was injured at his job and received the following payments. $ 3 6 , 0 0 0 disability pay. Alan had disability insurance provided by his employer as a nontaxable fringe benefit. His employer paid...

KEY QUESTION What assumptions about a rivals response to price changes underlie the kinked-demand curve for oligopolists? Why is there a gap in the oligopolists marginalrevenue curve? How does the...

Calculate the missing total-revenue and marginal- revenue amounts, and determine the profit-maximizing price and profit-earning output for this monopolist. What is the monopolists profit? Verify your...

KEY QUESTION Suppose that a price-discriminating monopolist has segregated its market into two groups of buyers, the first group described by the demand and revenue data that you developed for...