Lecture class(repost)

Design and implement a database for a lecture booking system. The system is for a lecture course study. This is where customers sign up for new courses and qualifications. There is a range of courses available to choose from and only a limited number of seats available for each course. The system should be able to book customers into lecture sessions. However since the class gets so busy, they system must be able to check how many seats are available before making a booking, and when booking a seat for a student they must be able to make group bookings and be able to allocate seats in the order that the customer requires. The system should be able to make on the spot booking and be able to calculate the cost for the bookings made by the customers. There will be different rates for different customers. The system should have some sort of a login system for admin and staff. The system should be able to print reports showing the percentage capacity of each course taken for each day. The system should be able to store additional information about courses, including pictures in the database. Provide all the necessary system maintenance functions, including facility to upload course schedule and course information. And finally the system should be able to produce some graphical interface for the seating plan. ## 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 Windows XP, Microsoft Access 2003, Microsoft Visual Basic