Project #106016 - E-R modeling

Description Answer the two problems below by rendering complete Entity-Relationship (E-R) diagrams. You should create your E-R diagrams in Visio or PowerPoint. Please use the line/fork notation to represent your cardinalities. Be sure to specify identifying attribute(s) for each entity and include the minimum and maximum cardinalities for all relationships. You should not include composite or derived attributes in your diagrams. Each student should prepare this assignment individually, but may consult with their group members. 1. Prepare an E-R diagram for Palouse Hardware, Inc. based upon the description provided below: The store needs to keep track of EMPLOYEE information. Important EMPLOYEE information includes name, address, and employee_ID. Each EMPLOYEE can record many SALES TRANSACTIONS, but some EMPLOYEES have never recorded a SALES TRANSACTION. A SALES TRANSACTION is recorded by exactly one EMPLOYEE. Important information regarding SALES TRANSACTIONS includes transaction_no, sale date, and register number. SALES TRANSACTIONS may include many hardware PRODUCTS but at least include one PRODUCT. A PRODUCT may be included on many different SALES TRANSACTIONS. PRODUCT attributes include product number, product description, product price, and units available. The many-to-many relationship between SALES TRANSACTION and PRODUCT is best represented by the entity TRANSACTION DETAIL. The identifying attributes of a TRANSACTION DETAIL are product number and transaction_no. Other attributes include sale_price and quantity. Each TRANSACTION DETAIL is related to exactly one SALES TRANSACTION and to exactly one PRODUCT. A PRODUCT may be included on many TRANSACTION DETAILS, but is at least included on one. A SALES TRANSACTION includes at least one TRANSACTION DETAIL and may include many. The hardware store has many PRODUCT LINES. Each PRODUCT LINE contains at least one and often many different PRODUCTS. Each PRODUCT must belong to one, and only one, PRODUCT LINE. Important PRODUCT LINE information includes product line name (identifying attribute) and aisle number. 2. Prepare an E-R diagram for WestCoast Billiards based upon the description provided below. Note this problem contains multiple relationships between two entities. WestCoast Billiards has over 20 different retail STORES on the west coast. Each STORE has a unique store number, an address, and a phone number. Each STORE has at least one and typically many EMPLOYEES. Attributes of EMPLOYEE include employee number, address, and phone number. An EMPLOYEE must be assigned to only one STORE. Each STORE is managed by exactly one EMPLOYEE. An EMPLOYEE may manage at most one STORE and may not manage any STORE. CUSTOMERS are associated with a specific STORE based upon their geographic location. A CUSTOMER must be associated with only one STORE, but each STORE has at least one and typically many CUSTOMERS. Important customer information includes customer name, address, and email address. Deliverables Your submission should include one Word document that includes each diagram on a separate page. You will need to copy and paste your diagrams from PowerPoint or Visio into your Word document. Please be sure to include your name and WSU ID number at the top of this document. Please submit your document via the assignment drop box (select the Assignments link on the left of the screen).

Subject Business
Due By (Pacific Time) 01/30/2016 05:00 am
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy