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

In Progress

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

Skills: MySQL, SQL

See more: what will do, room place, procedure plsql, procedure in plsql, plsql procedures, plsql or, plsql &, function plsql, SQL/PLSQL, procedures, manipulate, data in, customer details database, sql created, sql final, hotel name list, hotel price database, mysql sql function, price list services, database mysql hotel, will create, check assignment, database hotel room booking, assignment hotel, assignment database creation

Project ID: #5060817

Awarded to:

ultrasonicsoft

Hi, Hope you find this message in good health. I have very strong knowledge of database concepts and hands on MS SQL, MySQL. I can do this task easily. Hope to hear from you soon. Thanks!

$30 AUD in 3 days
(2 Reviews)
1.9

20 freelancers are bidding on average $41 for this job

ielkfarna

Dear Sir, I am Professional Software Developer, I am Linux Advanced Developer, I am Database Developer and designer. I can Handle your job and do everything extremely Grate. Regards,

$157 AUD in 3 days
(11 Reviews)
5.0
elboukharimu

Hi, I'm very interested helping you on your assignement, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is some samples of More

$121 AUD in 3 days
(14 Reviews)
4.3
Reza2012

Hi I am interested to do the job. I have more than 10 years experience in PL/SQL programming. Please see my profile. thanks.

$111 AUD in 3 days
(5 Reviews)
3.9
rakib062

A proposal has not yet been provided

$40 AUD in 2 days
(7 Reviews)
3.7
BhargavaB

Hi This is bhargava . i am expert in PL/SQL . I had completed several PL/SQL and SQL projects .I am ready to provide Quick and efficient solution . Can u please provide the assignment 1 details i am ready to start t More

$30 AUD in 1 day
(12 Reviews)
3.2
VnBestSolutions

Dear Sir, We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! More

$54 AUD in 1 day
(3 Reviews)
3.1
sayli2

Very easy assignment for me. expert in MS SQL. I've 7+ years of industry experience. I've 100% completion rate here.Check my profile for details. Please let me know in case of any query/confusion Thanks

$24 AUD in 3 days
(5 Reviews)
2.0
danangvw

I have bachelor and master degrees in IT. My Primary skills include Java, VB/.NET, Delphi, and PHP. Also database skills include MS Access, MySQL, and Oracle. My Other skills include server and network administration a More

$15 AUD in 1 day
(1 Review)
0.8
truongbk24

i can do this for you in 2 days, check my porfolio for my sample of PL/SQL function. I have a question, as you mentioned, have you got your database or i have to designed, let me know if you have interests, i'll do the More

$20 AUD in 2 days
(1 Review)
0.0
DennisDenis

I work with the PL/SQL on the daily basis and am really better than those folks from the countries I've never been to.

$25 AUD in 3 days
(0 Reviews)
0.0
ashkarcs86

Hi I am having more than five years experience. I can do this best . Ready to start right now. Warm Regards Ashkar

$13 AUD in 1 day
(0 Reviews)
0.0
Sindhu2108

A proposal has not yet been provided

$25 AUD in 5 days
(0 Reviews)
0.0
msabri

I maniplute the data base for my different project and i survey many project. my work is commented and structered

$25 AUD in 2 days
(0 Reviews)
0.0
rengrish

I am interested in this project. Ready to take up immediately. I am an oracle PLSQL developer with over 5 years of experience . Looks like simple task.

$30 AUD in 3 days
(0 Reviews)
0.0
jromeyu

Please provide DDLs for the database. So I can work on this. I'm new here and I need positive feedback. Thanks.

$10 AUD in 1 day
(0 Reviews)
0.0
RKYSP

Hi I am having more than 10yrs of exp in designing and developing application using .Net (asp.net and C#) with SQL Server and MySQL Database. Lets have a discussion to discuss more. Awaiting for your positive reply

$25 AUD in 2 days
(0 Reviews)
0.0
scadev

A proposal has not yet been provided

$15 AUD in 1 day
(0 Reviews)
0.0
tabmindsols

Hello Sir, We have gone through the details you have provided and we have already worked on a similar project before and can deliver as u have mentioned and would be pleased to work on this with you to deliver the resu More

$45 AUD in 3 days
(0 Reviews)
0.0
alexphisher

A proposal has not yet been provided

$25 AUD in 3 days
(0 Reviews)
0.0
joker321

Respected Sir, I am well versed in Oracle 11g,MySql,Sql Server 2005 and quite good in SQL,PL/SQL,T-SQL programming.....plus very good in java,C# programming as well. I went through your requirements , downloaded t More

$15 AUD in 0 days
(0 Reviews)
0.0