Given the following business rules that describe a bookstore operation and the cardinalities involved, draw a basic Crow
Posted: Tue Jul 12, 2022 8:16 am
Given the following business rules that describe a bookstoreoperation and the cardinalities involved, draw a basic Crows FootERD that includes cardinalities and visually describes the basicbookstore operational relationships between the businessentities.
One student places one-to-many orders.
One order lists one-to-many order-items (books).
One book can be listed in any order items.
A course requires one or more books.
Remember that entities are identified by the nouns in thebusiness rules. Each noun will become an entity. I would highlyrecommend you watch the video Entity Relationship Modeling in ourWeekly Assigned Readings and Videos. You can also create your ERDusing pen and paper, so you don’t need to use a modeling tool. Ifyou do build your ERD using pen and paper make sure your entity'snames and cardinality symbols are easy to read and recognize.
One student places one-to-many orders.
One order lists one-to-many order-items (books).
One book can be listed in any order items.
A course requires one or more books.
Remember that entities are identified by the nouns in thebusiness rules. Each noun will become an entity. I would highlyrecommend you watch the video Entity Relationship Modeling in ourWeekly Assigned Readings and Videos. You can also create your ERDusing pen and paper, so you don’t need to use a modeling tool. Ifyou do build your ERD using pen and paper make sure your entity'snames and cardinality symbols are easy to read and recognize.