In this project you are required to design a database for managing a library database. To fulfil the design requirement you should submit the following:
- Describe the project and document the following requirements:
- Fully document the library database design requirement
- Draw the E-R Diagram
- Clearly set the business rules and the different type of user views
- Identify the different type of relationships used
- Clearly explain the normalisation process of the database
- Identify the functional dependencies in the library database
- Document the needed Quires, Reports and Forms used by the library
(20 Marks)
- Implement the design using MS- Access software
- Design the reports needed for the library
- Design the needed Queries
- Design all required forms to implement your database
(20 Marks)
- Implement the SQL commands to generate the Quires you have designed in step 2, you should write at least five SQL commands Quires
(20 Marks)
Leave A Comment