Create s simple database for an Information System. It gives a simple example of a complete system with the functionality of add record, search record, Update record and delete record. If students understand basic CRUD (Create, Read, Update and Delete) functionality it would be easy for them to create any Management System using this functionality. The Database has 5 major functions Add New record (INSERT) Search and view a record (SELECT,WHERE,JOINS) Modify a record(UPDATE,MODIFY,ALTER,DROP,RENAME) Delete a record(DELETE,DROP) Follow the following steps and document along the way 1. Requirements collection and analysis 2. Database design a. Conceptual database design with normalization b. Logical relational database design (ERD) c. Physical relational database design the actual design of a database according to the requirements that were established during logical modeling.

3. Application design Select your management system from the following list or use your creative imagination to make a management system 1. Student Management system 2. Pharmacy management system 3. Blood bank management system 4. Book store management system 5. Employees management system 6. Bank Accounts management system 7. Hospital Management system 8. Salary management system etc..