City University of New York
Working with data and databases
You maintain many different customer lists from your Music customers to Art Gallery and Book Club customers. You want to begin mailing a monthly newsletter to your customers discussing everything from current coffee growing trends to community events. To date, your customer lists have been maintained primarily for e-mail addresses and you are unsure if customer addresses are even correct. You do not want to use e-mail to distribute your newsletter as you want to place a coupon marketing a free cup of the coffee in each newsletter. If you e-mail the newsletter you could not control the free cup coupon.
PROJECT FOCUS:
• Analyze the data below and determine if you will be able to use it to mail your newsletters.
• Be sure to highlight all of the issues with the data, potential causes of the issues, and solutions you can follow to correct the issues.
ID |First Name |Middle Initial |Last Name |Street |City |State |Zip Code | |434 |Pam |J |Hetz |13 First Ave |Denver |CO |8765423 | |434 |Brain |F |Hoover |Lake Ave. |Columbus |CO |8702 | |435 |Bob |X |Kenzie |65 Apple Lane |Golden |CO |65667 | |436 |Alana |B | |567 55 St. |Denver |Co |90210 | |437 |Alana |B |Smith |567 55 St. |Denver |Co |90210 | |438 |Debbie |F |Fernandez |567 55 St. |Denver |Co |90210 | |439 |Diego |J |Quintos |2121 One St. |Golden |CO |65667 | |You now want to track the usage of the coupon when a customer redeems it. What type of attributes would this new Coupon table require and how would you link it to the above Customer table. Remember that the primary key for the Coupon table must be unique. A customer may use different coupons from different newsletters and you want to track all the coupons used.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- city of new york benefits
- city of new york employee benefits program
- city of new york health benefits program
- university of new york ranking
- city of new york payroll
- city of new york retiree health benefits
- city of new york employment verification
- city of new york health insurance
- state of new york department of insurance
- state of new york division of corporations
- city of new york jobs portal
- city of new york employee discounts