21:22:23 Question 1 - Entity Relationship Diagrams (Marks: 20) Answer this question in your answer script/answer booklet

[answerhappygod]

21 22 23 Question 1 Entity Relationship Diagrams Marks 20 Answer This Question In Your Answer Script Answer Booklet 1 (61 KiB) Viewed 49 times

21:22:23 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. inare 2. 1.1 3. le Business rules of a scientific research organisation that wants to keep track of butterfly sightings reported by volunteers on their website: 1. 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. 5. 6 6. int: Think carefully about the number of entities involved in each relationship.