Question: MICROSOFT ACCESS DATABASE Create a database that allows people to reserve campsite(s) at Ontario's Provincial Parks 1. The database (DB) must contain at least 4

MICROSOFT ACCESS DATABASE

Create a database that allows people to reserve campsite(s) at Ontario's Provincial Parks

1. The database (DB) must contain at least 4 tables, but you may have more.

You must indicate the type and size of each attribute you add to the tables.

Indicate the relationships between each of the tables.

2. Ontario Provincial Park information:

- multiple parks (i.e. Algonquin, Killarney)

- parks can have many campgrounds (i.e. Algonquin has Tea, Rock, Canoe)

- campsites have an ID which makes them unique in the Ontario Parks system and a site number that identifies them within the campground

- campsites have attributes (read below you may think of more)

- services & facilities available at the campground (you decide)

- costs (standard cost common to all sites plus additional charge based upon

site attributes)

- discounts (senior / group)

3. We need to produce at least the following information. You may have more ideas

- total number of campers in a park on a given day

- Parks and all their RV campsites

- when does a park open/close for the season

- which campsite is empty on a given day

- number of premium waterfront sites at a park

- which campsite a person booked on a given day

- which campsite(s) have electricity and/or water

- the bookings for campsite "x" for a given month

- all "group" sites and their cost per day

- the cost of an additional vehicle on the site

- reservation fee for a booking (Ontario Provincial Park standard reservation fee)

- if alcohol is banned at a campground

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

A Case Study: Traffic Administration Diplomacies after the COVID-19 Pandemic Although the operational issues they may have on the roads owing to the pandemic, the law enforcement agencies continue to...

In Regards to Question: Janies Pet Minding Janie is a local supplier of pet walking, i have to submit my MS Access file by early next week and can solve it by myself. please help! thank you. Janies...

Janies Pet Minding Janie is a local supplier of pet walking and sitting services for business people. The plan is to eventually grow the business to also provide online accessories to pet owners. A...

Please help me with the relations when creating a database? Why should Janie implement a Microsoft Access database for her business as opposed to another database solution such as Microsoft SQL...

i really need help with an expert on this microsoft Access please. i really need help with an expert on this microsoft Access please. Group Project 1 Instructions Step 1: Read the background...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

Project 1 Instructions Step 1 : Read the background information Step 2 : Skip Assignment 1 Step 3 : Based on the background information determine the Access tables you need for your database, and the...

haa23684_PlugInT6CD.qxd 9/6/06 5:38 PM Page 2 CONFIRMING PAGES P L U G - I N T6 Basic Skills and Tools Using Access LEARNING OUTCOMES 1. Describe the primary functions using Microsoft Access. 2....

could someone please help me these access assignment Accounting Information Systems Access Assignment S&S Revenue Database Introduction to Microsoft Access: Microsoft Access is representative of...

Overview This assignment requires you to convert a UML class diagram into a relational model, physically create tables in Microsoft Access, and enter data into the tables. The main purpose of this...

A train, traveling at a constant speed of 22 m/s, comes to an incline with a constant slope. While going up the incline, the train slows down with a constant acceleration of magnitude 1.4 m/s2. (a)...

Let f(x) = x. Compute its discrete Fourier coefficients based on n = 4, 8 and 16 sample points. Then, plot f(x) along with the resulting (real) trigonometric interpolants and discuss their accuracy.

Exercise 1 3 - 3 9 ( Algo ) Estimate Cash Collections ( LO 1 3 - 4 ) Hackett Produce Supply is preparing its cash budget for April. The following information is available: Estimated credit sales for...

The Bean Company provides fresh coffee beans for restaurants, hotels, and other food service companies. Bean offers three types of coffee beans: Premium, Gourmet, and Quality. Each of the three...

3. Divide into teams of two students. One student should be designated as a trainer, the other as a trainee. The trainee should briefly leave the room while the trainer reads the instructions for...

1. Choose a job with which you are familiar. Develop a self-directed learning module for a skill that is important for that job.

9. Discuss the steps of an action learning program. Which aspect of action learning do you think is most beneficial for learning? Which aspect is most beneficial for transfer of training? Explain...