Top-Rated Free Essay
Preview

Moduel 8 Assignment

Satisfactory Essays
835 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Moduel 8 Assignment
Module 8 - Assignments:

Your assignment is from the text.
• Chapter 9, problems 1 and 2
Your assignment must be submitted to the Dropbox no later than Sunday 11:59 PM EST/EDT.

Problem #
1. The ABC Car Service & Repair Centers are owned by the SILENT car dealer; ABC services and repairs only SILENT cars. Three ABC Car Service & Repair Centers provide service and repair for the entire state.

Each of the three centers is independently managed and operated by a shop manager, a receptionist, and at least eight mechanics. Each center maintains a fully stocked parts inventory.
Each center also maintains a manual file system in which each car’s 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, do the following:

a. Indicate 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.”)

7____ Normalize the conceptual model.
_3___ Obtain a general description of company operations.
9____ Load the database.
4____ Create a description of each system process.
11____ Test the system.
5____ Draw a data flow diagram and system flowcharts.
6____ Create a conceptual model, using ER diagrams.
10____ Create the application programs.
_1___ Interview the mechanics.
_8___ Create the file (table) structures.
2__ Interview the shop manager.

b. Describe the various modules that you believe the system should include.
Payroll, Inventory, Customers Invoicing, Job tracking including hours,parts

c. How will a data dictionary help you develop the system? Give examples.
The data dictionary helps create documents. It looks for like words and checks for spelling sometimes. It will give better consistency. It also helps with reports.

d. What general (system) recommendations might you make to the shop manager? (For example. if the system will be integrated, what modules will be integrated? What benefits would be derived from such an integrated system? Include several general recommendations.)
I would recommend that the centers be integrated especially the contacts or customers. So that if a repair center brings up a customer’s car they can see what repairs have already been done to the car and at what price.
It would also be wise to have the manuals to cars online so that the repair men can look up how many hours and the price it takes.
It would also be good if they do not have the part they need if they can check with another store for quick access in case it is a part that you can’t get easy at a parts house.

e. What is the best approach to conceptual database design? Why?
A top-down approach with flexibility for future integration.

f. Name and describe at least four reports the system should have. Explain their use. Who will use those reports?

Monthly Payroll Report – This will be the monthly and year to date payroll.

Monthly Inventory Report – This would be all purchases and all parts put into cars. The report would show a break down of In and out. On the Out report It should show customer and car.

Monthly Cstomer Report – By date will have customers name and car and price.

Job Order Report = List of all mechanical jobs and who completed the job, who diagnosed and who trained or assisted. How many hours for data history. What parts were used. This report can also be printed so you can see what parts each tech likes to use.
2. Suppose you have been asked to create an information system for a manufacturing plant that produces nuts and bolts of many shapes, sizes, and functions. What questions would you ask, and how would the answers to those questions affect the database design?

What do you need to keep track of and what reports will you need?
What do you need to do on this system first?
Do you want to keep track of all your vendors information?Including things you are not currently selling?
Do you have cetain specifications for your sorting orders? Acending? Lot numbers? SKU? UPC codes?
What employees do we need to consider?

a. What do you envision the SDLC to be?
PLANNING
Initial assessment
Feasibility study
ANALYSIS
User requirements
Existing systems evaluation
Logical system design
DETAILED SYSTEMS DESIGN
Detailed system specifications
IMPLEMENTATION
Coding, testing, debugging
Installation, fine-tuning
MAINTENANCE
Evaluation
Maintenance
Enhancements

b. What do you envision the DBLC to be?
DATABASE INITIAL STUDY
Analyze the company situation
Define problems and constraints
Define objectives
Define scope and boundaries
DATABASE DESIGN
Create the conceptual design
DBMS software selection
Create the logical design
Create the physical design
IMPLEMENTATION AND LOADING
Install the DBMS
Create the database(s)
Load or convert the data
TESTING AND EVALUATION
Test the database
Fine-tune the database
Evaluate the database and its application programs
OPERATION
Produce the required information flow
MAINTENANCE AND EVOLUTION
Introduce changes
Make enhancements

