The project involves the design, development, and implementation of the Database that could be used by the client-server application (to be utilized by librarians). High-level functionality developed and executed are:
- Loaded initial data files (provided) using SQL Developer Import utility (no need to develop UI) into temporary tables (one temporary table per file)
- Created DB tables (wrote and executed SQL statements, did not use UI) described in the high-level schema
- Written SQLs to Normalize and populate data into tables
- Generated test data to simulate borrowing and fines transactions
- Made Reports and Searched SQLs