Completed

In Assignment 1 you designed and created a database for holiday accommodation place “Great deal”, which keeps track on rooms, bookings, visitors, staff, and services. In this assignment you will create PLSQL procedures to manipulate data in your database

This project was successfully completed by ultrasonicsoft for $30 AUD in 3 days.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$10 - $30 AUD
Completed In
3 days
Total Bids
21
Project Description

Assignment Part 2

Worth 15% of your final mark
Due 28 October 2013

In Assignment 1 you designed and created a database for holiday accommodation place “Great deal”, which keeps track on rooms, bookings, visitors, staff, and services. In this assignment you will create PLSQL procedures to manipulate data in your database

What to do

1. Create PLSQL procedure which takes a customer id as a parameter and shows
his/her booking. For each booking show customer Id, customer name, room No, start date and duration (2 marks)

2. Create PLSQL procedure which takes a rank of hotel as a parameter and show list all rooms which are available for bookings. Show all room details (hotel, type, roomno, and price) (2 marks)

3. Create PLSQL function which takes a booking id as a parameter, calculates price for this booking including services provided and returns it. Create an anonymous block to run this function
(3 marks)

4. Create PLSQL procedure which takes a date as a parameter and shows all customers who can check in on that date (2 marks)

5. Create PLSQL procedure which takes all details of booking (hotel, room no, atart date and duration) and inserts new booking into database (2 marks)

6. Create PLSQL procedure which takes a booking id and a date as parameters and updates date for this booking to value provided by parameter (2 marks)

7. Create PLSQL procedure which takes a customer id and deletes his/her bookings from database (2 marks)

What to submit
1. Scripts for all procedures and function (7 scripts)
2. Text file showing each procedure or function creation and run

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online