Please let me know if I am headed in the right direction with this database (attached is a ERD design) and below is a description of what I need to complete.

An Art Museum that needs to track the artwork, artists, and locations where the art is displayed or stored within the museum. You must support tracking the artist for artwork where there is more than one artist (collaboration)

Please let me know if the database design is correct.

Also, how do you display cardinality in Visio?


JakeClick image for larger version. 

Name:	DBM.jpg 
Views:	2 
Size:	37.2 KB 
ID:	16281