Require a online booking system to be created for a Driving School.
The site must be created using javascript and allow pupils to to book driving lessons on-line. All data must be stored in a SQL database.
**Administrators must be able to:**
- Register pupils (including address, telephone, email and username) and allocate them a driving instructor
- Add new instructors (name, phone number)
- Delete instructors
- Add appointments to any instructors calendar
- Delete pupils
- Delete bookings
- Amend instructors details
- Search for appointments by pupil/instructor/ref number or by date
**Pupils must be able to:**
- Log into the system with their allocated username and password
- Amend the details held about them (as above)
- Search for available lesson times with their allocated instructor ONLY. This should be in the form of a calender where that can pick a date.
- Book lessons in one hour slots - each booking should be allocated a reference number
- Cancel lessons if more than 24 hours notice is given
- Receive an email confirmation each time they book or cancel a lesson
The version of IIS which should be used is 5.0 and SQL Server 2000 should be used for the database (Stored Procedures can be used).
The software should be able to cope with multiple transactions and not allow multiple booking to be made for the same instructor at the same time.
The source code should be fully commented.
Detailed instructions on how to configure the site and database will be required.
The code must be as simple as possible. This assignment should reflect a person with basic and not advanced programming skills.
Further information can be provided.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
The code must run within IIS 5.0.
ASP\Javascript should be used for the web-site components.
CDONTs can be used for SMTP
SQL 2000 Server should be used for the Database.
The Web-Site should work in all browsers later then I.E 5.5
Compatibility with other browsers is not required.