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

BREAKFAST GUEST HOUSE IN THE BLUE MOUNTAINS OF NSW

  100% Pass and No Plagiarism Guaranteed

BREAKFAST GUEST HOUSE IN THE BLUE MOUNTAINS OF NSW

Task

The Fermoy House database

The owners of Fermoy House, a Bed and Breakfast guest house in the Blue Mountains of NSW, have approached you to build them a database to help them run their business.

Fermoy House provides overnight accommodation and breakfast to couples and has four guest bedrooms and a detached private cottage in a private part of the garden. Each bedroom, and the cottage, will accommodate a maximum of 2 guests only.

Task

  1. Create an ERD that shows the entities, attributes, relationships, cardinality and optionality that describe the booking of a room by a guest. This ERD is to be labelled ERD 1. (50 marks)


In order to create a point of differentiation from other local bed and breakfast houses, Fermoy House will allow guests to have up to 2 of their dogs stay in the attached kennels. The dog names are normally recorded so that Fermoy House can provide guests with a personalised dog collar for each dog.


Task

 

  1. Add the entities, attributes, relationships, cardinality and optionality that describe the addition of a dog(s) by a guest to their booking. Add these to ERD 1. This new ERD is to be labelled as ERD 2. (20 marks)

 

Breakfast is provided for all guests as part of their accommodation, and guests can choose from either a Continental or a cooked Irish breakfast. This information is normally recorded at the time of booking the accommodation.


Task

 

  1. Add the entities, attributes, relationships, cardinality and optionality that describe the addition of breakfast by a guest to their booking. Add these to ERD 2. This new ERD is to be labelled as ERD 3. (20 marks)

Bookings are normally taken for up to 12 months in advance and guests who have stayed more than 5 times at Fermoy House receive a gift of wine and chocolates on arrival.


Task

 

  1. Add the entities, attributes, relationships, cardinality and optionality that describe how many times a guest has booked a stay at Fermoy House. Add these to ERD 3. This ERD is to be labelled as ERD 4. (10 marks)

 

Rationale

 

This assessment item is designed to test your understanding of the following learning outcomes:

  • Basic database design and modelling concepts,
  • Identification and interpretation of business rules,
  • Creation of an Entity Relationship Diagram from a set of business rules,
  • Application of correct relationships, cardinalities, optionality using the Crows Foot modelling notation.
     

Marking Criteria

 

Task

HD

DI

CR

PS

FL

ERD 1: Booking

Create an ERD that accurately represents all entities, their relationships with both cardinality and optionality correctly described and all Primary Keys and Foreign keys identified

Create an ERD that accurately represents all entities, their relationships with most cardinality and optionality correctly described and all Primary Keys and Foreign keys identified

Create an ERD that represents all entities, their relationships with most cardinality and optionality correctly described and all Primary Keys and most Foreign keys identified

Create an ERD that represents all entities, their relationships with some cardinality and optionality correctly described and all Primary Keys and some Foreign keys identified

Create an ERD that represents some entities, their relationships with little or no cardinality and optionality described and few or no Primary Keys and Foreign keys identified

ERD 2: Dog booking

Correctly add additional entities, relationships, Primary and Foreign keys with all cardinality and optionality correctly described to existing ERD to correctly reflect the additional business rule

Correctly add additional entities and relationships, Primary and Foreign keys with most cardinality and optionality correctly described to existing ERD to reflect the additional business rule

Correctly add additional entities and relationships, Primary and most Foreign keys with most cardinality and optionality correctly described to existing ERD to reflect the additional business rule

Add additional entities and relationships, Primary and some Foreign keys with some cardinality and optionality correctly described to existing ERD to reflect the additional business rule

Add some additional entities and relationships, with few or no Primary and some Foreign keys, and with little or no cardinality and optionality described to existing ERD

ERD 3: Breakfast

Correctly add additional entities, relationships, Primary and Foreign keys with all cardinality and optionality correctly described to existing ERD to correctly reflect the additional business rule

Correctly add additional entities and relationships, Primary and Foreign keys with most cardinality and optionality correctly described to existing ERD to reflect the additional business rule

Correctly add additional entities and relationships, Primary and most Foreign keys with most cardinality and optionality correctly described to existing ERD to reflect the additional business rule

Add additional entities and relationships, Primary and some Foreign keys with some cardinality and optionality correctly described to existing ERD to reflect the additional business rule

Add some additional entities and relationships, with few or no Primary and some Foreign keys, and with little or no cardinality and optionality described to existing ERD

ERD 4: Number of stays

Correctly add additional entities, relationships, Primary and Foreign keys with all cardinality and optionality correctly described to existing ERD to correctly reflect the additional business rule

Correctly add additional entities and relationships, Primary and Foreign keys with most cardinality and optionality correctly described to existing ERD to reflect the additional business rule

Correctly add additional entities and relationships, Primary and most Foreign keys with most cardinality and optionality correctly described to existing ERD to reflect the additional business rule

Add additional entities and relationships, Primary and some Foreign keys with some cardinality and optionality correctly described to existing ERD to reflect the additional business rule

Add some additional entities and relationships, with few or no Primary and some Foreign keys, and with little or no cardinality and optionality described to existing ERD

 

Marking Guide

 

Task

Marks

Score

Comments

ERD 1: Booking

50

 

 

ERD 2: Dog Booking

20

 

 

ERD 3; Breakfast ordering

20

 

 

ERD 4: Number of stays

10

 

 

Total

100

 

 

Final mark

15

 

 

 

Presentation

 

Assignments are to submitted as a single document with all ERD drawings embedded in the document. Assignments that are submitted with separate ERD drawings will not be accepted.

 

ERD drawings are to be completed using either mySQL or the Draw.io tool.


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: BREAKFAST GUEST HOUSE IN THE BLUE MOUNTAINS OF NSW
  • Price: £ 109
  • Post Date: 2018-11-09T08:55:14+00:00
  • Category: Assignment
  • No Plagiarism Guarantee
  • 100% Custom Written

Customer Reviews

 BREAKFAST GUEST HOUSE IN THE BLUE MOUNTAINS OF NSW BREAKFAST GUEST HOUSE IN THE BLUE MOUNTAINS OF NSW
Reviews: 5

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

My writer did a small error in my work but it was fixed by him shortly. The work is admirable and I have submitted it. Now hoping for the best results. I would inform you soon.
Reviews: 5

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

Now I am happy that I made the right decision of coming to Insta Research for help. My term paper was so technical and analytical at the same time. I got really confused about what to do but got relaxed when I was given such a humble writer. He clarified my concepts with the best explanations and discussions. I almost interacted with him on daily basis within the writing process. The best feature of this site is quick delivery as I got the work before my deadline. Additionally, the term paper is written skillfully and handled quite professionally. Now I am able to take a deep sigh of relief and thank you all for such speedy help. The quality of the work made my day.