Create an ERD that represents the entities

Assignment Help Business Law and Ethics

Reference no: EM131874452

Task

Overview of business case:

A&H Boating is a small start-up company that sells small boats in Geelong. A&H Boating keeps its models in several showrooms across the city. At this stage customers cannot view the available models online so to order they must visit one of the showrooms. A&H Boating has been using an Excel spreadsheet to track their business activities, however, this has caused many redundancies and inefficiency.

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.

A&B business rules and instructions for creating your ERD:

1. A&H Boating can get boats from several different manufacturers. Each manufacturer produces one or more different types of boats. Each and every type is produced by only one manufacturer. Every manufacturer is identified by a manufacturer code. The company name, street, city, state, postcode, phone number, and account number are kept in the system for every manufacturer. For each type, the type name (i.e. Paddle, Inflatable, Jet Ski, etc.) and purpose (i.e. fishing, day boating, etc.) are kept in the system.

Create an ERD that represents the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule.

2. Every type has one or more models. Every model is produced as part of a type. For each model, the model number, engine, length, beam, suggested retail price, retail price and dry weight must be kept in the system.

Add the entities, attributes, relationships between entities, cardinality and optionality of each relationship that are described by this business rule to the ERD that you created for business rule 1.

3. Each type's models are stored in a specific warehouse. Each warehouse stores the models of only one type. Each warehouse is identified by a warehouse ID. For each warehouse address, postcode, phone number are kept in the system.

4. Each warehouse can be visited by prospective customers with prior booking. Customers can book a visit to a specific warehouse by calling A&H Boating hotline. Customers need to provide full name, date of birth, address, email address and contact number during booking a visit to a warehouse.

Rationale

This assessment item is designed to test your understanding of the following learning outcomes:
- Basic database design and modelling concepts,
- Identification and interpretation of business rules,
- Creation of an Entity Relationship Diagram from a set of business rules,
- Application of correct relationships, cardinalities, optionality using the Crows Foot modelling notation.

Presentation: Use draw website (flowchart maker and online diagram software) to create your ERD

Reference no: EM131874452

Questions Cloud

A summary of green initiatives for a city in your area : Recommendations to your local government for creating a greener, more sustainable and livable community.

Find predetermined overhead rate in the assembly department : Assume that the company uses the direct method of allocation. The predetermined overhead rate in the Assembly Department would be closest to

Prepare an essay demonstrating importance of nfpa standard : Prepare an essay demonstrating the importance of NFPA Standard 25 and how the standard positively influences fire protection and firefighter safety.

Finance manager work to ensure proper financial controls : With what players in an organization does the finance manager work to ensure proper financial controls are in place?

Create an ERD that represents the entities : Create an ERD that represents the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship

Prepare an analysis of an environmental issue : An explanation of how individuals, communities, and/or governments are working to address the environmental issue.

Find the forces exerted : A constant horizontal force of magnitude FH = 3 N is applied to m1. Find the forces (vectors!) exerted on m1 by m2 and on m2 by m3.

How does vast movement of food from one nation to another : How does the vast movement of food from one nation to another benefit or potentially harm developing nations?

Expect from a wind turbine : What maximum output would you expect from a wind turbine with a blade of radius 15 ft in a 25 mph wind?

Reviews

len1874452

2/22/2018 4:36:41 AM

Rationale This assessment aligns with the following subject outcomes: be able to gather, analyse and model business requirements using Enhanced Entity Relationship Diagrams (EERD) Presentation: 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

2/22/2018 4:36:00 AM

This assessment item is designed to test your understanding of the following learning outcomes: . Basic database design and modelling concepts, . Identification and interpretation of business rules, . Creation of an Entity Relationship Diagram from a set of business rules, . Application of correct relationships, cardinalities, optionality using the Crows Foot modelling notation.

Write a Review

Required(*) Message

User Account

All Pages