Complete your video on demand (VOD) web-site database programming project by augmenting your project's user interface with the JDBC and SQL3 code needed to carry out all the transactions specified in the project description. Note that you must use JDBC and SQL3 to implement the transactions; no alternative mechanisms will be allowed.
Your grade for the final project will be based on a 15-minute demo. Demos slots will be available on Friday and Saturday, December 14-15, 2001, although it is also possible that we will be able to finish all the demos in one day. In this case, demos will only take place on Friday, December 14. Will keep you posted. Signup sheets for demo slots will be posted on the bulletin board outside my office, on or about Wednesday, December 5, 2001. Each team should sign up for eactly one slot. Write your team name and the names of the two team members in the slot you choose.
Be sure to show up at least 15 minutes before your demo is scheduled to begin. All demos will be held in the Graduate PC Lab, Computer Science Building, Room 1239.
Do not be late for your assigned demo slot as this will result in a failing grade for your demo.
If you wish to give your demo on your own PC, then you should set up your PC in Room 1203, which is next door to Room 1239. Make sure your PC is booted up and ready to go so there is no delay in getting your demo started. If you plan to do this, then you should see me before or after class (or during office hours) for the combo to Room 1203.
You should practice your demo several times before the day of your scheduled presentation. Each demo will last exactly 15 minutes and under no circumstances will you be allowed to exceed this length of time. The more polished and professional-looking you and your demo are, the easier it will be for the TA to rapidly understand what you are trying to show him.
Prior to your demo, you should initialize your database with the sample data that you can find by clicking here. The TA will ask you to perform a series of transactions based on this data and your results will be expected to match those that we have precomputed for the demo data.
To complete your database project, you will also need to produce professional-quality online documentation, consisting primarily of a users guide and a programmers guide. The users guide should explain to a potential user of your system how to browse your database, post a resume or job description, request an interview, etc. Your should provide a help menu and an online FAQ (Frequently Asked Questions).
Your user documentation should also provide guidance to employees and managers of the VOD seb site, including clear descriptions of all screen formats, buttons, menu options, and report formats. Your user documentation should make it simple for a novice user, say a recent AOL subscriber, to navigate through your system and exercise all of its functionality.
Your online programmers guide should describe the design of your online job/resume database system, including the following:
You will have already prepared some of these items in conjunction with previous
assignments. In these cases, just integrate your prior work into the
programmers guide.
Good luck!