Reference no: EM13897756
Create an ERD that represents the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by the three business rules
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 many 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
Manually drawing the ERD is NOT acceptable.
|
What the definitions of social stratification and poverty
: As the saying goes, some people have more than others. However, we now see that some people have way more than others! (a) What are the definitions of social stratification and poverty? (b) What are the arguments for the justification of inequalit..
|
|
What combinations of ?nancing allow no change in investment
: Suppose that the government wants to increase its expenditure g and has the options of ?nancing it by higher taxes, bond issues or increases in the monetary base. Further, when g is increased through bond or monetary ?nancing, the central bank can..
|
|
Describe what hacking of memory or hacking of ram means
: Describe what hacking of memory or hacking of RAM means
|
|
Effects of the sympathetic nervous system
: Chronic anxiety and stress contribute to ulcers. Which of the following effects of the sympathetic nervous system is most responsible for this effect
|
|
Create an erd that represents the entities and attributes
: Create an ERD that represents the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by the three business rules
|
|
Explain the cultural impact of the printing press
: In his book The Dynamics of Mass Communication (Ch.3), Joseph Dominick describes the role that technological advances played in facilitating significant changes in our culture and society. Explain the cultural impact of the printing press
|
|
Is the lm relationship required for its determination
: Given a closed economy without a government sector, modify the IS-LM model by the assumption that saving and investment are identical (i.e. equal under all circumstances and not merely in equilibrium) and answer the following: What is the level of..
|
|
How are money growth and in?ation determined in this context
: Suppose that the economy is such that a positive monetary shock reduces unemployment. Assume that the central bank likes a reduction in unemployment but dislikes an increase in in?ation. The public forecasts money growth from the government's opti..
|
|
Discuss some of the cloud computing issues and challenges
: Find one cloud computing company. Your research should include the following: Explain how it works and their services and Discuss some of the cloud computing issues and challenges
|