Reference no: EM131182828
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.
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 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.
Task 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.
Task 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.
|
Portfolio from these two assets with expected return
: Portfolio risk and return: suppose that the S&P500, with a beta of 1 has an expected return of 10%, and T-bills provide a risk free return of 4%. How would you construct a portfolio from these two assets with an expected return of 8%. How would you c..
|
|
List the six general types of information management systems
: List the six general types of information management systems, and give one logistics application to each one of the types listed. Highlight the advantages and/or disadvantages
|
|
Principles of social structure and personality perspective
: Review the three principles of social structure and personality perspective. How do scholars from this perspective see society affecting interaction among individuals? Minimum of 300 words
|
|
Importance in community development
: Discuss the logic model and its importance in community development. Identify and discuss the different types of evaluation. Identify and discuss the different types of data collection and when each is most useful.
|
|
Create an erd that shows the entities
: 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.
|
|
Focus on improving the economy or the environment
: Is it more important to focus on improving the economy or the environment? Explain your answer referencing both the conflict and functionalist perspectives.
|
|
Considering the purchase of new plastic stamping machine
: Big Steve's makers of swizzle sticks, is considering the purchase of a new plastic stamping machine. This investment requires an initial outlay of $110,000 and will generate net cash inflows of $17,000 for 9 years. What is the project's NPV using a d..
|
|
Has the impact been positive or negative
: Write 400-600 words that respond to the following questions with your thoughts, ideas, and comments. Use examples to reinforce your ideas. Has the impact been positive or negative
|
|
Institutions of government and economy
: Discuss how the institutions of government and economy may affect the healthcare institution. Support your response with evidence from your readings or other sources.
|