Create a level-0 dfd and a level-1 dfd

Assignment Help Visual Basic Programming

Reference no: EM131284070 , Length: 3

Description

Petrie's Electronics is a company running a chain electronic stores. Recently, the executive team decided that the number one priority the company hadwas to not only survive but to thrive and to prosper, and the way to do that was to develop closer relationships with the customers. The company would want to attract new customers, like all of competitors.But also like those competitors, the company would want to keep their customers for life, kind of like a frequent flier program. And the company would want to reward most the customers who spend the most. The called the project "No Customer Escapes."

The following data contain the four core functions the system must perform and the description of entities within Petrie's Customer Loyalty System.Create a Level-0 DFD, a Level-1 DFD, and an ERD based on the description within the two tables and the context diagram. Note that the ERD must be in 3rd Normal Form and there should not be any syntax error within the DFDs.

Function

Record customer activities - When a customer makes a purchase, the transaction must be recorded in the customer loyalty system, as the rewards the system generates are driven by purchases. Similarly, when a customer uses a coupon generated by the system, it must also be recorded, so that the customer activity records can be updated to show that the coupon has been used and is now invalid.

Send promotions - Data about customer activities provide information about what types of products customers tend to buy and in what quantities. This information helps determine what sales promotion materials are best targeted at what customers. For example, customers who buy lots of video games should receive promotions about games, game platforms, and HD TVs.

Generate point redemption coupons - Data about customer activities is used to generate coupons for future purchases. Those coupons must be made available to customers, either as paper coupons sent in the mail or online, in the customer's private account area. Once created, the customer activity database needs to be updated to show the creation of the coupon. The loyalty points needed to create the coupon must be deducted from the customer's total points.

Generate customer reports - From time to time, either in the mail or electronically, customers need to be sent account reports that show their recent purchases, the coupons they have been issued that have not yet been redeemed, and the total points they have amassed from their purchases.

Entity

Coupon - 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.

Customer - A customer is someone who buys products and/or services from Petrie's Electronic. Customers include both online customers and those who shop in Petrie's brick and mortar stores.

Product - 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.

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

Services - A job performed by one of Petrie's associates for a customer. For example, upgrading the memory in acomputer by installing new memory cards is a service that Petrie's provides for a fee. Services may only beordered and performed in brick-and-mortar stores, not online.

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

Context Diagram

1. One level-0 DFD
2. One level-1 DFD
3. ERD

Please include the names of group members when submitting the work.

Reference no: EM131284070

Questions Cloud

What role does national culture play : Some would say that countries are becoming more similar due to globalization. Would you agree or disagree? Why? What role does national culture play?

Automated highways and self-driving vehicles : Study progress, safety, and social issues related to an automated system such as automated highways and self-driving vehicles.

Why is it necessary o plan an advertising strategy : Why is it necessary o plan an advertising strategy? What factors should be considered?(Ch 8 Convention Management and service ) What are exchange trade and cooperative advertising? What are the advantages and disadvantages of each? (ch convention man..

Rewrite the assignment of public topic-social security etc : Rewrite the assignment of public topic-Social Security,welfare,Primary and Secondary Public Education etc.Also include a minimum of four from the Ashford University Library.

Create a level-0 dfd and a level-1 dfd : CIS 130 System Analysis - The following data contain the four core functions the system must perform and the description of entities within Petrie's Customer Loyalty System.Create a Level-0 DFD, a Level-1 DFD, and an ERD based on the description w..

Professionals to have better understanding of management : Perlman and Varma (2005) state the following in the discussion of their research: "In sum, it is important for IT professionals to have a better understanding of management. After reviewing the article (the discussion section in particular) and consi..

What role does direct marketing have : What role does direct marketing have in a global company's promotion mix? Name three companies that have successfully used direct mail or other forms of direct-response advertising.

Why is the convention brochure an important sales tool : How would you describe BoltBus's strengths, weaknesses, opportunities, and threats? What is the role of each component of the strategic management process in determining overall enterprise performance? Why is the convention brochure an important sale..

Explain what law was involved : Briefly describe the problem or issue. Explain what law was involved and how you became aware of it. Take care not to give confidential information.

User Account

All Pages