Question 1 - Entity Relationship Diagrams(Marks: 20)Answer this
question in your answer script/answer booklet provided.Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notationaccording to the below business rules. Your design should be at the logical level - include primaryand foreign key fields and remember to remove any many-to-many relationships.Tip: Pay attention to the mark allocation shown below.Business rules of a scientific research organisation that wants to keep track of butterfly sightingsreported by volunteers on their website:1.2.3.5.6.All entities should have surrogate primary keys.The name and surname of each user of the website must be stored in the database.When a user signs up, they must provide at least one location where they will be observingbutterflies. The user can add as many locations as they want, but each location is specific tothe user that adds it.For each location, a description as well as the latitude and longitude of each location mustbe stored in the database.Users report sightings on the website. A sighting of a species of butterfly is reported by aspecific user at a specific named location. The date and time of the sighting must also bestored in the database.The English name as well as Latin name of each butterfly species must be stored in thedatabase.Hint: Think carefully about the number of entities involved in each relationship.Marks will be awarded as follows:EntitiesRelationshipsMultiplicitiesPrimary keys5 marks4 marks4 marks2 marksForeign keysOther attributesCorrect UML NotationTotal2 marks2 marks1 mark20 marks
Question 1 - Entity Relationship Diagrams
(Marks: 20)
Answer this
question in your answer script/answer booklet provided.
Draw an Entity Relationship Diagram (ERD) using Unified Modelling Language (UML) notation
according to the below business rules. Your design should be at the logical level - include primary
and foreign key fields and remember to remove any many-to-many relationships.
Tip: Pay attention to the mark allocation shown below.
Business rules of a scientific research organisation that wants to keep track of butterfly sightings
reported by volunteers on their website:
1.
2.
3.
5.
6.
All entities should have surrogate primary keys.
The name and surname of each user of the website must be stored in the database.
When a user signs up, they must provide at least one location where they will be observing
butterflies. The user can add as many locations as they want, but each location is specific to
the user that adds it.
For each location, a description as well as the latitude and longitude of each location must
be stored in the database.
Users report sightings on the website. A sighting of a species of butterfly is reported by a
specific user at a specific named location. The date and time of the sighting must also be
stored in the database.
The English name as well as Latin name of each butterfly species must be stored in the
database.
Hint: Think carefully about the number of entities involved in each relationship.
Marks will be awarded as follows:
Entities
Relationships
Multiplicities
Primary keys
5 marks
4 marks
4 marks
2 marks
Foreign keys
Other attributes
Correct UML Notation
Total
2 marks
2 marks
1 mark
20 marks
- Question 1 Entity Relationship Diagrams Marks 20 Answer This Question In Your Answer Script Answer Booklet Provided D 1 (47.68 KiB) Viewed 39 times
e netwo
Question 1 - Entity Relationship Dlagrame (Marks 20 Answer this
question in your answer script/answer booklet provided. Draw an Entity Relationship Diagram (ERD) using Unified Modelling language (UML) notation according to the below business rules. Your design should be at the logical level - include primary and foreign key fields and remember to remove any many-to-many relationships Tip: Pay attention to the mark allocation shown below. 1 3. Business rules of a scientific research organisation that wants to keep track of butterfly sightings reported by volunteers on their website: All entities should have surrogate primary keys 2 The name and surname of each user of the website must be stored in the database. When a user signs up, they must provide at least one location where they will be observing butterflies. The user can add as many locations as they want, but each location is specific to the user that adds it. For each location, a description as well as the latitude and longitude of each location must be stored in the database Users report sightings on the website. A sighting of a species of butterfly is reported by a specific user at a specific named location. The date and time of the sighting must also be stored in the database The English name as well as Latin name of each butterfly species must be stored in the database 4. 5. 6. Hint: Think carefully about the number of entities involved in each relationship. 2 marks Marks will be awarded as follows: Entities 5 marks Relationships 4 marks Multiplicities 4 marks Primary keys 2 marks Foreign keys Other attributes Correct UML Notation 2 marks 1 mark Total 20 marks The Independent PM