Construct an entity relationship diagram

Assignment Help Other Subject
Reference no: EM131388672 , Length: word count:2500

Systems Analysis and Design

Group Assignment Requirements

In this group assignment (maximum 5 students) you are required to use the systems approach to investigate a business and propose business solution for the Acme Garage-Case Study. You, as a team, are required to produce a short report between 2000 and 2500 words).

The following sections are suggestions for the groups' consideration:

1. Introduction - State the purpose of the report. 

2. Business Overview - Write up a brief overview of the company:

- Structure,

- Key Activities

- Problems,

- Gaps,

- Opportunities,

- Functional Decomposition

3. Analysis

- Current processes,

- Requirement Determination,

- DFD (Context, Level 0 and Level 10

- Logical Modelling (Decision Table Decision Tree .....)

- Data Modelling (ER Diagram)

- Class, Use Case, Activity and Sequence  Diagrams)

4. Requirement Specification

- Functional and Non-Functional

5. Proposed Business Solution

- Forms, Reports, User Interface design

6. Project Feasibility

- Cost, Benefit, Risk Analysis

7. Implementation

- Options

8. Maintenance

- Maintenance Request

- Requests for Implementing Changes

9. Conclusions

- Recommend a key area for detailed analysis. Justify your suggestions.

10. Appendices

- If any

For Group Report, students are required to use Microsoft VISIO tools to design Context & DFD diagrams and Data Modelling Process.

Construct an Entity Relationship Diagram using Microsoft VISIO tools based on the case study described below. The ER model should include the following:

  • A brief description of the notation used in the model
  • A statement of all business rules adopted in the development of the diagram
  • A definition of all the entities
  • An English interpretation of all the relationships
  • The actual Entity Relationship Diagram showing all details (Modality, Cardinality, Primary and foreign Keys ... etc)
  • All many to many relationships must be resolved and should not appear on the diagram as many to many. Any one to one relationships used should be justified)
  • A List (at least 3) of the possible attribute associated with every entity identified.

Construct a Context Diagram, Function Decomposition & Data Flow Diagrams (Level 0 and level 1 only), Use case and activity diagrams based on the case study described below. There should be one level 0 diagram only, and for each function/process defined in the level 0 diagram, one level 1 diagram is required. (Might be pushing it to get a full set of level ones with the amount of information you have given them.  You might consider asking for a couple of level 1 diagrams.)

All diagrams must be computer generated using VISIO tools and balanced in conformance to the rules and standards specified in lectures and tutorials.

Acme Garage-Case Study

The Acme Garage specialises in repairing cars. Before they fix a car they always check to see that the customer has paid for work done previously. Customer details are kept in a Customer file and details of each job are kept in a Job file. Kim works in the office and maintains (Create, Retrieve, Update, Delete) the Customer database. The mechanics (Bill and Ben) write the entries into the Job book. During the process of fixing a car parts may be required. Acme need to keep a stock of frequently used parts (eg spark plugs, oil filters, air filters) these parts are purchased regularly from suppliers and Acme is then invoiced. Less frequently used parts are ordered as required. Once they have a good supplier they tend to stick with them so they only ever have one supplier for each part. Reference to the Stock file will indicate if parts required for a particular job are in stock otherwise the parts will have to be ordered in. In the case where items are removed from stock the balance of stock needs to be reduced. The Stock file takes the form of an Excel spreadsheet and is also maintained by Kim.  In the case where stock is ordered the details of the order are recorded in the Order file (in a filing cabinet), the cost of the parts is added from the invoice that is received when the parts are delivered.  After the job is completed the hours of labour are recorded in the Job file and the Stock file and the Order file will be used to determine the price of the parts used which will also be recorded in the Job file. The contents of the Job record are then used to produce an invoice that goes to the customer. Customers are required to pay in full in 30 days; if payment is not made a letter of demand is sent and a 10% penalty is applied to the account.

Supplies are regularly ordered from suppliers whose details are recorded in a Supplier file (also kept in the Access database). A copy of all orders is stored in the order file and when invoices are received they are checked against the goods received and then are attached to the order. At the end of the month these invoices are paid in full.

Most of the data entry involves simple business transactions (receiving payments, making payments). Periodically new customers, or suppliers are added to the database. Acme has regular dealings with its bank and also sends in Tax Return each year. The information for the Tax Return comes from records of receipts and expenditure. Depreciation of equipment is claimed on the income tax return. The information for this part of the Tax Return comes from an asset register that contains details on all the equipment owned by Acme. Any new equipment purchased from a supplier must be recorded in this register. A variety of information is extracted from the system through inquiries and the generation of periodic reports. This information is used by Gloria, the owner of the garage, to manage the business. An unpaid invoice report and an unfilled orders report are generated at the end of each month.

