Question
Draw the ERDs for the following business rules using Gliffy. Copy/paste your diagrams to Word and then convert to .pdf for submission. Professional quality is
Draw the ERDs for the following business rules using Gliffy. Copy/paste your diagrams to Word and then convert to .pdf for submission. Professional quality is expected. Identify all entities, attributes, relationships, primary & foreign keys, cardinalities and constraints where appropriate. Each complete entity (including all attributes, primary key, and foreign key(s)) receives one point and each relationship (labeled with cardinalities in both directions) receives one point. Any constraint used correctly, receives two points. Primary keys will be bold or underlined, foreign keys in italics ONLY (no PK or FK on your diagrams). Label your relationships if there are more than one between the same entities. Make sure your diagrams are clear and easy to read - show one diagram per page - do not include the business rules with your diagrams. Include your name and section on all pages. Show resolved M:N relationships. )
1. 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 stores customers include individuals, owners of bed-and-breakfast operations, and local interior designers who work with both individuals and small businesses. The consigned items are unique, although some multiple items, such as dining room chairs, may be available as a set (sets are never broken). 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). Other attributes include the following:
(ItemID, ItemDescription, Manufacturer, Model, ItemCost, VendorName, VendorPhone, VendorEmail, VendorURL, CustomerLastName, CustomerFirstName, Street, City, State, Zip, CustomerPhone, SaleDate, RetailPrice, Tax, SaleAmount)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started