The purpose of this assignment is to help the students to understand the basic rules in database design and practice students’ software skill.
Instructions: Dirt Bikes U.S.A. sells primarily through its distributors. It maintains a small customer database with the following data: customer name, address (street, city, state, zip code), telephone number, model purchased, date of purchase, and distributor. You can find the database in Appendix. These data are collected by its distributors when they make a sale and are then forwarded to Dirt Bikes. Dirt Bikes would like to be able to market more aggressively to its customers.
The Marketing Department would like to be able to send customers e-mail notices of special racing events and of sales on parts. It would also like to learn more about customers’ interests and tastes: their ages, years of schooling, another sport in which they are interested, and whether they attend dirt bike racing events. Additionally, Dirt Bikes would like to know whether customers own more than one motorcycle. (Some Dirt Bikes customers own two or three motorcycles purchased from Dirt Bikes U.S.A. or other manufacturer.) If a motorcycle was purchased from Dirt Bikes, the company would like to know the date of purchase, model purchased, and distributor. If the customer owns a non–Dirt Bikes motorcycle, the company would like to know the manufacturer and model of the other motorcycle (or motorcycles) and the distributor from whom the customer purchased that motorcycle.
• Redesign Dirt Bikes’s customer database is needed so that it can store and provide the information needed for marketing (make sure the resigned databased follow the rule of normalization). You are asked to develop a design for the new customer database and then implement that design using database software Access. Consider using multiple tables in your new design. Populate each new table with 10 records.
• Please create a pdf document integrating Access file (with all tables, queries and the design of the document as screenshots)
Solved
Show answers
More tips
- C Computers and Internet Step-by-Step Guide on How to Download Music to Your iPhone...
- A Animals and plants Unraveling the Mystery of Loch Ness: What Does the Loch Ness Monster Look Like?...
- L Leisure and Entertainment Should You Buy a Ceramic Knife?...
- C Computers and Internet How to easily and quickly disable Firebug in Gmail and Google Docs...
- G Goods and services How to sew a ribbon: Tips for beginners...
- F Food and Cooking How to Make Mayonnaise at Home? Secrets of Homemade Mayonnaise...
- C Computers and Internet Which Phone is Best for Internet Surfing?...
- F Food and Cooking Everything You Need to Know About Pasta...
- C Computers and Internet How to Choose a Monitor?...
- H Horoscopes, Magic, Divination Where Did Tarot Cards Come From?...
Answers on questions: Business
- M Mathematics Como escribir Ami hijo ala escuela...
- M Mathematics Pls help In quadrilateral RSTU, RT and SU intersect at point Mso that RM and RS is parallel to TU. Which additional information is needed to prove that quadrilateral...
- M Mathematics To calculate profit, producers subtract their total production cost from their...
Ответ:
Stop.
Explanation:
Advertising is against Community Guidelines.