Fitness Club Management System: Database Design and Implementation, Study Guides, Projects, Research of Database Management Systems (DBMS)

Download Fitness Club Management System: Database Design and Implementation and more Study Guides, Projects, Research Database Management Systems (DBMS) in PDF only on Docsity!

Computer

project

Name:-

Reg num:-

Topic:- GYM MANAGEMENT SYSTEM

SECTION 1 INTRODUCTION

1.1 Introduction to the Project

1.2 Objectives Of The Project

INTRODUCTION TO THE PROJECT This project is designed to facilitate a gymming and fitness center to automate its operations of keeping records and store them in form of a large and user friendly database further facilitating easy access to the personnel.

 What the Software Provides in this Regard?  The software is capable enough to allow the concerned person to store and retrieve any type of record with just a single click of mouse.The software allows Interactive ,Self decribing Graphic User Interface environment where even standalone users can work very comfortably and easily.  All the data pertaining to transactions or other important entities is kept at central database from where its attributes can be easily controlled.But,Such kind of technical details are hidden from the standalone User. He just needs to type in correct details of the given entity and then click the save button with the help of mouse.However,That central repository of data can be easily accessed if required.  Data Redundency is no more the problem now.The data modified from one particular data entry form will reflect the modifications at the other related forms too.This has thus reduced the chances of data inconsistency in our data storage.  There is no need to manage bulky registers now as data stored in the backend database can be radily retrieved either from the frontend form itself or directly from the database.  Requires one time investment of setting up required Hardware and Software after which no more headache is required by the Managers.Moreover,It also reduces dependence on Man Power.  Effective Search measures are present at each and every data transactional forms from where by just entering a Unique keyword for that data its whole records can be readily seen within microseconds.Moreover,Facillity of Updation and Deletion of data through search is also available.

SECTION 2 SYSTEM ANALYSIS

2.1 Identification Of The Need

2.2 Preliminary Investigation

2.3 Feasibility Study

2.3.1 Technical Feasibility

2.3.2 Economical Feasibility

2.3.3 Operational Feasibility

2.3.4 Behavioural Feasibility

2.4 Proposed System Functionality

The client set is just a worker(s),who is regularly indulged in manual maintainence transactions,keeping regular records,maintaining the records of fine details of members. Following manual registers are maintained:  Member’s Details Register: This Register is maintained in liu to maintain the records of the various members of the gymming center.The document contains relevant information about the various members such as members’s id, Name,Address,Telephone number.  Employee’s Details Register: This Register is maintained in liu to maintain the records of the various employees of the gymming center.The document contains relevant information about the various employees such as employee’s id, Name,Address,Telephone number.  Inventory Register: The register is used to record the details of the products(supplements,beverages and apparels supplied and required) such as its ID,Description,Quantity,Price,service date,time period for which it is under maintainence etc. 2.3 Feasibilty Study Depending on the results of the initial investigation, the survey is expanded to a more detailed feasibility study. Feasibility study is a test of system proposal according to its workability, impact on the organization, ability to meet user needs, and effective use of resources. The objective of the feasibility study is not to solve the problem but to acquire a sense of its scope. During the study, the problem definition is crystallized and aspects of the problem to be included in the system are determined. Consequently, costs and benefits are described with greater accuracy at this stage. It consists of the following:

1. Statement of the problem: A carefully worded statement of the problem that led to analysis**.

2. Summary of finding and recommendations:** A list of the major findings and recommendations of the study. It is ideal for the user who requires quick access to the results of the analysis of the system under study. Conclusion are stated , followed by a list of the recommendation and a justification for them**.
3. Details of findings :** An outline of the methods and procedures under-taken by the existing system, followed by coverage of the

objectives and procedures of the candidate system. Included are also discussions of output reports, file structures, and costs and benefits of the candidate system.

4. Recommendations and conclusions: Specific recommendations regarding the candidate system, including personnel assignments, costs, project schedules, and target dates. 2.3.1 Technical Feasibility Technical feasibility centers around the existing computer system (Hardware and Software etc) and to what extend it support the proposed addition. For example, if the current computer is operating at 80 percent capacity - an arbitrary ceiling - then running another application could overload the system or require additional Hardware. This involves financial considerations to accommodate technical enhancements. If the budgets is a serious constraint ,then the project is judged not feasible. In this project, all the necessary cautions have been taken care to make it technically feasible. Using a key the display of text/object is very fast. Also, the tools, operating system and programming language used in this localization process is compatible with the existing one. 2.3.2 Economical Feasibility Economic analysis is the most frequently used method for evaluating the effectiveness of the candidate system. More commonly known as cost/benefit analysis, the procedure is to be determining the benefits and savings that are expected from a candidate and compare them with costs. If benefits outweigh costs, then the decision is made to design and implement the system. A systems financial benefit must exceed the cost of developing that system. i.e. a new system being developed should be a good investment for the organization. Economic feasibility considers the following: i. The cost to conduct a full system investigation. ii. The cost of hardware and software for the class of application. iii. The benefits in the form of reduced cost or fewer costly errors. iv. The cost if nothing changes (i.e. The proposed system is not developed). The proposed SYSTEM is economically feasible because i. The system requires very less time factors.

