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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started