Database Management Project:

Library System

You are implementing a computer-based information system for a library. You are to design a database application to support the activities of the library based on your knowledge.

A narrative generally and objectively describes the systems functionality;

A data flow diagram of the systems functionality.

An ER model of the system.

A normalized representation of tables for the application, to include keys, foreign keys, domains, constraints, and statement of underlying business rules.

A listing, with accompanying design/format of objects to be materialized by the system

A proffering of the SQL statements necessary to extract the data for the database objects to be materialized, generate and utilize sample data to illustrate the outputs/reports to be generated.