A Gaming company had a new worker who prototyped the database for the players an

Question

A Gaming company had a new worker who prototyped the database for the players and quests, but they could never implement it, and they have already been told this is really poor design. This is what it looks like, with some sample data:

For each of the 3 relations proposed (Player, Treasure, Address), explain which normal form (0NF, 1NF or 2NF) it is in, and why.

ANSWER MUST BE IN THIS FORMAT:

Player is xNF because it respects this and that but there is Z which prevents it from being (x+1)NF

Treasure is xNF because it respects this and that but there is Z which prevents it from being (x+1)NF

Address is xNF because it respects this and that but there is Z which prevents it from being (x+1)NF

Thanks!

Player Name Quests Amy Points Address id 674 2 Q33 Q12 Q25 Michael Q54 Q25 Q33 Q45 78 2 Emil Tom NULL 5 54 6 Treasure Name Description Quest id Quest Name Diamond The tree's Beacon Toohey Forest Sign Q25 Q25 Q33 Urban Elves Urban Elves Pirates of Brisbane River City Cat (Broncos) Pirates of Brisbane River City Cat (Broncos) diamonds The Big Gum's heart Toohey Forest Sign Heart Diamond The river's Gold diamonds The Captain's Q33 chest Address ld Street name city Street number 15 2 6 28 postcode Queen StreetBrisbane 4000 Edward Street No Alice Street George Street Bundaberg 4332 2 3 osa Gympie 4230 5533 6

Explanation / Answer

Player is in 0NF because it is in relation form but there are multivalued attributes Quests , Points and addressId, which prevent it to become 1NF.

Treasure is in 1NF because it respects the property of having atomic values but it is having partial dependency (QuestName and beacon depends on QuestId and QuestId depends on Name) which prevents it to be in 2NF.

Address is 2NF as all attributes are fully dependent on Id, but it also have transitive dependency between id city and postcode, So its not in 3NF

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.