2.4 Proposed System Functionality

The proposed system will be designed to support the following features:-  The proposed system has a user friendly Interface for porting of data to server.  The proposed system provides the facility to pull the data from the server using a key (such as id) and get the desired report.  The proposed system provides the no replication of data

SECTION 3 SOFTWARE ENGINEERING PARADIGM APPLIED

modules, whereas during detailed design the focus is on designing the logic for each of the modules. 3) Coding The goal of the coding phase is to translate the design of the system into code in a given programming language. Hence during coding, the focus should be on developing programs that are easy to read and understand, and not simply on developing programs that are easy to write. 4) Testing Testing is the major quality control measure used during software development. Its basic function is to detect errors in the software. Testing not only uncover errors introduced during coding, but also errors introduced during the previous phases. Thus, the goal of the testing is to uncover requirement, design and coding errors in the programs. Therefore, different levels of testing are used. Testing is an extremely critical and time consuming activity. It requires proper planning of the overall testing process. The output of the testing phase is the test report and the error report. Test report contains the set of test cases and the result of executing the code with these test cases. The error report describes the errors encountered and the action taken to remove the errors. 5) Implementation It is the process of having systems personnel check out and put new equipment into use, train users, install the new application and construct any files of data needed to use it. This phase is less creative than system design. Depending on the size of the organization that will be involved in using the application and the risk involved in its use, systems developers may choose to test the operation in only one area of the firm with only one or two persons. Sometimes, they will run both old and new system in parallel way to compares the results. Paradigm Applied In this project,The Spiral Model is applied in order to provide rigid efficiency and functionality in the overall working style of the project.Moreover, In order to cater to new or modified requirements of the user, Spiral model is very effective .I used “The Spiral model” as it is best suited to those development environments where probability of uncertainity is very high and chances of mistakes are uncontrollable.

What about Spiral Model?

The spiral model is a software development process combining elements of both design and prototyping-in-stages, in an effort to combine advantages of top-down and bottom-up concepts. Also

known as the spiral lifecycle model, it is a systems development method (SDM) used in information technology (IT). This model of development combines the features of the prototyping model and the waterfall model. The spiral model is intended for large, expensive and complicated projects. The steps in the spiral model can be generalized as follows:

1. The new system requirements are defined in as much detail as possible. This usually involves interviewing a number of users representing all the external or internal users and other aspects of the existing system.
2. A preliminary design is created for the new system.
3. A first prototype of the new system is constructed from the preliminary design. This is usually a scaled-down system, and represents an approximation of the characteristics of the final product.
4. A second prototype is evolved by a fourfold procedure:
   1. Evaluating the first prototype in terms of its strengths, weaknesses, and risks;
   2. Defining the requirements of the second prototype;
   3. Planning and designing the second prototype;

SECTION 4 Software Project Development Methodology

The Methodology:

I was assigned the duty for developing a computerized system for a fitness center. The project time and resources were very limited. The optimum use of practical time neccessiates that every session and every activity is planned. For effective Planning ,Efficient Project Managerial skils are required,Efficiant skills then trace out best methodology to be used. The methodology used by me includes the following things:  Topic Understanding: It is vital that the field of application as introduced in the project may be totally a new field. So as soon as the project was allocated to me, I carefully went through the project requirements to identify the requirements of the project.  Modular Break –Up Of The System:  Identify The Various Modules In The System.  List Them In The Right Hierarchy.  Identify Their Priority Of Development.

Different Modules In Computerised System

Modules – This project consists of different interfaces which will be accessed through a MDI (Multiple Document Interface) window. Different modules that makeup this system have already been a described in system analysis.  Module 1: Member’s Module In this module,Owner can see the membership details which includes:  MEMBER DETAILS i. Member id ii. Name iii. Gender  MEMBERSHIP DETAILS i. Membership type ii. Expiration date  MEMBERSHIP DETAILS i. Address ii. Date of birth iii. Phone number  ACCOUNT INFORMATION i. Due date ii. Amount Due