Order For Similar Custom Papers & Assignment Help Services

Fill the order form details - writing instructions guides, and get your paper done.

Posted: March 2nd, 2023

E-r diagram in microsoft visio

Again, review the DFDs you developed for the Petrie’s Electronics case (or those given to you by your instructor). Use these DFDs to identify the attributes of each of the six entities listed in this case plus any additional entities identified in your answer to Question 1. Ace my homework – Write an unambiguous definition for each attribute. Then, redraw PE Figure 7-1 by placing the six (and additional) entities in this case on the diagram along with their associated attributes. 
PROMOTION ID 
1. PROMOTION_ID- PROMOTION CODE PROVIDED BY COMPANY 
2. PROMOTION_AMOUNT- PROMOTION AMOUNT FOR THE CODE 
COUPON ID 
1. AMT_POINTS- THE AMOUNT OF POINTS THE CLIENT HAS 
2. COUPON_ID DISCOUNT CODE OFFERED BY THE COMPANY 
CUSTOMER ID 
1.ONLINE_NAME- LOG IN OR USER NAME 
2.CUSTOMER_NUMBER- REWARDS CARD NUMBER FOR IN STORE SHOPPERS 
SERVICES ID 
1.SERVICE_ID- SERVICE IDENTIFIER FOR SERVICE RENDERED 
2.STORE_JOB- -STORE PROVIDING SERVICES 
TRANSACTION ID 
1. TRANSACTION ID- ID FOR TRANSACTION TYPE 
2. TRANSACTION_TYPE_ TYPE OF TRANSACTION BEING PRERFORMED 
PRODUCT ID 
1.PRODUCT_ID- PRODUCT NAME 
2. PRODUCT_QUANTITY-AMOUNT OF PRODUCTS NEEDED 

3.Using your answer to Question 2, designate which attribute or attributes form the identifier for each entity type. Explain why you chose each identifier. 

4. Using your answer to Question 3, draw the relationships between entity types needed by the system. Remember, a relationship is needed only if the system wants data about associated entity instances. Give a meaningful name to each relationship. Specify cardinalities for each relationship and explain how you decided on each minimum and maximum cardinality at each end of each relationship. State any assumptions you made if the Petrie’s Electronics cases you have read so far and the answers to questions in these cases do not provide the evidence to justify the cardinalities you choose. Redraw your final E-R diagram in Microsoft Visio.

Order | Check Discount

Paper Writing Help For You!

Special Offer! Get 20-25% Off On your Order!

Why choose us

You Want Quality and That’s What We Deliver

Professional Writers

We assemble our team by selectively choosing highly skilled writers, each boasting specialized knowledge in specific subject areas and a robust background in academic writing

Discounted Prices

Our service is committed to delivering the finest writers at the most competitive rates, ensuring that affordability is balanced with uncompromising quality. Our pricing strategy is designed to be both fair and reasonable, standing out favorably against other writing services in the market.

AI & Plagiarism-Free

Rest assured, you'll never receive a product tainted by plagiarism or AI-generated content. Each paper is research-written by human writers, followed by a rigorous scanning process of the final draft before it's delivered to you, ensuring the content is entirely original and maintaining our unwavering commitment to providing plagiarism-free work.

How it works

When you decide to place an order with Nurscola, here is what happens:

Complete the Order Form

You will complete our order form, filling in all of the fields and giving us as much detail as possible.

Assignment of Writer

We analyze your order and match it with a writer who has the unique qualifications to complete it, and he begins from scratch.

Order in Production and Delivered

You and your writer communicate directly during the process, and, once you receive the final draft, you either approve it or ask for revisions.

Giving us Feedback (and other options)

We want to know how your experience went. You can read other clients’ testimonials too. And among many options, you can choose a favorite writer.