Using the supplied template show your solution for each view as it exists in the Initial Table, 1NF, 2NF and 3NF (just like lab 1). Once you have completed the database design for each view in 3NF merge the 3NF solutions of each view to show the final 3NF solution for your Thrill Seekers database. Use bold for primary keys and italics for foreign keys (or another annotation if permitted by your instructor). Alternatively, you can use (PK) and (FK) after the attribute to indicate Primary Key and Foreign Key attributes.

 

 

 

Thrill Seekers has many different themed areas that contain rides that share that theme (Scary Zone, Kids Zone, etc.). Each ride also falls under a particular ride category and each ride has a min height requirement for safety purposes. Staff Club View (4 Marks) Club Code: AC Club Name: Adrenaline Club Staff ID 3 Staff Name Michael Thriller Jason Painter Date Joined June 1, 2021 June 6, 2021 1

 

 

 

 

 

Transcribed Image Text:

Thrill Seekers Amusement Park Thrill Seekers amusement park is a new park being built in Edmonton, AB. They need a database design to support Rides, Maintenance, and Staffing data. Ride ID: 12 Name: Triple Threat Roller Coaster Description: Triple loop high speed roller coaster Maintenance Log LogNumber TaskID Task Desc Inspection 1 2 3 2 Ride Maintenance View (5 Marks) 1 5 Cleaning Painting Notes Inspected car wheel bearings Cleaned all exterior surfaces Painted railings by ride entrance Date Completed July 4, 2021 3 StaffID July 9, 2021 2 July 12, 2021 1 Staff Name Michael Thriller Susan Sparkling Jason Painter The ride maintenance view deals with data involved with ride maintenance and who has performed that maintenance. The sample report above shows the data that will need to be maintained for ride maintenance. LogNumber for each ride starts at 1. The example above shows 3 Maintenance log entries for RideID 12. A TaskID uniquely identifies a Task. Thrill Seekers Amusement Park Thrill Seekers amusement park is a new park being built in Edmonton, AB. They need a database design to support Rides, Maintenance, and Staffing data. Ride ID: 12 Name: Triple Threat Roller Coaster Description: Triple loop high speed roller coaster Maintenance Log LogNumber TaskID Task Desc Inspection 1 2 3 2 Ride Maintenance View (5 Marks) 1 5 Cleaning Painting Notes Inspected car wheel bearings Cleaned all exterior surfaces Painted railings by ride entrance Date Completed July 4, 2021 3 StaffID July 9, 2021 2 July 12, 2021 1 Staff Name Michael Thriller Susan Sparkling Jason Painter The ride maintenance view deals with data involved with ride maintenance and who has performed that maintenance. The sample report above shows the data that will need to be maintained for ride maintenance. LogNumber for each ride starts at 1. The example above shows 3 Maintenance log entries for RideID 12. A TaskID uniquely identifies a Task.

Answer rating: 100% (QA)

To normalize the supplied data into 1NF 2NF and 3NF for the Thrill Seekers theme park database we need to identify the various entities their attributes and their relationships We must also enforce pr... View the full answer