Question

Draw the EERDs. Use Crow's notation. Include both disjoint/overlap and partial/complete constraints were needed.

Furniture Outlet sells both new furniture and consignment furniture items. Current-production household items that complement or are useful with the items are also sold. For example, the store sells dining room tables and new tablecloths. The consigned items (also keep track of the condition of the item) are purchased (date, qty, price) from both individuals (record taxID) and wholesalers (record discount percent), and the new items are purchased (date, qty, price) from distributors (record Contact person). The store’s customers include individuals, (owners of bed-and-breakfast operations, and local interior designers) who work with both individuals and small businesses. If the customer doesn’t actually buy anything from the outlet, the outlet does not keep customer data. The consigned items are unique, although some multiple items, such as dining room chairs, are available as a set (sets are never broken). A consigned item could be brought back to the outlet by a different customer. The new items are not unique, and a new item may be reordered if it is out of stock (include reorder point). Household items are also available in various sizes and colors (for example, a particular style of tablecloth may be available in several sizes and in a variety of colors).

Answer 1

Chen's notation Participations Cardinality can be shown or hidden Recursive Relationship Cardinality can be shown or hidden Entity Entity Attribute Attribute Mandatory 1 1 (0:1) (0:1) 1 1 1 1 (1:1) (1:1) Weak Entity Weak Entity Key attribute Key attribute N N (0:N) (0:N) 1 N 1 N (1:N) (1:N) M M Relationship Relationship Weak key attribute Weak key attribute (0:M) (0:M) 1 M 1 M (1:M) (1:M) Optional 1 Relationship Identifying Relationship Derived attribute Derived attribute 1 (0:1) (1:1) 1 N N 1 M Associative Entity (0:N) (1:N) (0:M) (1:M) Associative Entity Multivalue attribute Multivalue attribute 1 M Crow's Foot notation Many - to - One M:1 Entity (with no attributes) > + a one through many notation on one side of a relationship and a one and only one on the other M:1 # a zero through many notation on one side of a relationship and a one and only one on the other Entity (with attributes field) M:1 ot a one through many notation on one side of a relationship and a zero or one notation on the other FLU * 0 M:1 0+ a zero through many notation on one side of a relationship and a zero or one notation on the other Entity (attributes field with columns) Many-to-Many M:M Entity (attributes field with columns and variable number of rows) a zero through many on both sides of a relationship M:M > K a one through many on both sides of a relationship Relationships (Cardinality and Modality) M:M a zero through many on one side and a one through many on the other Zero or More Many-to-Many > One or More 1:1 + O+ a one and only one notation on one side of a relationship and a zero or one on the other One and only One + 1:1 +O Zero or One E + a one and only one notation on both sides

Feel free to Rate & Comment. Enjoy your study...

.