Using the supplied template show your solution for each view as it exists in the Initial Table,
Question:
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
Systems analysis and design
ISBN: 978-0136089162
8th Edition
Authors: kenneth e. kendall, julie e. kendall