Using Microsoft Access, how can Jenny identify the redundant attributes in her table and design an efficient
Fantastic news! We've Found the answer you've been seeking!
Question:
Using Microsoft Access, how can Jenny identify the redundant attributes in her table and design an efficient database management system?
Transcribed Image Text:
Selling Mary Kay brand cosmetics and beauty aids was Jenny Jones's passion in life. Working with Mary Kay for over 10 years, Jenny had earned herself many accolades. She served one of the largest and most lucrative suburban areas of all Mary Kay sales technicians, the Newtown, Pennsylvania through Princeton, New Jersey area. Jenny was nationally known throughout the most astute Mary Kay circles as being one of the company's top sellers. However, there was one "brass ring" that Jenny had yet to attain...the coveted BIG PINK CAR. In case you are not familiar with this prestigious award, the BIG PINK CAR is only awarded to the Mary Kay sales technician with the highest sales over a fiscal period. It is awarded at a national convention where all the Mary Kay bigwigs hang out. To Jenny, this was her year to go for the gold, or the pink if you will. Jenny had no problem upping her sales to all time high levels and she was well aware of the competition. Knowing that the only way she could lose would be to beat herself, Jenny set out to determine how she needed to clean up her own act to bring home the pink car. After performing a detailed evaluation of all of her strengths and weaknesses, Jenny discovered that, in order to win the award, she would have to become more organized. Presently, Jenny maintained all of her sales records on manually generated carbon sheets. However, Jenny knew that in order to keep up with Mary Kay's high standards and adequately support her claim to the best ride in town, she would have to improve her record-keeping. Jenny decided to use Microsoft Access to maintain her sales records. Each time Jenny made a sale, specific information such as customer name, customer number, address, level of skin sensitivity, order number, product number ordered, product name, unit price, quantity ordered, catalog number ordered from and catalog edition was stored in an Access table. Jenny soon realized that her table included many redundancies. Help Jenny identify the redundant attributes in her table and design an efficient database management system. Selling Mary Kay brand cosmetics and beauty aids was Jenny Jones's passion in life. Working with Mary Kay for over 10 years, Jenny had earned herself many accolades. She served one of the largest and most lucrative suburban areas of all Mary Kay sales technicians, the Newtown, Pennsylvania through Princeton, New Jersey area. Jenny was nationally known throughout the most astute Mary Kay circles as being one of the company's top sellers. However, there was one "brass ring" that Jenny had yet to attain...the coveted BIG PINK CAR. In case you are not familiar with this prestigious award, the BIG PINK CAR is only awarded to the Mary Kay sales technician with the highest sales over a fiscal period. It is awarded at a national convention where all the Mary Kay bigwigs hang out. To Jenny, this was her year to go for the gold, or the pink if you will. Jenny had no problem upping her sales to all time high levels and she was well aware of the competition. Knowing that the only way she could lose would be to beat herself, Jenny set out to determine how she needed to clean up her own act to bring home the pink car. After performing a detailed evaluation of all of her strengths and weaknesses, Jenny discovered that, in order to win the award, she would have to become more organized. Presently, Jenny maintained all of her sales records on manually generated carbon sheets. However, Jenny knew that in order to keep up with Mary Kay's high standards and adequately support her claim to the best ride in town, she would have to improve her record-keeping. Jenny decided to use Microsoft Access to maintain her sales records. Each time Jenny made a sale, specific information such as customer name, customer number, address, level of skin sensitivity, order number, product number ordered, product name, unit price, quantity ordered, catalog number ordered from and catalog edition was stored in an Access table. Jenny soon realized that her table included many redundancies. Help Jenny identify the redundant attributes in her table and design an efficient database management system.
Expert Answer:
Answer rating: 100% (QA)
To identify the redundant attributes in Jennys table and design an efficient database management sys... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these programming questions
-
The Electronic Controls Company (ECCO) is one of the largest makers of backup alarms in the world. Backup alarms are the safety devices that emit a high-pitched beeping sound when a truck, forklift,...
-
One of the largest wind generators in operation today is the ERDA/NASA two blade propellers HAWT in Sandusky, Ohio. The blades are 125 ft in diameter and reach maximum power in 19 mi/h winds. For...
-
One of the largest losses in history from unauthorized securities trading involved a securities trader for the French bank, Societe Generale. The trader was able to circumvent internal controls and...
-
1. Give the format of HTTP request message. 2. Give the format of HTTP response message.
-
Inadequacy of mean hydraulic radius for laminar flow (a) For laminar flow in an annulus with radii kR and Rr use Eqs. 6.2-17 and 18 to get an expression for the average velocity in terms of the...
-
Find the upper 1st percentile of a t distribution with 16 df? Pulmonary Disease The data in Table 6.10 concern the mean triceps skin-fold thickness in a group of normal men and a group of men with...
-
Refer to the preceding problem, P7-12. Using FIFO, answer the same questions.
-
McMillan Home Maintenance Company (MHMC) earned operating income of $7,200,000 on operating assets of $60,000,000 during 2011. The Tree Cutting Division earned $1,215,000 on operating assets of...
-
Ex: Write the equation for the horizo 6x3+3x+2 f(x) = 2x3+5x+8 6x5+2x+1 f(x) = 5x3+3x-8
-
Both Novador and Sashimia are members of the WTO. Sashimia is also one of 12 fishing nations that are members of the Southern Atlantic Tuna Fishing Organization (SATFO). SATFO was established in 1998...
-
Han Products manufactures 30,000 units of part S-6 each year for use on its production line. At this level of activity, the cost per unit for part S-6 is: Direct materials Direct labor Variable...
-
Based off the WSJ section of Personal Finance by Anne Tergesen and Jeremy Olshan "The right amount of cash to keep at home for emergencies. Hint: not $480,000.", explicitly identified observations of...
-
How do historical legacies and organizational folklore shape present-day cultural norms and values, and what strategies can be employed to transcend or adapt these inherited constructs ?
-
A projectile is launched with an initial speed of 75 m/s at an angle of 20 above the horizontal. The projectile lands on a hillside 6.0 s later. Neglect air friction. (a) What is the projectile's...
-
Time Traveler Magazine completed the following transactions during 2016: Oct 31: Sold one-year subscriptions, collecting cash of $1,750, plus HST of 13%. Dec 31: Remitted (paid) HST to Canada Revenue...
-
Blanchet, Incorporated needs to budget for cash in its upcoming quarter. Below is historical information about cash collections and payments. B Sales collected in Cash 5 Sales collected on Credit 20%...
-
Journalize the entries to record the following selected bondinvestment transactions for Whirlpool Products:a. Purchased for cash $250,000 of Snowy Adventures Inc. 5% bondsat 100 plus accrued intere 2...
-
Three forces with magnitudes of 70pounds, 40 pounds, and 60 pounds act on an object at angles of 30, 45, and 135, respectively, with the positive x-axis. Find the direction and magnitude of the...
-
Assume that Circuit City owes Synovus Bank $1,000,000 on a 4-year, 7% note originally issued at par. After one year of making scheduled payments, Circuit City faces financial difficulty. At the end...
-
All leases for financial reporting purposes are treated as either capital (finance) leases or operating leases. The effects of the two reporting techniques on the financial statements differ...
-
Aer Lingus is an international airline based in Ireland. Exhibit 3.24 provides the statement of cash flows for Year 1 and Year 2, which includes a footnote from the financial statements. Year 2 was...
-
Construct a combined common-size and common-base year balance sheet for 2007. What will be the common-base year value for the 2007 net fixed assets? a. 0.89 b. 0.92 c. 1.12 d. 1.32 AHS INC. 2007...
-
What will be the value of AHS' equity multiplier during 2007? a. 0.44 b. 0.56 c. 1.78 d. 1.82 AHS INC. 2007 Income Statement (S in millions) Net sales S 9625 Cost of goods sold 5225 Depreciation 1890...
-
What will be the value of AHS' current ratio during 2007? a. 1.14 b. 1.42 c. 1.49 d. 1.53 AHS INC. 2007 Income Statement (S in millions) Net sales S 9625 Cost of goods sold 5225 Depreciation 1890...
Study smarter with the SolutionInn App