Business
Business, 06.10.2019 05:30, Timsters333

Quicklube is in the quick oil and lube business. although customers bring in their cars for service described as quick oil changes, quicklube also replaces windshield wipers, oil filters, and air filters, subject to customer approval. the customer invoice lists the charges for the oil used, all parts used, and a standard labor charge. when quicklube presents the invoice, customers pay cash, use a credit card, or write a check. quicklube does not extend credit. quicklube needs a database designed to keep track of all components in all transactions. given the high parts usage of the business operations, quicklube must maintain careful control of its parts (oil, wipers, oil filters, air filters) inventory. therefore, if parts reach their minimum on hand quantity, they must reorder the part in question from an appropriate vendor. quicklube maintains a vendor list that contains both the vendors, actually used as well as potential vendors. quicklube also tracks each customer’s car mileage. periodically, quicklube mails updates/reminders to customers, based on the date of the car’s service and the mileage. based on the information provided: 1) draw the erd (entity relationship diagram) for quicklube: draw the erd using crow's feet notation. use ms visio and save your final drawing as a pdf. 2) on a separate page(s): clearly list all the entities with a list of the attributes below each entity. 3) make sure you clearly mark/label the primary/identifier key attribute(s) (pk) for each entity. 4) also, make sure you clearly mark/label any foreign key attributes (fk) for each entity. 5) provide a list of any business assumptions that you made while developing your erd.

answer
Answers: 3

Other questions on the subject: Business

image
Business, 22.06.2019 03:00, aparr2007
Working with a word processor requires more than just a knowledge of typing. a good word processor includes a number of tools designed to aid in formatting documents to meet the needs of the reader. in this project you will use your word-processing skills and a basic knowledge of apa style to format a research paper. the skills you will need for this project include the following: adjusting line spacing (double-spacing) breaking text into pages (page break) centering text changing the font, style, and size of the text editing text inserting page numbers inserting a table using spell check
Answers: 1
image
Business, 22.06.2019 06:40, haleyturkey
Depreciation on the company's equipment for 2017 is computed to be $18,000.the prepaid insurance account had a $6,000 debit balance at december 31, 2017, before adjusting for the costs of any expired coverage. an analysis of the company's insurance policies showed that $1,100 of unexpired insurance coverage remains. the office supplies account had a $700 debit balance on december 31, 2016; and $3,480 of office supplies were purchased during the year. the december 31, 2017, physical count showed $300 of supplies available. two-thirds of the work related to $15,000 of cash received in advance was performed this period. the prepaid insurance account had a $6,800 debit balance at december 31, 2017, before adjusting for the costs of any expired coverage. an analysis of insurance policies showed that $5,800 of coverage had expired. wage expenses of $3,200 have been incurred but are not paid as of december 31, 2017.
Answers: 3
image
Business, 22.06.2019 10:10, cuthbertson157
conquest, inc. produces a special kind of light-weight, recreational vehicle that has a unique design. it allows the company to follow a cost-plus pricing strategy. it has $9,000,000 of average assets, and the desired profit is a 10% return on assets. assume all products produced are sold. additional data are as follows: sales volume 1000 units per year; variable costs $1000 per unit; fixed costs $4,000,000 per year; using the cost-plus pricing approach, what should be the sales price per unit?
Answers: 2
image
Business, 22.06.2019 11:10, takaralocklear
An insurance company estimates the probability of an earthquake in the next year to be 0.0015. the average damage done to a house by an earthquake it estimates to be $90,000. if the company offers earthquake insurance for $150, what is company`s expected value of the policy? hint: think, is it profitable for the insurance company or not? will they gain (positive expected value) or lose (negative expected value)? if the expected value is negative, remember to show "-" sign. no "+" sign needed for the positive expected value
Answers: 2
Do you know the correct answer?
Quicklube is in the quick oil and lube business. although customers bring in their cars for service...

Questions in other subjects:

Konu
Mathematics, 26.10.2020 18:20
Konu
Mathematics, 26.10.2020 18:20
Konu
Social Studies, 26.10.2020 18:20
Konu
Social Studies, 26.10.2020 18:20
Konu
English, 26.10.2020 18:20