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:

 

  1. 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)

 

  1. 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)

 

  1. 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)

 

Related posts: