custom writing services

Need more information?: Chat with us

order download
Average score 4.96 out of 5 based on 673 opinions

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.

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.


Structuring Systems Requirements:

Conceptual Data Modeling

Jim Watanabe, manager of the “No Customer Escapes” project, and assistant director of IT for Petrie’s Electronics, was sitting in the company cafeteria. He had just finished his house salad and was about to go back to his office when Stephanie Welch sat down at his table. Jim had met Stephanie once, back when he started work at Petrie’s. He remembered she worked for the database administrator.

“Hi, Jim, remember me?” she asked.

“Sure, Stephanie, how are you? How are things in database land?”

“Can’t complain. Sanjay asked me to talk to you about the database needs for your new customer loyalty system.” Stephanie’s phone binged. She pulled it out of her oversize bag and looked at it. She started to text as she continued to talk to Jim. “How far along are you on your database requirements?”

That’s kinda rude, Jim thought. Oh well. “We are still in the early stages. I can send you a very preliminary E-R diagram we have [PE Figure 7-1], along with a description of the major entities.”

“OK, that will help. I suspect that you won’t have too many new entities to add to what’s already in the system,” Stephanie responded, still looking at her phone and still texting. She briefly looked up at Jim and smiled slightly before going back to texting. “Just send the E-R to me, and I’ll let you know if I have any questions.” She stood up, still looking at her phone. “Gotta go,” she said, and she walked away.

OK, Jim thought, I need to remember to send Stephanie the preliminary E-R we have. I should probably send her the entity descriptions too (PE Table 7-1), just in case. Jim stood up, carried his tray over to the recycling area of the cafeteria, and went back to his office.

When Jim got back to his office, Sanjay was waiting for him.

“I’ve got more information on those alternatives we talked about earlier,” Sanjay said. “I had one of my employees gather some data on how the alternatives might satisfy our needs.” (See the descriptions of the alternatives in PE Table 5-2.) Sanjay handed Jim a short report. “The matrix shows the requirements and constraints for each alternative and makes it relatively easy to compare them.” (

PE FIGURE 7.1 Initial E-R for Petrie’s customer loyalty program.

PE TABLE 7-1: Entity Descriptions for the Preliminary E-R Diagram for Petrie’s Customer Loyalty System




A coupon is a special promotion created specifically for an individual customer. A coupon is for a set dollar amount, for example, $10. The customer may use it like cash or like a dollars-off promotion when purchasing products or services. Coupons can only be created for an individual customer based on the points in his or her customer loyalty account. For each dollar value of a coupon, a certain number of points must be redeemed. Coupons must be accounted for when created and when redeemed.


A customer is someone who buys products and/or services from Petrie’s Electronics. Customers include both online customers and those who shop in Petrie’s Brick-and-Mortar stores.


An item made available for sale to a Petrie’s customer. For example, a product is a 40” Sony LCD HD television. Products can be purchased online or in Brick-and-Mortar stores.


A promotion is a special incentive provided to a customer to entice the customer into buying a specific product or service. For example, a promotion intended to sell Blu-ray disks may involve 2-for-1 coupons. Promotions are targeted to all customers, or to subsets of customers, not just to individual customers.


A job performed by one of Petrie’s associates for a customer. For example, upgrading the memory in a computer by installing new memory cards is a service that Petrie’s provides for a fee. Services may only be ordered and performed in Brick-and-Mortar stores, not online.


A record that a particular product or service was sold to a specified customer on a particular date. A transaction may involve more than one product or service, and it may involve more than one of a particular kind of product or service. For example, one transaction may involve blank DVDs and prerecorded DVDs, and the prerecorded DVDs may all be of the same movie. For members of the loyalty program, each transaction is worth a number of points, depending on the dollar value of the transaction.

Top of FormPageGoto the specified printed page number

Bottom of Form

Print Activate the following button to retrieve the URL to cite or link to this pageCite/Link

“The matrix favors the XRA CRM system,” Jim said, after looking over the report. “It looks like their proposal meets our requirements the best, but the Nova group’s proposal does the best job with the constraints.”

“Yes, but just barely,” Sanjay said. “There is only a five-point difference between XRA and Nova, so they are pretty comparable when it comes to constraints. But I think the XRA system has a pretty clear advantage in meeting our requirements.”

“XRA seems to be pretty highly rated in your matrix in terms of all of the requirements. You have them ranked better than the other two proposals for implementation, scalability, and vendor support,” Jim said. “The ‘5’ you gave them for proven performance is one of the few ‘5s’ you have in your whole matrix.”

“That’s because they are one of the best companies in the industry to work with,” Sanjay responded, “Their reputation is stellar.”

“This looks really promising,” Jim said. “Let’s see if reality matches what we have here. It’s time to put together the formal request for proposal. I’ ll get that work started today. I hope

PE FIGURE 7-2 Evaluation matrix for customer loyalty proposals.

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. 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.
Using your answer to Question 2, designate which attribute or attributes form the identifier for each entity type. Explain why you chose each identifier.
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 or MS. Word.


  simple order process Pricing order download You have just landed to the most confidential, trustful essay writing service to order the paper from. We have a dedicated team of professional writers who will assist you with any kind of assignment that you have. Your work is handled confidentially with a specific writer who ensures you are satisfied. Be assured of quality, unique and price friendly task delivered in good time when you place an order at our website. banner We have a team of dedicated writers with degrees from all spheres of study. We readily accept all types of essays and we assure you of content that will meet your expectations. Our staff can be reached  via live chat, email or by phone at any given time with prompt response.  

Prices starting at:

High school
Undergrad.(yrs 1-2)
Undergrad.(yrs 3-4)
$10 / page
$10/ page
$12/ page
$15 / page
$17/ page

Note: The prices in the table above are applicable to orders completed within 14 days. Kindly see the full price table for more prices..

We urge you to provide as much information as possible to avoid many revisions. Set your deadline, choose your level, give payment information and relax while you track your work. We will deliver your paper on time. . 1 Are you in a quagmire and you are unable to complete your assignments? Do you doubt yourself on the quality of the essay you have written?  is here to assist you. We will offer you unmatched quality that is plagiarism free. Place an order at  for guaranteed  high grades. order download

we offer gifts to our paper help customersPayment Methods

you can request our services and pay via paypal

we offer gifts to our paper help customersOur Guarantees

  1. Zero plagiarism.
  2. 100% confidentiality.
  3. FREE Reference page
  4. High Quality papers
  5. 24/7 Customer support

Our Testimonials Testimonials

I ordered a 7 page college essay and was delivered on time. Thank you guys I will definitely order again!

, FL

Our statisticsOur Statistics

  • Orders Completed todate 736543

  • Number of writers 182

  • Satisfied customers 99.3%

  • Returning customers 96.3%

  • Orders placed today 46