Self-Test Questions

Suggested Projects

1. Stock Photograph Database:   Design and implement an application that allows users to browse and download digital images by different categories (i.e., subject, photographer, etc.). Utilize RMI for client-server communication, and MySQL as the database engine.

2. Property Management Database:   Design and implement an application that allows property management professionals to manage their properties. The application must allow them to input new properties under their management along with one or more pictures of each property. New property information might include address, number of bedrooms, bathrooms and other related descriptive elements, amount of rent, owner and tenant information. Other things to consider: Owners can own more than one property. Tenants can rent more than one property. Allow users to browse available properties based on search criteria that might include address, zip code, number of bedrooms, etc.

3. Web Research Database:   Design and implement an application that allows you to ingest URL links along with descriptive information to interesting sites you find while conducting research on the web.

4. Personal Library Management System:   Design and implement an application that allows users to manage their personal library holdings regardless of media. The application should allow users to enter and manipulate information about each item and search the database for items by topic, author, artist, ISBN, etc.

5. Home Inventory Management System:   Design and implement an application that allows users to manage their personal home inventories. The application should allow users to input and manipulate information about each item including original cost, replacement cost, description, model, brand, location, etc.

6. Online Medical Records System:   Design and implement an application that allows physicians to enter and retrieve patient treatment information. (For the purpose of this exercise keep this system simple as you can literally spend years designing this thing!)

7. Online Employee Performance Review System:   Design and implement an employee performance review system. The application must allow employees to start the review process by creating a new review and adding their inputs and achievements for the year. When they “submit” the review it must be made available to the employee’s supervisor so they can add comments and submit to corporate HR.

8. Online Resume Submission System:   Design and implement an application that lets users submit text-based resumes online. The application would allow prospective employee users to paste an ASCII version of their resume into a text area. When they click submit the application would process the text area and extract keywords that can be inserted into a database along with the text of the resume. The application must allow company personnel to search the resume database for potential hires based on a keyword search.

9. National Sex Offender Tracking Database:   Law enforcement needs your help! Your mission — design and implement a national sex offender registration and tracking database. This application will be used by law enforcement personnel to keep tabs on the riffraff and facilitate information sharing between agencies.

10. National Handgun Purchase Authorization Database:   Your country needs your help yet again! To ensure customers truly have the right to keep and bear handguns their information must be submitted to an online application that searches a criminal history database. If there is a match they are denied the right to purchase.