(Solved) : 1 List Relations Derived Entity Types Erd Initial Attributes 2 Relationship Type Sub Erd J Q30737035 . . .
![Store storelD (PK) name openTime closeTime Player username PK! name lastName gender [female, male, other, prefer not to disclose] Treasure treasureID (PK) purchaseDateTime DOB cost address type [common, uncommon, rare, ultra-rare, elite] webpage points streetName suburb city postcode [0000 9999] Badge badgelD (PK] name description phoneNumbers [1..3 creationDate Time totalPoints Beacon beaconlD (PK) questID PKy ame story](https://media.cheggcdn.com/media%2Fec9%2Fec98a6fe-fc37-409d-a5f6-0155514b5fbc%2FphpQxZYMp.png)
1. List all the relations derived from the entity types of theERD, and their initial attributes.
2. For each relationship type in the sub-ERD justify if it leadsto a new relation, a new attribute in a relation derived from anentity type, or a merge of 2 relations derived from 2 entitytypes.
3. List all the relations in the final relational model, and alltheir attributes
4. List all the constraints included in the conceptual schema inaddition to the relevant primary keys and foreign keys.
Need Help!!!
Store storelD (PK) name openTime closeTime Player username PK! name lastName gender [female, male, other, prefer not to disclose] Treasure treasureID (PK) purchaseDateTime DOB cost address type [common, uncommon, rare, ultra-rare, elite] webpage points streetName suburb city postcode [0000 9999] Badge badgelD (PK] name description phoneNumbers [1..3 creationDate Time totalPoints Beacon beaconlD (PK) questID PKy ame story Show transcribed image text
Expert Answer
Answer to 1 List Relations Derived Entity Types Erd Initial Attributes 2 Relationship Type Sub Erd J Q30737035 . . .
OR