We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Petrie Electronics Case Essay

Sorry, but copying text is forbidden on this website!

1. The entities Report, Purchase, and Employee could be added. Report consolidates the account details of a customer. It involves recent purchases, coupons history and points summary. Purchase shows a record of what the customer buys. It logs the coupon usage, list of products purchased and the date of purchase. Employee would be the person working for Petrie Electronics and currently monitoring the transactions and services. 2. Coupon- special promotion created for a specific customer. Customer- someone who buys products.

Product- an item made available for sale.
Promotion- a special incentive provided to the customer.
Service- a job performed by one of Petrie’s associates.
Transaction- record that a particular product or service was sold to a specific customer. Purchase- a unique number used to identify a purchase.
3. Coupon_ID
Customer_ID
Product_ID
Promotion_ID
Service_ID
Transaction_ID
Report_ID
Purchase_ID
Each identifier was chosen for the following reasons:
Must be a noun
Follows a standard format
Similar but distinguishing names
States what the attribute is and why it is important

4. These are drawn in problem 1 in the dia diagram. One-to-many includes customer to coupon, customer to purchase, customer to transaction, product to purchase and employee to transaction. Zero-to-many includes customer to promotion and product to transaction. Customer to report is a one-to-one.

5. The entity Employee does not play an important role in Petrie’s case. It is necessary for an employee to be present to make changes to a transaction. Considering an ER diagram design from a database point of view, the transactions are monitored by the database admin. The absence of this entity does not have any great consequence.

We will write a custom essay sample on Petrie Electronics Case specifically for you

Order now

7.Coupon_Expiry_Date, Transaction_Date, Report_Date, Purchase_Date, Promotion_Expiry Date.

Attributes must be kept to keep track of historic time and maintain records for later reference.

How to cite this page

Choose cite format:

Petrie Electronics Case. (2016, Apr 28). Retrieved from http://1js.bet/petrie-electronics-case-essay

We will write a custom essay sample onPetrie Electronics Casespecifically for you

Our customer support team is available Monday-Friday 9am-5pm EST. If you contact us after hours, we'll get back to you in 24 hours or less.

By clicking "Send Message", you agree to our terms of service and privacy policy. We'll occasionally send you account related and promo emails.
No results found for “ image
Try Our service
online

Hi, I am Sara from Studymoose

Hi there, would you like to get such a paper? How about receiving a customized one? Check it out http://goo.gl/CYf83b

online

Hi, I am Sara from Studymoose

Hi there, would you like to get such a paper? How about receiving a customized one? Check it out http://goo.gl/CYf83b

image

Your Answer is very helpful for Us
Thank you a lot!

Sitemap