Reference no: EM131186274 , Length: word count:1500
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.
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.
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.
2. 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.
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.
3. 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.
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.
4. 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.
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.
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.
1500 words.
4 apa reference.
|
Firms assets does the firm finance using debt
: Use this data campbell Industries liabilities and owner's equity. What percentage of the firm's assets does the firm finance using debt (liabilities)?
|
|
Considering buying loan from local bank
: You are considering buying a loan from a local bank with the following features: Loan principal: $10,000 Term: 5 years Stated rate: 7% Current market value: 9,500 What rate of return can you expect from this loan?
|
|
What have researchers said about your research topic
: Identify eight to ten research articles from peer-reviewed journals that address your research topic or a very similar topic and what research approaches and methodologies were used and why?
|
|
Significant advantage for respective company
: Which producer is likely to view the expansionary period as a more significant advantage for their respective company? Explain your answer.
|
|
Create an erd that shows the entities and attributes
: Create an ERD that shows the entities, attributes, relationships, cardinality and optionality that describe the booking of a room by a guest
|
|
Describe the-two state model for credit ratings
: Describe the-two state model for credit ratings under the real world measure.
|
|
Especially illustrate cycles or approaches toward us economy
: Especially illustrate the cycles or approaches toward the U.S. economy: going from one extreme to another depending upon the mood of the nation and the presidential administrations of specific time periods.
|
|
Considering environmental issues
: A concept that implies that the firm should consider issues such as protecting the consumer, paying fair wages, maintaining fair hiring practices, supporting education, and considering environmental issues.
|
|
Draw a symbol for this address decoder
: Suppose that a memory chip has capacity for 64 k bits, divided into 4 k words of 16 bits each. Knowing that an address decoder is used to activate the word lines, do the following:
|