This is what I have so far (not fully sure if this covers all of the Deliverables):

Project Description In this project, you will practice designing an application database system from scratch. You need pick a database application and design your own database system with at least 5 entities. Your design will be composed of the following steps: 1. Describe the data requirements of your picked application 2. Draw an ER diagram for your design 3. Design relational schema based on your design (mapping ER schemas to relational schemas) 4. Pick a relational database management system such as Oracle, MySQL, SQL Server create the tables and populate each table with at least 6 tuples 5. Design 6 queries, and express the queries in SQL or PLUSQL. Run the queries on the picked RDBMS present the result. At least 3 queries must involve 2 or more tables Upon the completion, you need submit a written report for this project. The report should include every step of your design. More or less, your report serves as the documentation of the data requirement of your picked application database, and your design and development of the database. So Online car rental database. The database should contain customer information, location of company site for each city, different type of cars, rental price, available rental programs, promotions, as well as information about each rental transaction include pickup site, time, return site, time, payment, etc. Data on mutual fund companies, their offerings and portfolios within those offerings. Medical database covering diseases, symptoms, diagnosis, drugs, patients, patient history, etc. Provision could be made for embedded X-Ray, MRI, ultra sound or other magcs. A movie database that records information about movies including production studios, actors, directors, category, song, awards, etc A database for DVD/video games rental/trading/exchanging store An on-line banking database A database for an auto insurance company Flight reserving system Milestones and liverables and dates: 1. Phase 1: Pick an application database Option Pick an application database and provide a detailed description about the database. The real world entities, their relationships, and some of constraints of this application database shall be specified at this stage. Your future design and