Access® Database for Disneyland

Introduction

We created the Access® database to support the management of Disney of Regina. All

data for human resources management are readily accessible in our database.

We separated the facilities into different sections: Gaming Facilities, Entertainment Shows, Managers, Manager Salaries, and Service Facilities. In doing so, we can have ease of access to key data. This type of data includes how many gaming facilities are in our Disneyland, the target groups, the number of monthly visits to a particular facility, operating expenses, and a very detailed distribution of managers’ information, including personal information, education level and contact methods. The human resource database system focuses on the operational management of Regina's Disneyland.

Forms and Tables

The forms and tables in this database include all relevant data that a user would require to search about information within the company such as its gaming facilities, entertainment shows, services facilities, themes, managers and managers’ salaries.

The database for the Regina Disneyland consists of six tables: Gaming Facilities Information, Entertainment Shows Information, Service Facilities Information, Themes Information, Manager Information and Manager Salary Information.

The first table, Gaming Facilities Information, describes in detail the facility number, facility name, monthly visits, operating expenses, remaining life time, manager ID, theme, target group and stimulation. Using this table, users are able to retrieve any information they need about any gaming facility.

The second table is Entertainment Shows Information. It contains the information of themes, performance name, monthly visits, investment, equipment maintenance, performer’s salary, performances per day and performance type.

The third table is Services Facilities Information. It contains detailed information such as service ID, service name, monthly visits, total revenue, operating expense, capital...