Describe the current business rules for HTH

Assignment Help Business Management

Reference no: EM131768043

Task

Overview of business case:

Handy-Trady Hire (HTH) is a home repair company that employs a number of contractors who specialise in different areas. Contractors have a specialisation in any of the following areas:

Electrical
Cabinet making
Landscaping, plumbing
Driveway sealing
Roof cleaning
Interior & Exterior painting

HTH started as a small family business and for the past five years has been tracking and managing their business activities using an Excel spreadsheet. With view to their expanding business and under the new management, they decided to investigate the option of implementing a database system. Accordingly they hired you to design a relational database to better track and record their operational data.

Your task

Create an ERD for each of the following statements that describe the current business rules for HTH. For each new statement being the business rule, extend the ERD to include the additional business rule in the ERD (created in previous point for example; B will include A&B, C will include A, B & C, etc.)

Use Crows Foot notations and include all of the following in each part:
- All entities with Primary key and any foreign key attributes;
- The relationships between entities;
- The cardinality and optionality of each relationship;
- Any M:N relationships are be resolved to 1:M relationships
HTH discovered business rules/constraints for your ERD:

1. A customer calls HTH to request a home repair job: Details about the customer and the requested job need to be recorded.

2. Each tradesperson specialises in only one trade, and details of their trade and the date acquired need to be kept on record.

3. HTH has a number of trucks (including equipment) and allocates a truck for each tradesperson when hired by HTH. Some tradespersons have their own truck and equipment and advise HTH about this, so in this case they are not assigned a truck.

4. Each team of tradespersons has one supervisor, and a supervisor is to supervise up to 7 tradespersons on the same team.

5. A requested job may require different specialisation depending on the job type - that is a job may require more than one tradesperson to complete.

6. A customer makes a payment for each job by several methods: (by cheque, cash or bank transfer). HTH need to keep a record of payments made by each customer and the method of payment need to be kept.

Reference no: EM131768043

Questions Cloud

Discuss a lease agreement for office equipment : Elston Company has entered into a lease agreement for office equipment which could be purchased for $39,927

Discuss financial statements in accordance with igaap : How would your answer change if Frye prepared its financial statements in accordance with iGAAP

How should this be accounted for in the financial statements : How should this be accounted for in the financial statements. Be sure to use the requirements of Codification Section

How many populations are involved in the study : The researcher mentioned in Exercise II proceeds to randomly assign a type of paint to each of the four locations. It is known that specific aspects.

Describe the current business rules for HTH : Create an ERD for each of the statements that describe the current business rules for HTH - Details about the customer and the requested job need

Explain your treatment and be sure to show : explain your treatment and be sure to show your computations if you conclude that a liability must be recorded

Analyze the practice of epidemiology : After reviewing this week's readings, analyze the practice of epidemiology in the U.S. as compared to Third World countries in general.

What are the overall admission rates of men and women : The 1973 admission rates of men and women applying to graduate school in different departments of the University of California at Berkeley are as follows.

What the amount of the expense for compensated absences : What is the amount of the expense for compensated absences that should be reported

Reviews

len1768043

12/15/2017 6:44:39 AM

Requirements Either save your ERD diagram as a PDF or embed it in a Word document. Don't use any other file formats Don't submit your file in XML Please include your student ID, name and subject code in the diagram For guidance on how to draw an ERD based on business rules• Include the PKs where appropriate • Manually drawing the ERD is NOT acceptable.

len1768043

12/15/2017 6:44:17 AM

Marking criteria The marking criteria for this assignment is: Criteria HD DI CR PS be able to gather, analyse and model business requirements using Enhanced Entity Relationship Diagrams (EERD); Model identifies all PKs, attributes and relationships. Model accurately represents all four business rules and includes all entities, PKs, attributes, relationships, associative entities (if applicable), cardinalities and optionalities. Model identifies PKs, attributes and relationships with minor omissions. Model accurately represents the business rules and includes the identified entities, PKs, attributes, relationships, associative entities (if applicable), cardinalities and optionalities. Model identifies key PKs, attributes and relationships. Model represents key business rules and includes the related entities, PKs, attributes, relationships, associative entities (if applicable), cardinalities and optionalities. Model represents key business rules and draws out the key relationships and includes the related entities, PKs, attributes, relationships, cardinalities and optionalities.

len1768043

12/15/2017 6:44:10 AM

The overview of business case is included here to provide context only. For the purpose of identifying entities, attributes and relationships between entities please read HTH business rules and instructions for creating your ERD This assessment aligns with the following subject outcomes: • be able to gather, analyse and model business requirements using Enhanced Entity Relationship Diagrams (EERD);

Write a Review

Required(*) Message

Business Management Questions & Answers

Caselet on michael porter’s value chain management

The assignment in management is a two part assignment dealing 1.Theory of function of management. 2. Operations and Controlling.

Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. Due to increase in the preference for light beer drinkers, Chris Prangel wants to introduce light beer version in Mountain Man. An analysis into the la..

Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. An analysis into the launch of Mountain Man Light over the present Mountain Man Lager.

Analysis of the case using the doing ethics technique

Analysis of the case using the Doing Ethics Technique (DET). Analysis of the ethical issue(s) from the perspective of an ICT professional, using the ACS Code of Conduct and properly relating clauses from the ACS Code of Conduct to the ethical issue.

Affiliations and partnerships

Affiliations and partnerships are frequently used to reach a larger local audience? Which options stand to avail for the Hotel manager and what problems do these pose.

Innovation-friendly regulations

What influence (if any) can organizations exercise to encourage ‘innovation-friendly' regulations?

Effect of regional and corporate cultural issues

Present your findings as a group powerpoint with an audio file. In addition individually write up your own conclusions as to the effects of regional cultural issues on the corporate organisational culture of this multinational company as it conducts ..

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!

Submit Assignment

User Account

All Pages