2023 Case High Hopes Bed Breakfast Pauline Jones is the owner of High Hopes Bed | Assignment Collections

Computer Science 2023 Computer Science

2023 Case High Hopes Bed Breakfast Pauline Jones is the owner of High Hopes Bed | Assignment Collections

Case: High Hopes Bed & Breakfast

Pauline Jones is the owner of High Hopes Bed & Breakfast in Whistler. Her Bed & Breakfast consists of four bedrooms that can be booked either online via an international

hotel booking site or over the phone. Each bedroom has its own name and

comes with either a Mountain or Lake view.

Guests come from all over the world and when they make a booking Pauline records this in an Excel spreadsheet, along with any special requirements. Many guests return year after year. Most guests will book 1 bedroom but some guests will book multiple rooms if they are in a group.

She also partners with a local activity company which offers outdoor excursions in the Whistler area, such as: skiing, mountaineering, cycling and rock-climbing. Pauline keeps a list of these activities along with their costs which is available to guests. If a guest chooses to book an outdoor excursion, they will be given a discount on their total booking.

Part A: Databases

Up until now, Pauline has been recording data in Excel Spreadsheets. She would like you to create a Database for her business.

The database should contain information on the following:

● Bedrooms

● Guests

● Bookings

● Outdoor activities

(A1) Design a relational database

In MS Word, create a diagram that shows the following information:


An example is ​shown here​. Note that your diagram should clearly identify primary and foreign keys as well as the type of relationship.

File name:​ Firstname_HH_Database_Design.docx

(A2) Create the Database in MS Access

Create a relational database in MS Access, creating tables for each entity and listing each attribute as a field. You will need to choose suitable data types.You can also set input masks and validation rules as appropriate. You will set up the relationships between the tables. You will also create forms for a more user friendly method of inputting data. You DO NOT need to add data into the tables.

(A3) Create Queries

Pauline would like to have queries set up to find out information such as:

● How many guests live in Canada

● Which customers have reserved more than 1 room

● Which customers have booked skiing as an outdoor activity (sort in descending order of

customer name)

File name:​ Firstname_HH_Database.accdb

Part B: Web Development

Pauline does not have her own website currently, she would like you to set up a sample “home” page which has information on the Bed & Breakfast, e.g. the different rooms and their features. A table can be used to hold images of the different rooms – all room images should be the same size. The page can also promote the additional services offered e.g. the outdoor excursions.

Headings, paragraphs and hyperlinks should also be used appropriately and the webpage should be designed with accessibility in mind.

How you design the page is entirely up to you – BUT it should follow general good web design principes, e.g. keep it simple, don’t overuse bright colours etc.

Content Styles

Aim to use a wide range of the tags Use both inline and internal CSS specified on the HTML Cheat sheet

File name: ​Firstname_HH_Web.html

Part C: Python

Pauline has asked for a program that can be used for potential guests to find out the cost of their stay. They will also be able to add the cost of outdoor activities if they wish to book one (or more). If the guest does book an outdoor activity, they will be entitled to a 10% discount of their total cost.

The program needs to ask the user how many rooms they would like to book. Each room is $120 a night. It also needs to ask how many nights they are staying. It then needs to ask how many outdoor activities they would like to book (if any). Each activity is $70.

The program will then need to calculate the total cost and output this in a suitable message. It will then decide whether the user is entitled to the 10% discount based on the information above. If they are, it will deduct 10% from the total and display a suitable message with the new total to the user. Otherwise, it will simply inform the guest that no discount is available.

You should include a heading and introductory paragraph to be displayed on your program. Within the programming code itself, you should use good programming style.

You must only use code covered on this course.

Filename: ​Firstname_HH_Program.py

Part D: Report

Using MS Word, write a report (450-500 words) which covers the following points:

(1) How well you believe you’ve met the requirements of this assignment? (2) What you have learnt from working on this assignment?

(3) What would you do differently in the future?

Filename: ​Firstname_HH_Report


You will submit the files below in the following order:

Firstname_HH_Database_Design.docx Firstname_HH_Database.accdb Firstname_HH_Web.html Firstname_HH_Program.py Firstname_HH_Report.docx

Before you submit your assignment, you will be required to verify that ​the work you are submitting is your own ​- an automatic message will appear when you click submit.


We give our students 100% satisfaction with their assignments, which is one of the most important reasons students prefer us to other helpers. Our professional group and planners have more than ten years of rich experience. The only reason is that we have successfully helped more than 100000 students with their assignments on our inception days. Our expert group has more than 2200 professionals in different topics, and that is not all; we get more than 300 jobs every day more than 90% of the assignment get the conversion for payment.

Place Order Now

#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper #Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational