Create an Oracle database using an ERD.

Question : 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..

Guideline:

Also Document the whole process of database development. The document should contain name and description of information system, requirement collection and analysis, Conceptual design with normalization, ERD and then physical schema of database. Implement the whole schema in Oracle and use DESC and SELECT statement for all tables (add sample data). Perform DML,DDL and DCL statements on your sample data as well. Attach screenshots.