I have a database design problem. I am doing a database project as an independent study for my archaeology professor. He is currently using an excel file to catalog items. He has multiple boxes of artifacts. Each of these boxes has items from a project and/or site. He has pdf reports he wants to link to the sites/projects. He also wants to be able to view images he has taken of different items in each project.
He wants the db done in access and a switchboard interface to boot. Can someone look at this excel file and tell me how many tables they think I should have and the relationships you think they should have. ProjectName seems to be a likely candidate for a primary key, but it is not unique, and there are a lot of empty fields. I could put "unknown" in the blank fields, but this still would not address the unique factor. Please help, thanks.