Reference no: EM131388672

Questions Cloud

What drives our health care costs : Why do we have such costly health care, and is this commensurate with the value received? What drives our health care costs and how can we control or reduce them while maintaining or increasing value?
Discuss the effects of your own enculturation : Explain your answers to the "believing" questions about the three (3) premises opposing your position from the Procon.org website. Examine at least two (2) types of biases that you likely experienced as you evaluated the premises for and against y..
How context affect your ability to conduct critical thinking : How does context affect your ability to conduct critical thinking and the ability of your colleagues to reason with you?
How have you considered the selected organizations culture : mgt600- Outline the preliminary strategic initiative plan. How have you considered the selected organizations culture within the context of implementing your strategic initiative plan?
Construct an entity relationship diagram : HS2011 Systems Analysis and Design. Construct an Entity Relationship Diagram using Microsoft VISIO tools based on the case study described below. The ER model should include the following: A brief description of the notation used in the model
How do organization values drive the culture : mgt600- Provide the vision, mission, and values of the organization. How do organization values drive the culture? What is the culture you intend to build, or exists, today? What is your competitive advantage?
Find the period of the satellite : What is the ratio of the periods? From the facts that the moon has a period of about 27 days and a radius of orbit 240,000 mi and that the radius of the earth is 4000 mi, find the period of the satellite.
What support will the working group need : Explain how the strategies will be adopted, implemented, and maintained in the community. What additional resources may be needed to fully diffuse the intervention? Describe the planned activities in relation to the attributes or characteristics o..
Find the probability of the assembly having a clearance fit : Consider given Figure, which shows the assembly of a shaft in a bearing.- Find the probability of the assembly having a clearance fit.

Reviews

len1388672

2/9/2017 7:12:01 AM

Australian student, 2000-2500 words, rest as per the guidelines. In this group assignment (maximum 5 students) you are required to use the systems approach to investigate a business and propose business solution for the Acme Garage—Case Study. You, as a team, are required to produce a short report. For Group Report, students are required to use Microsoft VISIO tools to design Context & DFD diagrams and Data Modelling Process. Please submit your softcopy online using the respective BlackBoard assignment submission link. In special circumstances, you can submit hard copy of your assignment in the class to your lecturer or submit your hard copy of your assignment.

Write a Review

 

Other Subject Questions & Answers

  Identifying the critical activities in network

The condominium manager identified the following renovation activities and their estimated times.Prepare a project network. Identify the critical activities.

  Consider e-book devices such as the amazonreg kindle what

consider e-book devices such as the amazonreg kindle. what are some successful and unsuccessful characteristics of

  Evaluate the accuracy of the iron triangle model

Draw your own conclusion, and support it with facts and with persuasive reasoning, about the impact of these relationships an defense spending. Evaluate the accuracy of the iron triangle model as a basis for understanding the process of making def..

  Prepare a summary of the individuals situation

After the interview, prepare a summary of the individual's situation. Begin by providing background information, such as the task or goal that is not being achieved, how long the person has been experiencing a lack of motivation.

  Write some psychological and socialcultural factors which

what are some psychological and socialcultural factors that may predispose someone to disordered eating behavior?

  Describe at least three ways a person can teach by example

Describe at least three ways a person can teach by example according to the article and provide a personal example in which you have demonstrated this concept.

  What are some of the ways this socialization occurs

Professional socialization relates to the manner in which we learn the roles and functions of being a nurse once we enter the healthcare system. What are some of the ways this socialization occurs in your place of employment, and do you believe it..

  As an economist you have been asked to address a meeting of

as an economist you have been asked to address a meeting of a group of international professionals to explain the

  Center for mathematics excellence

What are some of the services provided by the Center for Mathematics Excellence? Which service do you think will be the most useful throughout your college experience?

  Explain the socratic proportion

Every kind of thing has a work that it alone can do or that it does better than anything else can. The excellence or virtue of a thing of any kind is that which makes it perform its work well. The work of the soul is living.

  Crime prevention through environmental design

Crime Prevention through Environmental Design (CPTED) is a program developed by Homeland Security. This program was created to control communities.

  Briefly describe how each issue impacts the classroom

List five key educational issues related to the First Amendment from your reading. Briefly describe how each issue impacts the classroom.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd