In Progress

Venue booking simple basic application

You are asked to write a venue booking application for a small events company

to facilitate the management of the bookings made for venues that are affiliated

to them. There are 2 types of users of the system, namely, admin and user.

Admin can upload all the details of new venues that are managed by the

company to the database. Include details such as the name, location, type (hotel

restaurant, conference centre, sports clubhouse, community hall, etc), cost,

maximum number of guests, availability, date, etc. Admin can also add new

users to the database.

A user can capture details of a customer who has decided to book a venue, and

upload to the database. The details of the booking transaction must also be

captured in the database.

Design a single-client/server system which maintains a database for the

business.

The user or admin requests database information and operations via the client

application. The client sends the database request to the server which executes

the request and returns the results of the request back to the client. Only the

server interacts with the database.

Use Apache Netbeans to write your Java code, and use a Derby database to

store data.

You may NOT use drag-and-drop for your GUI design.

CLIENT-SIDE REQUIREMENTS

Write a GUI application which presents the user with options to manipulate the

database. Users can login as admin or user.

The minimum functionality of the admin client is:

1. Add details of a new venue to be managed to the database.

2. Add details of a new user to the database.

3. Venue and user details can be updated.

4. A user cannot be deleted from the database, but, should a user leave the

company the database record should be updated to reflect that the user is

inactive. Use a Boolean field for this.

The minimum functionality of the user client is:

1. Add details of a new customer to the database.

2. Record the transaction in the database when a customer books a venue.

The requested date for the booking must also be captured. Minimize

typing by selecting from a list of venues of a selected type that are

available for a selected date. Similarly, select a customer from a sorted list

rather than typing.

3. List all the bookings in the database sorted by customer surname

4. Display an invoice for the booking made by a selected customer.

5. Allow the user to select a date, and list all available venues for that date.

Reduce chances of typing errors by making intelligent use of GUI items that

require simple mouse-clicking to make selections.

SERVER REQUIREMENTS

Receive requests from the client to do transactions on the database. Results of

these database requests are sent back to the client.

1. Add a new venue: execute the SQL command(s)

2. Add a new user: execute the SQL command(s)

3. Update venue and user: execute the SQL command(s)

4. Add a new customer: execute the SQL command(s)

5. Booking transaction

a) Execute SQL to select all customers and send details to client.

b) Execute SQL to select all venues of a specific type that are available

on a selected date and send details to client.

c) Receive the selected customer and venue from the client.

d) The database record of the venues must be updated to reflect the

change in availability for the selected date. Execute SQL to update the

database venue table.

e) Execute SQL to add a transaction record into the booking table.

f) Send a message to client indicating new booking is completed

6. List all bookings, sorted by customer surname: Execute SQL to select all

booking data and send to client

7. List all available venues for a selected date: Execute SQL to select

appropriate venue data and send to client

8. Booking invoice: Execute SQL to select appropriate data and send to client

Skills: MySQL, Java, Netbeans, Graphical User Interface (GUI)

See more: php simple sign application, simple blackberry application development, simple job application, visual basic application data import, simple j2me application layout, develop simple iphone application 2008, simple visual basic application sort excel data, simple basic cms, simple poll application, booking system web application, simple chat application visual basic net, simple visual basic application put phone number text send text message cell phones cell phoneemail interface, simple application visual basic application, visual basic simple gui application, simple basic gui application, small simple android application source code, simple booking visual basic, simple php application appointment booking

About the Employer:
( 0 reviews ) South Africa

Project ID: #31633490

Awarded to:

popularcontent12

Hello, I am a software and Web Developer. I hava also lot of experience in Designing. I have some rules and regulations before start of project: 1. Provide 100% work within deadline. 2. Provide unlimited revisions un More

$30 USD in 1 day
(55 Reviews)
5.1

5 freelancers are bidding on average $92 for this job

CodingHelpLine

Hello I'm Sun Certified Java Programmer. Contact for awesome Java desktop (Console, Swing, JavaFX), Web (JEE, Spring) and Android apps. I assure you an excellent solution of your project within the time frame and exac More

$100 USD in 3 days
(40 Reviews)
4.6
aekpani

Hi There, Love to provide you Venue Mangement System as per your requirements... Love to discuss to provide you 100% as per your requirments... Regards

$300 USD in 7 days
(3 Reviews)
2.9
artistixeit

Hello Greetings As per your project description i percieved that you are looking for the mobile application developer to create venue booking app. After my initial analysis i understand that your website needs these fe More

$20 USD in 7 days
(4 Reviews)
6.2
adeelweb1122

Greetings I can surely help you for Venue booking simple basic application I am in the IT industry since more than a decade and serve so many clients for building and rebuilding websites, software and applications a More

$10 USD in 2 days
(0 Reviews)
0.0