Assignment 6: Library Database with Access
Assignment Objective: The purpose of the assignment is to provide the opportunity to gain practical experience with database design and implementation with ER model and MS Access DBMS.
Note: I put hours into solving the problem, but I could not figure out how to make Query #2 work... I apologize! I hate leaving any assignment incomplete!
See the ER Diagram
Download the Access Database file