ISM3004 Database Project
This week in ISM3004 we created a Database Project. We were given an overview of a local gym that we work for and had to create a database to store important information about the members that go to this gym. The boss of this gym that I work for wanted a greater data management and reporting power of a DBMS.
This project caused me a lot of stress because I am one hundred percent a PC user. Unfortunately my computer decided to stop working a couple days ago and I was forced to restart the project using my roommates Mac. In order to start the project you must download the free 30 day trial of FileMaker Pro 11 database software. After following step by step to download this program I then had to download the "members.csv" file from the course website. This file contained all the data necessary to create the database project.
Step #1 was to create the Data Table. Step #2 was to change the form. The membership data was in the default tabular format and we were told to change it to a custom form that would make it more user-friendly. In step #3 I created a "Find". This allows you to automatically select only the records that meet the specified set of criteria, for example the Individual MemberType for this specific project. The last and final step was step #4 where I created The Report. The Report consisted of the reasons why certain gym members left and I had to create a convincing way to get the to return.
Copyright © 2010 FileMaker, Inc. All rights reserved
Enhancements
The main enhancement for this database project would be to expand on whether or not the customers stay or leave and why they choose to stay with the gym, no longer go to the gym, or switch to a different gym. Something else would be to show how much time a member stayed with the gym, from the time they signed up to the time they left. I would also look into those who left after a small amount of time and those who left after a long amount of time and compare it to the reason why they left. This would increase customer satisfaction because we would no when and why each customer left and what their future plan is, whether they plan to continue going to the gym, choose another gym or no longer be a member of any gym.
No comments:
Post a Comment