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.
-
Describe the goal of a portfolio owner in terms of risk and return. How does he or she evaluate the risk characteristics of stocks being considered for addition to the portfolio?
-
Given the functions and g below, find f(g(-3)). Do not include "f(g(-3)) =" in your answer. f(x)=-2-6x+3 g(x) --3
-
Calculate the interquartile range for each of the following sets of data: a. \(3,6,7,12,15,17,23,28\) b. \(8,4,1,6,13,10,12,5\) c. \(3,8,14,11,16,7,14,15,11,9,12,6\) d....
-
Effect of order quantity on special order decision Lang Company made 100,000 electric drills in batches of 1,000 units each during the prior accounting period. Normally, Lang markets its products...
-
Select a metallic ship or boat component that is manufactured starting from a billet using at least two combinations of forging, rolling, extrusion or wire drawing (ex. Hot extrusion then forging). ...
-
Assume that you are the auditor of ABC Inc, for the fiscal year 2006. No audit procedures have been performed other than general information gathering. Please read all the information given below...
-
You own a small manufacturing business that produces widgets. You have spent $150,000 acquiring the fixed assets you need to produce widgets. Each widget costs you $2 to make and they sell for $15...
-
The effectiveness of solar-energy heating units depends on the amount of radiation available from the sun. During a typical October, daily total solar radiation in Tampa, Florida, approximately...
-
2 Henri has received a job offer from Potis Ltd under the following terms: Annual salary: 90,000 Car: a choice of a company car or a mileage allowance for the use of his own car for business...
-
Johnson's cash book showed a debit balance of Sh. 117,010 on 31 March 20X7. His bank statement showed a credit balance of Sh. 38,257 on the same date. A careful examination of the two records...
-
Compare the accounting income with economic income and what difference both can have in appraising the production project with reference to the attached case Sorenzyme is a rapidly growing biotech...
-
The following table provides an historical summary of key financial ratios for Hallenstein Glassons Limited (HGL). HGL is a company listed on New Zealand Stock Exchange. It is a retailer of men's and...
-
Given the compressed balance sheet data (in $ millions) for KRJ Enterprises presented below, calculate the debt to tangible net worth ratio, using total liabilities in the numerator. Present your...
-
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...
-
Describe how partial and circular reasoning can be helpful or harmful in resolving ethical dilemmas.
-
Describe the various legal risks for nurses.
-
Describe the various roles of advanced practice nurses.
Study smarter with the SolutionInn App