Module 2 Project

Project Overview Document

Student Name

Institutional Affiliations

Functional Requirements

Considering the needs of the project, it is important to develop a system which meets the needs and demands of the Greta's Gym and team processes. The aim of the database system is to develop a system which helps to accommodate and increase the necessary communication between the gym processes and team. The gym database should be able to hold new information such as gym memberships and members. This will help in processing payrolls and holding classes. There is also the need for developing a system with the help of implementing the necessary resources to meet and improve different operations between the gym processes. The database should also be able to contain information such as on manager and class sessions offered by the database. This will increase and improve the control, security and accessibility of information and details, the gym team should also consider developing the gym database with registration details and viewing the already registered members. This will help in allocation of gym rooms to host different activities and sessions. The aim of this is to improve the relocation and management of the gym services with focus on operations and implementation of the necessary operations.

Database System

The database system to apply in developing the gym database is a relational database system. A relational database will offer the easier way of coordinating the necessary services of the database. This will help in improving the value, resources and how to effectively increase the services of the database and gym processes. For instance, the database main entities include: Classes, Rooms, instructors and Staff, customers, and equipment. To develop such a database takes into consideration the relationship between the classes offered, where allocated and how is the instructor under supervision from gym staff. The database system in a relational architecture will be able to help the gym team to control information, access information based on the need to know basis and fully integrate the consumer information into the database of the Greta Gym. Also of importance is sorting and linking information from one database to another table. It improves information readability, retrieval and updating of data. This system will the gym to maintain, store, retrieve and update data since it is easy to use and apply. It does not require a skilled and trained user to run the system since it applies the constraints and rules of a database schemas.

Database System Logical View: Current and Future Processes

customerCustomer Registration Customer DetailsCustomerUpdates customer dataMembershipUpdates Customer dataRetrieval of information Data retrievalRooms DetailsCustomer DetailsStaff DetailsCustomer detailsEquipmentCustomer detailsRooms awarded a certain Instructor Rooms have certain equipmentClasses OfferedRoom DetailsRoom EquipmentsCustomer Class DetailsBorrowed and Assigned Equipments

References

Elmasri, R. (2008). Fundamentals Of Database Systems. Pearson Education India.

Holtzblatt, K., & Beyer, H. R. (1995). Requirements Gathering: The Human Factor. Communications Of The ACM, 38(5), 31-32.

Kuhn, K. (2000). Problems and Benefits of Requirements Gathering With Focus Groups: A Case Study. International Journal of Human-Computer Interaction, 12(3-4), 309-325.

customer Customer Registration Customer Details Customer Updates customer data Membership Updates Customer data Retrieval of information Data retrieval Rooms Details Customer Details Staff Details Customer details Equipment Customer details Rooms awarded a certain Instructor Rooms have certain equipment Classes Offered Room Details Room Equipments Customer Class Details Borrowed and Assigned Equipments