Reference no: EM131330524
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.
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
|
Installation of the linux os
: Why do you suppose so much planning needs to occur before installation of the Linux OS?
|
|
Major components of object oriented database modeling
: Q1: Identify and provide definitions of the major components of object oriented database modeling? Q2: Identify tools used to develop object oriented data model? Q3: Define its differences between object oriented data modeling and relational data mod..
|
|
Modified endowment contract
: Kevin owns a modified endowment contract. Kevin recently reassessed his insurance needs and decided that he would like to exchange his current modified endowment contract for a different insurance product. Which of the following transactions might re..
|
|
Examine the gaslab free gas model
: What affordances does the ABM approach give us that traditional approaches lack? Are there ways that ABM can be more confusing than traditional approaches? If so how?
|
|
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 sh..
|
|
Create buttons to launch these procedurs
: Create buttons to launch these procedures. Compare and contrast your different methods. Is one of these more efficient? Is one of them more realistic? In what situations would each of them have advantages over the other?
|
|
What is the amount of the smaller concluding withdrawal
: A person inherited $91000 and invests it immediately at 10.5% compounded monthly. The person decides to quit his/her job and withdraws $1250 at the end of each month for as long as possible. How many full withdrawals of $1250 can be made? What is the..
|
|
Models of cloud computing based on the nist
: Q1: Describe the three models of cloud computing based on the NIST cloud computing reference architecture. List the advantages and disadvantages of each model.
|
|
Create buttons to launch these procedures
: Create buttons to launch these procedures. Create a monitor that keeps track of how many times one of the turtles has moved.
|