a$.(5$ Points$)$ Update the database creation script:

i$.$ Rename the database to VacationPlanning

ii$.$ Rename the table SummerPlan to Plan

b$.(10$ Points$)$ Update the VacationPlanning Database to support accommodations,

restaurants and People. Provide to me:

i$.$ An ER diagram of your new $3$NF VacationPlanning Database

ii$.$ An updated database creation script

c$.(10$ Points$)$ Write a stored procedure and a function.

i$.$ The stored procedure should insert a new activity into the database.

ii$.$ The function should determine if the park the activity takes place at

exists within the Park database, and if it doesn$$t it should insert the park

details into the park database.

Page $7$ of $7$