Investigate the option of implementing a database system

Assignment Help Database Management System
Reference no: EM131908614

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.

- 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 and business rule 2.

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.

- 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, 2 and 3.

Rationale

This assessment aligns with the following subject outcomes:

- be able to gather, analyse and model business requirements using Enhanced Entity Relationship Diagrams (EERD);

Reference no: EM131908614

Questions Cloud

Discuss the limitations of internal control : Discuss the limitations of Internal Control. Why are internal controls not a guarantee that all is above board?
What is the current market value for machine a : What is the current market value for machine A that would make the two machines equally attractive at an interest rate of 12% per year?
What is the amount credited to kents capital account : Mace and Bowen are partners and share equally in income or loss. What is the amount credited to Kent's capital account?
How does full employment reduce the cost of deterring crime : Assume the acquisition of computers by the police increases the force's efficiency. How would Figure 12.7 change? Assume the acquisition of computers.
Investigate the option of implementing a database system : Investigate the option of implementing a database system. Accordingly, they hired you to design a relational database to better track and record their operation
How much revenue should maas recognize in the first year : Maas LLP developed software that helps farmers to plow their fields in a manner. How much revenue should Maas recognize in the first year of the contract?
Can corporations be punished beyond the value of the asset : What does it mean to say that a corporation intends to do something? Can corporations be punished beyond the value of their assets?
Long-term relationship with a significant other : Describe two factors that research tells us help to maintain a committed long-term relationship with a significant other.
Discuss the practice of purchase or payment discounts : Discuss the practice of purchase/payment discounts. What relationship does accounts payable have to this activity?

Reviews

len1908614

3/20/2018 8:04:24 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

len1908614

3/20/2018 8:04:14 AM

Detailed and accurate ERD that contains all entities, PK and FK, attributes, associative entities included if required, all relationships shown and identified with correct cardinality and optionality Thorough and reasonably accurate ERD that contains all entities, PK and FK, attributes, associative entities included if required, all relationships shown and identified with correct cardinality and optionality Adequate ERD that contains most entities, PK and FK, attributes, associative entities included if required, all relationships shown with cardinality Incomplete or irrelevant ERD that contains some entities, relationships, and cardinality

len1908614

3/20/2018 8:04:04 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); Marking criteria The marking criteria for this assignment is: Comprehensive and accurate ERD that contains all entities, PK and FK, attributes, associative entities included if required, all relationships shown and identified with correct cardinality and optionality TASKS HD DI CR PS FL TASK 1,2,3,4 Comprehensive and accurate ERD that contains all entities, PK and FK, attributes, associative entities included if required, all relationships shown and identified with correct cardinality and optionality

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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