Create database back-end functionality to facilitate an air line's official website (e.g., aircanada.com) which is to...

 

Transcribed Image Text:

Create database back-end functionality to facilitate an air line's official website (e.g., aircanada.com) which is to allow travelers to book flight ticket online. 1. Content of your database [5 marks] a. Understanding the problem domain by studying an air line'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. Create database back-end functionality to facilitate an air line's official website (e.g., aircanada.com) which is to allow travelers to book flight ticket online. 1. Content of your database [5 marks] a. Understanding the problem domain by studying an air line'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.