Question: Create database back-end functionality to facilitate a car rental company's official website (e.g., https://www.avis.com) which is to allow travelers to rent a car. 1. Content



Create database back-end functionality to facilitate a car rental company's official website (e.g., https://www.avis.com) which is to allow travelers to rent a car. 1. Content of your database [5 marks] a. Understanding the problem domain by studying Avis's official website b. Tables (data, lookup, audit/log tables) c. The number of tables should be between 5 and 10 d. ER diagram 2. Sequence [3 marks] a. Create at least one sequence b. Use it to insert sample data c. Use it to update table(s) 3. Indexes [2 marks] a. Search is one of common functionalities, index plays a critical role in search b. create few indexes for those tables where search is performed frequently 4. Triggers [6 marks] a. Create at least 2 triggers for table entry/updating behind the scenes b. Provide screenshots to demonstrate that the triggers can work properly 5. Packages [12 marks] a. Implement at least two procedures b. Implement at least two functions c. Include exception section d. Demonstrate your ability to use cursor e. Use TYPE attribute and/or ROWTYPE attribute whenever it is appropriate


Note: There should be minimum ten rows (10 insert statements for data tables) and five rows (for reference/lookup type tables). You should populate your tables with meaningful data.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!