Construct an entity relationship diagram

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

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: EM131628656

Questions Cloud

What is the average power density radiated by the dipole : A 1 m long dipole is excited by a 1 MHz current with an amplitude of 12 A. What is the average power density radiated by the dipole at a distance of 5 km.
How do you see health care social media in the digital era : Share your thoughts on healthcare and what role social media can or cannot play? How do you see Health Care Social Media in the Digital Era?
What is the total cost arising from optimal order quantity : The Krewe of Orpheus maintains a supply of swizzle sticks for events throughout the year. What is the total cost arising from the optimal order quantity?
Obtain an estimate for the antenna directivity in db : The radiation pattern of a circular parabolic-reflector antenna consists of a circular major lobe with a half-power beamwidth of 3? and a few minor lobes.
Construct an entity relationship diagram : HS2011 - Systems Analysis and Design - Construct an Entity Relationship Diagram using Microsoft VISIO tools based on the case study
What are the major limitations of the balance sheet : What are the major limitations of the balance sheet as a source of information, and how can your role as an accountant ensure that the information presented
Use attribution theory : Explain how you would use attribution theory in the following situations: You are the manager in a retail store.
Calculate the standing wave ratio on a transmission line : Assuming the loss resistance of a half-wave dipole antenna to be negligibly small and ignoring the reactance component of its antenna impedance.
Did you use third person pronouns : Apply critical thinking skills to the analysis of issues involving mass media and society.

Reviews

len1628656

9/6/2017 1:13:37 AM

Sample marking criteria: Marking criteria Weighting Introduction (purpose of the report) 5% Business Overview (Structure, Key activities, Problems, Gaps, Opportunities, functional decomposition) 10% 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) 30% requirement specification (Functional, Non- Functional) Business proposed solution (forms, reports, user interface design) 20% Project feasibility (cost, benefit, risk analysis) 15% Implementation Issues 10% Maintenance issues (maintenance request, requests for implementing changes) 5% Conclusion (Recommend a key area for detailed analysis. Justify your suggestions) 5% TOTAL Marks 100% General Comments:

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

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