Resources: Palm Tree Island Hotels Database
You will work with the Palm Tree Island Hotels Database in Weeks Two, Three and Four. You have the option of using Oracle® Express® or Microsoft® Access® for this assignment.
Complete the following activities after reviewing the Palm Tree Island Hotels database information found in the Materials section to the right:
- Create the three tables in Oracle® Express® or Microsoft® Access® for the Palm Tree Island Database.
- Identify the primary and foreign keys that you think would work best.
Submit either the Oracle® Express®.sql file or the Microsoft® Access® .accdb file to the Assignment Files tab above.
Note: If you are using Oracle® Express®, create a DDL script. Go to Utilities > Generate DDL and create a script file with all tables, indices, sequences, and triggers in your database.