Database Project

               After completing the database project for ISM3004, I have learned that databases are an extremely effective tool for organizing and processing data and information.  Through the use of queries, you can run specific functions for gathering information without having to manually and painstakingly browse through several, in this case thousands, of pieces of data to quickly and efficiently make decisions and inferences about such data and information.  Also, through the use of forms, you can easily create, modify, and extract information about one particular field, such as an individual member in this project, in an indexed matter.  Finally, reports are a useful tool to effectively display and print data and information on specific fields and other parameters for personal or organizational use.

                To enhance functionality of this database, a few options pertaining to the creation of different queries would thoroughly enhance the overall usage of the database.  To begin, after being a personal trainer at a gym before, a query based upon the gender of the member might be a good idea to list as to create gender-specific workout plans and also to describe the goals of the individual members.  Also, creating a query based upon the type of membership in this case could easily provide information about the overall membership usage and perhaps even discounts available to family membership holders.  Queries are an awesome tool to be very specific about the type of information that you would like to be able to view and analyze in a very quick and effective manner.

                The addition of new reports may enhance the functionality of the database, as well.  Creating a report based on the city in which the members are located might offer information about the possibility of expanding the business to various other cities.  Also, reports on the frequency of new memberships based on date might suggest the overall allocation of resources, such as staff members available, during peak months or time periods in which membership signings are high.