Question

You are to advise a local fitness center on how to exploit their relational database in order to achieve a competitive advantage. What advice would you provide? Identify and describe three basic operations that will be used to extract useful sets of data from the relational database.

Answer 1

If I have to advise a local fitness center on how to exploit their relational database to achieve competitive advantage, I will advise them to collate their customer data collected with different information like the demographics, the duration of membership, the statistics of the customers at the time of joining and the results achieved by the customers during their membership and various services availed by the members.

This type of relational database can help the fitness center to analyse the various trends and patterns of customer behaviour at the local fitness center. The three basic operations that will be used to extract useful sets of data from the relational database can be listed as below :-

1. Identify and select the relevant information from the data sets and compile in a table form as per the given criteria.

2. Combine different subsets of information for more information through relational database.

3. Create subsets of information and data in columns of the tables with required information

With help of collecting a database and analysis, the fitness center can identify the relevant information for further business growth and planning and develop relationships with customers offering them more customized packages and services.