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

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 (considering a sub-ERD), and leave aside the information relating to stores and badges.

Derive a Relational model from the below conceptual schema (It should match Questions:

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

FOR EXAMPLE:

RELATION (attribute, attribute, attribute)

2. For each relationship type in the sub-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.

FOR EXAMPLE:

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

FOR EXAMPLE:

RELATION (attribute, attribute, attribute)

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

FOR EXAMPLE:

Primary Keys:

- List the primary keys

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

Help with these questions would be greatly appreciated as I have been stuck on them for hours and am quite struggling! Thankyou so much!

0..n Account Player Badges advanced quests Quests QuestID[PKy 1.5 mini quests BeaconID Assigned to 1..1 Treasure ID 1.1 MiniQuests(0.5]

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

A creative engineer suggests structuring the TLB so that not all the bits of the presented address need match to result in a hit. Suggest how this might be achieved, and what might be the costs and...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Define the contextual-equivalence relation ` M =ctx M0 : for pairs of PCF terms M, M0 , PCF types , and PCF type environments . [3 marks] (ii) For PCF terms M and N with respective typings ` M : and...

s1 educated (SSE) student for every three public school educated (PSE) students. Reasoning that students are not very dissimilar from threads, he suggests the following entry and exit routines be...

Portray in words what transforms you would have to make to your execution to some degree (a) to accomplish this and remark on the benefits and detriments of this thought.You are approached to compose...

Prolog You are approached to compose a Prolog program to work with twofold trees. Your code shouldn't depend on any library predicates and you ought to expect that the mediator is running without...

What is meant by value-added services? Why are these services considered essential in a customer success program?

Josh works at $10.73 per hour. If he worked 47 hours this week, Calculate what is his gross pay?

An IT consultant is starting to travel abroad but has concerns about being able to VPN back home to access a private home network. The consultant would like to be able to watch the latest TV shows...

a news article that discusses a recent (past 6 months) cash dividend issuance or cash dividend policy change for a corporation. In your discussion response, please provide the link to the article...

12-4 How do different decision-making constituencies in an organization use business intelligence, and what is the role of information systems in helping people working in a group make decisions more...

11-18 How do enterprise content management systems help organizations manage structured and semistructured knowledge? What are two examples of each type of knowledge handled by these systems?

12-5 How will MIS help my career?