Draw an ERD for the following situation. Artwork is generated by an artist, denoted as 0:1 (0 for an unknown artist). An alternative approach could involve having a valid artist instance with the name "Unknown." This modification would allow the enforcement of a business rule stating that every artwork piece must be associated with an artist stored in the database. Consequently, the cardinality near the artist entity in the diagram would change to a mandatory 1. The Item Status attribute of artwork enables the categorization of artwork as Display (requiring a valid value for the Item Museum Location attribute), Storage, Loan, or Shows. Artwork items can be featured in a show; however, the current entity-relationship diagram (ERD) does not provide a mechanism to indicate that an artwork item cannot be part of two shows with overlapping dates. This business constraint will need to be documented as part of the system design.
- Draw an ERD for the following situation.
Artwork is generated by an artist, denoted as 0:1 (0 for an unknown artist). An alternative approach could involve having a valid artist instance with the name "Unknown." This modification would allow the enforcement of a business rule stating that every artwork piece must be associated with an artist stored in the
The Item Status attribute of artwork enables the categorization of artwork as Display (requiring a valid value for the Item Museum Location attribute), Storage, Loan, or Shows. Artwork items can be featured in a show; however, the current entity-relationship diagram (ERD) does not provide a
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
