Reference no: EM131183795
Draw a diagram for the ATTACHED DOCUMENT and also ADD ENTITIES ATTRIBUTES RELATIONSHIPS.
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.
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.
|
Difference between gross revenues and net revenue
: What is the difference between gross revenues and net revenues?
|
|
Identify a strategic consulting group or company
: Describe how the selected consulting company recognizes the role that organizational culture plays in realizing strategy.
|
|
Effectiveness of the international labor organization
: Write 2 pages essay where in you consider the effectiveness of the International Labor Organization (ILO) in regulating the activities of multinational businesses in the treatment of their employees
|
|
What are some other categories of expenses
: What is depreciation expense, and what is its purpose?
|
|
Create an erd that shows the entity attributes relationship
: 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.
|
|
Environmental problems associated with fossil fuel
: What is light? What are the primary properties of visible light? How fast does light travel in a vacuum?
|
|
Explain what data protection would entail
: Based on what you have learned about data protection in an online environment, prepare a 5-slide presentation to a department head or the CEO of a company to convince the audience that data protection controls would benefit their business.
|
|
What were total cash expenses for 2007
: What were total cash expenses for 2007? (Hint: Assume that all expenses, except depreciation, were cash expenses.)
|
|
Construct brandywine''s 2007 income statement
: Suppose the change had halved, rather than doubled, the firm's depreciation expense. Now, what would be the impact on net income, total profit margin, and cash flow?
|