Create an erd that represents the entities

Assignment Help Database Management System
Reference no: EM131314310

Task

Overview of business case:

Alive & Boating (A&B) is a small start­up company that sells small boats in Wagga. A&B 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&B 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&B 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, A&B retail price and dry weight must be kept in the system.

Add the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule to the same copy of 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, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule to the same copy of the ERD that you created for business rule 1 and business rule 2.

Reference no: EM131314310

Questions Cloud

What is the companys cost of preferred stock for use : If the company were to sell a new preferred issue, it would incur a flotation cost of 4.00% of the price paid by investors. What is the company's cost of preferred stock for use in calculating the WACC?
What are your recommendations to make this better : Which of the topics presented to you thus far in this course has been most difficult to understand? Why?Which of the topics presented thus far in this course has been most interesting and important to you? Why?What are your recommendations to make ..
Compute the horsepower input of the test pump : The discharge of water through the pump is measured to be 4 ft3 /s. Compute the horsepower input of the test pump.
Safety practitioner to use macro thinking : Why is it important for the safety practitioner to use macro thinking? Provide one or two examples that support your discussion. Your response must be at least 75 words in length.
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 that are described by this business rule
Strategic planning in action-jhpiego : Review the media segment "Strategic Planning in Action: Jhpiego." What insights regarding the contemporary leader's role in strategic planning and management can you draw from Dr. Leslie Mancuso's discussion of the global health organization Jhpie..
Determine the volume rate of air flow in the duct : The density of air is 1.22 kg/m3. Determine the volume rate of air flow in the duct in cubic feet per second. What is the horsepower output of the fan?
Would you deem karina disabled under the adaaa : Would you deem Karina disabled under the ADAAA? If so, what reasonable accommodations would you offer to her?From an ADA policy standpoint, what would your ideal be in terms of an employer ADAAA policy? What would your ideal be as to what the emplo..
Profitability index average accounting return : The ______ is the length of time required for an investment’s cash flows to equal its initial cost? Payback period Discounted payback period Net present value Profitability index Average accounting return

Reviews

len1314310

12/16/2016 1:10:03 AM

NOTE Use Flow Chart Maker & Online Diagram Software (https://www.draw.io) to create your ERD Use Crows Foot notations Any M:N relationship is to be resolved to a 1:M relationship Manually drawing the ERD is NOT acceptable.

Write a Review

Database Management System Questions & Answers

  Develop proposal recommends hardware and operating system

Papers should be created with Microsoft Word in the APA style and have a title page, short abstract, body, and conclusion. The "body" should contain between 1000 and 2000 words and include a Works Cited page, headers and other appropriate APA ele..

  Illustrate concurrency control method by two phase locking

For each table argue whether or not interference with another transaction is possible. Illustrate concurrency control method using two phase locking.

  Prepare the layout for the buysell database- the general

chris and pat aquino own a successful isp internet service provider and want to expand their business to host an

  Learn about some of the things going on in the real-world

Assignment - Data Mining and Machine Learning in the Real World. OBJECTIVE: Learn about some of the things going on in the real-world with Machine Learning and Data Mining

  Draw the general hardware company entity-relational diagram

Draw the General Hardware Company Entity-Relational diagram. Choose a primary key for each of the relations. Choose foreign key(s) for each of the relations.

  Create a detailed erd using the entities and attributes

Create a detailed ERD using the Entities and Attributes for Driver's Log document found on the Huffman Trucking Intranet site.

  Create a program using microsoft access database

Please create a program using Microsoft Access Database. Create a system for Construction Engineering Norms. This objective for this system is to be use by the Project Management to do an estimate for the CONTRUCTION ENGINEERING works.

  Use case diagram for the functional requirements

Analyse the Case Study documents and produce an initial high level functional requirements specification. Document these requirements with.

  A motor vehicle maintenance center wants to enhance its

write a 200- to 300-word short-answer response for the followinga motor vehicle maintenance center wants to improve its

  Database management system

Should define, explain, and discuss one of the following: Database management system

  What type of data model used in marts to improve performance

Where can sub queries be placed in a SQL select statement? What tables are good candidates for indexes and what type of indexes would you place on those tables? What type of data model is used in data marts to improve performance?

  Write functional dependencies in table concerns invoicing

Write the functional dependencies in the following table that concerns invoicing (an application Premiere Products in considering adding to its database), subject to the specified conditions.

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