Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Marketing

Authors: Roger Kerin, Steven Hartley, William Rudelius

16th Edition

1264218753, 978-1264218752

Students also viewed these Databases questions

Question

Will the company help with relocation expenses?

Answered: 1 week ago