You May Also Find These Documents Helpful

  • Good Essays

    Service Request SR-ht-03

    • 569 Words
    • 2 Pages

    First our team decided on what to incorporate into our database to complete everything needed for Huffman Trucking’s truck maintenance needs. When a part is purchased a record is inserted into Parts Inventory Purchases and Parts Purchasing History adding to the quantity in Parts Catalogue. When a part is issued a record is inserted into Parts Inventory Issues and a quantity is decreased in Parts Catalogue. When a vehicle has maintenance a record is inserted into Maintenance Work Order and Vehicle Maintenance and a quantity is deducted from Parts Catalogue. When there is tire maintenance a record is inserted into Maintenance Work Order and Tire Maintenance is updated.…

    • 569 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    Submit your assignment to the Dropbox located on the silver tab at the top of this page. For instructions on how to use the Dropbox , rea...…

    • 685 Words
    • 6 Pages
    Satisfactory Essays
  • Good Essays

    You must show your work on all problems. You may type your answer right into this document. Total points for project: 45 points. Projects must be submitted as a Microsoft Word document and uploaded to the Dropbox for Unit 1. All Projects are due by Tuesday at 11:59 PM ET of the assigned Unit. NOTE: Project problems should not be posted to the Discussion threads. Questions on the project problems should be addressed to the instructor by sending an email or by attending office hours. You will be able to come back to the Dropbox and view your graded work or in the Gradebook after your instructor evaluates it.…

    • 1753 Words
    • 8 Pages
    Good Essays
  • Satisfactory Essays

    You must also enquire if it handles the commercial, the residential or both types of air conditioner units. There are some service centers that only do certain types of maintenance and repair work jobs. It is important that you understand the limitations of the service center before you book an appointment for your air conditioning unit.…

    • 505 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    This is a team assignment, so make sure every participant’s name is on the assignment. Please have one member post in the “Assignments” link.…

    • 455 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    * What are some important questions that need to be asked when determining the exact requirements for a system?…

    • 598 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Midas shops provide total car care includes tires, brakes, batteries, oil changes, air conditioning, and an array of vehicle maintenance services by ASE-certified technicians (Midas International Corporation, 2014). Midas is a well-known company that customers use to take care of his or her automotive needs. The objective of this paper is to answer four question pertaining to the Midas case study in Chapter 2 of the textbook. These questions will discuss anticipated impacts on operating efficiencies, recommend solutions to minimize the negative impacts, operating practices to accommodate tune-ups, reasons why input should be gathered from the shop owners, the type of input that should be gathered, and the processes and steps needed to launch this new program.…

    • 1117 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    With the technology leads the company in the automotive aftermarket industry in today’s world. Having a well-organized business model for logistics and distribution, this has increase the company continuously growth for more than three decades. In1989, AutoZone began using a (SMS) Store Management System put into place to keep the stores stocked with parts that meets…

    • 253 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Complete your Assignment # 3. It is due this Sunday, September 18th before 11:59 pm. Your instructor has not posted any new grade during this week.…

    • 62 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    FOCUS 2 Instructions

    • 273 Words
    • 1 Page

    11 Submit this .pdf file in Blackboard by 11:59 p.m. (ET) on Monday of Module/Week 7.…

    • 273 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    It510 Final Project

    • 1574 Words
    • 7 Pages

    There are several techniques used in the documentation process. As a system analyst I would propose to the members of this group a straightforward standardized approach. A reasonable suggestion for this project would be to use the Procedure Manual technique for documenting this system. The Procedure Manuals will provide instructions on how to operate and understand how the system works. These manuals are also used as a guide that can be updated at different intervals for future users. Procedure Manuals are also made available to users via the Web. This new approach has made it convenient for users to seek support in a much faster way by offering a FAQ page, and online chat (Kendall & Kendall, 2011). In addition it is also a great tool for future analyst.…

    • 1574 Words
    • 7 Pages
    Good Essays
  • Satisfactory Essays

    Take a Stand

    • 1097 Words
    • 4 Pages

    Directions: You will be starting this assignment in week 1 (Topic 1) and will continue to build and complete this assignment each week until you submit the final product in week 7 (Topic 7).…

    • 1097 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    7. Please submit an electronic copy of your assignment on dropbox by November 28th 2014. Late papers will be penalized 10% per day.…

    • 774 Words
    • 4 Pages
    Satisfactory Essays
  • Powerful Essays

    Itm 3060 Ch 10

    • 1062 Words
    • 5 Pages

    5. (C) Deciding what hardware and software will be used to operate the system and defining the processing modules that will comprise the system are part of which SDLC step? a. System building b. Requirements definition c. System design d. Feasibility analysis…

    • 1062 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    This is to be uploaded in the assignments section (along with your Certificate of Originality) by Friday, Day 5.…

    • 485 Words
    • 2 Pages
    Satisfactory Essays