The ABC Company has three ABC Car Service & Repair Centers that provide vehicle service and repair for the entire state. Each center is independently managed and operated by a shop manager, a receptionist, and at least eight mechanics. Each center also maintains a fully stocked parts inventory and maintains a manual file system in which each cars maintenance history is kept: repairs made, parts used, costs, service dates, owner, and so on. Files are also kept to track inventory, purchasing, billing, employees hours, and payroll.You have been contacted by the manager of one of the centers to design and implement a computerized system. Given the preceding information, complete the following three exercises. Place the answers to each exercise in a single Word or PDF document and submit it through Blackboard. Be sure to put your name, section, and date at the top of the document before submitting it.Exercise AIndicate the most appropriate sequence of activities by labeling each of the following steps in the correct order. (For example, if you think that Load the database. is the appropriate first step, label it 1.)____ Normalize the conceptual model.____ Obtain a general description of company operations.____ Load the database.____ Create a description of each system process.____ Test the system.____ Draw a data flow diagram and system flowcharts.____ Create a conceptual model, using ER diagrams.____ Create the application programs.____ Interview the mechanics.____ Create the file (table) structures.____ Interview the shop manager.Exercise BA good designer uses a specific and ordered set of steps through which the database design problem is approached. The steps are generally based on three phases: analysis, design, and implementation. Write down the three phases and, underneath each phase, list the activities that belong in that phase. Use the order of activities you chose in the previous exercise.Exercise CThe Information System development team decides to build a system composed of four main modules: Inventory, Payroll, Work Order, and Customer as shown in the figure below.See attached image.The Inventory module will include the Parts and Purchasing sub-modules. The Payroll Module will handle all employee and payroll information. The Work order module keeps track of the car maintenance history and all work orders for maintenance done on a car. The Customer module keeps track of the billing of the work orders to the customers and of the payments received from those customers. For each module, develop an ERD that consists of entities appropriate for that module and the relationships between them. Show all entities, attributes with PK and FK fields indicated, and relationships between entities using the Crow’s Foot notation.Exercise DAnalyze each module’s relationships with other modules. Couple the modules together into a single ERD.
The ABC Company has three ABC Car Service Repair Centers that provide vehicle service and repair for the entire state.
Give us your instructions.
Select the type of service you need: writing, calculations, or programming. We’ve created an intuitive order form that tells you what information to enter and where, so make sure to fill out each required field. Also, make your requirements as specific as possible. Don’t rush! Take your time and explain everything in detail how it works.
Proceed to checkout and enter your credit card details or PayPal login, how to pay. Follow the payment provider’s instructions to confirm the transaction.
Now your order is in our system! We’ll start processing it right away.
Place Your Order
Frequently asked questions
Is your service confidential?
When you place an order with our company, we ask you to provide us with such personal information as your name, phone number, and email address. We need this data to keep you updated on the important things related to your order or account.
Is there a possibility of plagiarism in my completed order?
We complete each paper from scratch and in order to make you feel safe regarding its authenticity, we check it for plagiarism before its delivery. To do that, we use our in-house software, which can find not only copy-pasted fragments but even paraphrased pieces of text. Unlike popular plagiarism detection systems that are used by most universities (e.g. Turnitin.com), we do not report to any public databases—therefore, such checking is safe.
We provide a plagiarism-free guarantee that ensures your paper is always checked for its uniqueness.
Is there a money-back guarantee? If yes, how can I receive a refund?
You can certainly get your money back in several cases. You can receive a full refund if you have paid for your order twice or if you have placed two identical orders. In case your paper was late or the quality of the paper does not correspond to your expectations, you will get compensation for these issues.
Do you keep a database of pre-written essays?
No, we do not have such a database. All papers you order from us are written from scratch. This means your paper is unique and has never been published before—neither will it be published after we deliver it to you.
When will my custom paper be done?
While placing an order with WritersHub, you can choose a period of time within which a paper should be delivered to you. The countdown until the specified deadline starts automatically from the moment we receive your payment in our system. For example, if you pay for your order at 6pm on Monday and choose a 3-day delivery option, you will receive your custom paper by 6pm on Thursday.
Remember that a writer needs a sufficient amount of time in order to conduct thorough research. Therefore, please choose the most suitable deadline when you place an order. Moreover, the later you need your paper to be delivered to you, the cheaper it will be. Thus, you will be able to save your money while your writer will have enough time to work on your order and ensure its quality.
Make sure you upload all the additional materials at the very beginning. If you fail to do that, the deadline for your order will be postponed as well.
I haven’t received my custom paper by the deadline. What should I do?
Let us know immediately about that. You can do it by writing a message on Facebook or email us. Our support manager will carefully examine your order and will assist you with it right away. The reasons for late delivery may vary from time to time. It can happen that you have entered a wrong email address or your spam filter does not allow you to receive emails from us. It is also possible that the writer is waiting for your reply and can not continue working without your assistance, or we are checking the work for plagiarism. Whatever the case may be, contact us if you have any problems with getting your order on time.