1. Identify entities

2. Draw an ERD based on your design

3. Draw a relationship diagram

4. Sketch a data dictionary for your design (with TABLE_NAME, TYPE, REQUIRED, PK or FK, FK referenced Table)

5. Make tables that capture the data illustrated in the spreadsheet

ID A3 Price Activity 4 $80.00 luau $80.00 luau A4 Price $60.00 $60.00 First Name 1 Joe 2 Maria 3 Manish 4 Meenah 5 Sandra Last Name Davidson Paolo Desai Desai Baker Baker Baker Baker Cabana pineapple pineapple mango mango coconut Activity 1 scuba scuba sunset cruise sunset cruise parasail parasail parasail parasail A1 Price Activity 2 $200.00 massage $200.00 massage $120.00 bike tour $120.00 bike tour $100.00 massage $100.00 $100.00 snorkeling $100.00 snorkeling A2 Price Activity 3 $140.00 bike tour $140.00 bike tour $85.00 $85.00 $140.00 coconut 6 Mitch 7 Chelsea 8 Daniel coconut $50.00 $50.00 coconut