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.

Imagine us is a startup that offers high definition 3d prenatal ultrasounds for high-end customers. the service process includes four activities that are conducted in the sequence described below. (the time required for each activity is shown in parentheses): activity 1: welcome a patient and explain the procedure. (20 minutes)activity 2: prep the patient (e.g., show them to the room, apply ultrasound gel). (17 minutes) (*your id number represents the amount of time needed to complete this task)activity 3: take images. (5 minutes)activity 4: discuss diagnostic with patient. (20 minutes)at each location there are employees (servers) s1, s2, and s3. the assignment of tasks to servers is the following: s1 does activities 1 and 2.s2 does activity 3.s3 does activity 4.a. what is the capacity of this process (in customers per hour)? b. suppose 3 patients arrive every hour on average. ignoring any “start of day” or “end of day” effects, what are the utilizations of all three servers (%)? c. suppose each activity can be done by any server and any server can do any set of activities. however, each activity is done by only one server. for example, a possible assignment includes: s1 does activity 1, s2 does activity 2, and s3 does activities 3 and 4. of course, the original assignment of servers to activities is also feasible. what is the maximum capacity of the process (in customers per hour)? d. now consider the capacity measures in (c) and (a), what is the percentage change? why can you improve capacity without using additional resources? (there is no free lunch, right? )note: for all hw assignments, show your process of getting the results. only providing the final answers is not acceptable and will get 0%. if necessary, use a separate sheet of paper to show your work.