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

University at Buffalo

Who am I? I am a graduate student at the University at Buffalo, earning my MLS. I am also the Interlibrary Loan Specialist at SUNY Canton and SUNY Potsdam. For more, see my CV.

The one and only. Google my name and every result on the first page should be me, or my Great Grandfather, Glen F. No, I'm not counting the Glenns.