Some topics that I come up with:

• Information System for Supplied Chain Supermarket (e.g. Walmart)
• Information System for Autopart Store (e.g. Auto Checker)
• Book Store Information System (e.g. Barnes and Noble) [taken]
• Library Information System (e.g. NMSU Library) [taken]
• Hotel Management System (e.g. Hilton Hotel) [taken]
• Airline Reservation System (e.g. Southwest) [taken]
• Information System for a Telephone Company (e.g. Qwest)
• Banking System for a Bank (e.g. Wellsfargo)
• Geographical Information System (e.g. Mapquest)
• Human Resource Management System (e.g. University HMR)
• Information System for Transportation Company (e.g. FedEx)
• Information System for Airtraffic Control at an Airport (e.g. El Paso Airport)
• Departmental Graduate Student Information Systems [Assigned - Group ]

You can come up with your own project topic: Group 1 decided to work on an information system for groceries store.

Requirement

Each team is required to write up a report detailing the design of its database system. The report should include:

1. System Analyst: Write in plain English
   1. what are the requirements for the system?
   2. what are the feeatures that the system can offeer?
   3. who are the intended users of the system?
   4. what can a user do?
   5. what benefits are there for using your system?
   6. what are the ten often asked questions in your application?

   Requirements from the literature are acceptable.

   Do not forget the assumptions you have made when design the database.

   For example: I assume that the library has only one copy of each book when I design a database for the library. Furthermore, I assume that each library item has an ISBN. Therefore, I use ISBN as the key of the entity named 'LibraryItem';

2. An E/R diagram with constraints. Clearly identify
   1. Entity sets, each their attributes and key(s)
   2. Relationships , each with its attributes, the set of entity sets involved in it, and its multiplicity

3. Translation of the E/R diagram into relational schema.
4. How did the ten most often asked questions affect the design of database?

For this step, you need to include in your report the SQL/Oracle command that you use to create the tables in your database.

Follow this link for the instruction on creating database application with PHP.