We're Open
+44 7340 9595 39
+44 20 3239 6980

ALIVE & BOATING (A&B) IS A SMALL START-UP COMPANY

  100% Pass and No Plagiarism Guaranteed

ALIVE & BOATING (A&B) IS A SMALL START-UP COMPANY

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:

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

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.

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 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. 

Rationale

This assessment item is designed to test your understanding of basic database design and modelling concepts, and your ability to interpret business rules into an Entity Relationship Diagram.

Additionally, your ability to apply correct relationships, cardinalities, optionalities, and the use of Crows Foot modelling notations are tested.

Marking Criteria

The marking criteria for this assignment is:

Task    

HD
DI
CR
PS

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    

The ERD accurately identifies and correctly shows all entities, PKs, attributes, relationships, associative entities (if applicable), cardinalities and optionalities

The ERD accurately identifies and correctly shows all entities, PKs, attributes, relationships, and associative entities (if applicable) but some of the cardinalities and optionalities are incorrect

The ERD accurately identifies and correctly shows most entities, PKs, attributes, but some of the relationships, associative entities (if applicable), cardinalities and optionalities are incorrect

The ERD identifies and shows some entities, PKs, attributes, but most of the relationships, cardinalities and optionalities are incorrect


100% Plagiarism Free & Custom Written,
Tailored to your instructions


International House, 12 Constance Street, London, United Kingdom,
E16 2DQ

UK Registered Company # 11483120


100% Pass Guarantee

STILL NOT CONVINCED?

View our samples written by our professional writers to let you comprehend how your work is going to look like. We have categorised this into 3 categories with a few different subject domains

View Our Samples

We offer a £ 2999

If your assignment is plagiarised, we will give you £ 2999 in compensation

Recent Updates

Details

  • Title: ALIVE & BOATING (A&B) IS A SMALL START-UP COMPANY
  • Price: £ 109
  • Post Date: 2024-08-28T18:23:38+00:00
  • Category: Assignment
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

ALIVE & BOATING (A&B) IS A SMALL START-UP COMPANY ALIVE & BOATING (A&B) IS A SMALL START-UP COMPANY
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

CIPD assignment is not my cup of tea. That’s the reason I sought out this place suggested by my friend. I would say that the writers of this site are really admiring. I was assigned the best CIPD writer that solved all my issues. He explained to me the difficult topics so well that now I am able to talk on those topics eloquently. I owe my writer a huge thanks and praise! And yes, I would recommend other students as well to come to instaresearch.co.uk for the top CIPD assignment help.
Reviews: 5

A masterpiece of assignment by , written on 2020-03-12

I received my order last night and now I’m writing my reviews. My assignment has all the points I needed along with a good style. The citations used are relatable and professional. The best thing is the discount I got because I recommended my friend too to use their service. I am so pleased to use this effective service. The features are also amazing, everything is good. Will come again soon!