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 ...view middle of the document...
This table is very useful for users to determine the investment and operating expense in those services.
The fourth table is Theme Information. This table includes the information about theme name, manager ID, theme source, life cycle, budget, capital expense and product revenue.
The fifth table is Manager Information. Users can obtain the details of information about the status of each manager including name, manager number, education, salary, working situation, date of joining and contact information.
The sixth and last table is manager salary information. It contains manager ID, monthly salary, absences and overtime. Users can access all details relating to managers’ salaries by using this table.
Each entertainment show is connected with a theme. Each manager has a unique ID number that is used to connect a manager and the manager salary. Every manager is in charge of some gaming facilities. Users can find this relation by using the manager ID. Through theme name, users would be able to find the relation of a theme and some gaming facilities. In addition, through manager ID, the system will allow users to find the relation between a manager and many services facilities and a manager and many themes.
1. To expand our database
Since our database was created for senior managers to access the data of operational management, we focused on the performance of operation managers. However, our service facilities table covers a variety of service departments that affect the efficiency level. Therefore, we should further develop the database by adding more tables related to each area such as the human...