Sa Fitness

Good Essays
You have been hired by the San Antonio Fitness company (better known as SA Fitness) located in San Antonio, Texas, to develop a working database system to better track their clients, trainers, workouts, and personal training.
SA Fitness offers several types of membership plans to accommodate anyone’s needs. A membership plan has the beginning date, an initiation fee, a monthly fee, a duration (number of months in the plan contract), and a personal training fee.
Once a person signs up for a membership plan, that person is called a “client”. Clients must be enrolled in exactly one plan, but a plan may enroll several clients. Information to be stored in the database about each client include the client’s name, address, height (feet and inches), and weight (in pounds).
SA Fitness employs several trainers who conduct the workout sessions for the clients. Each trainer has a unique id, a first and last name, and salary. A trainer may conduct multiple workout sessions, however, each workout session is conducted by exactly one trainer.
Workouts are specialized into two categories: group classes and personal training. All workout sessions have a unique workout number, a length of time in minutes, and a Day/Time, which gives the day of the week and the time of day (‘Wednesday 9:00 a.m.’, for example). Group classes have a class name, and the number of calories that are normally burned by participating in the class. A personal training session is limited to just one client, and therefore SA Fitness needs to indicate the training goals of the session.
Clients may choose to participate in as many group classes or personal training sessions as they like. SA Fitness doesn’t keep track of which clients attend which group classes, however personal training sessions are customized for the client. Therefore we need to know which client meets with one of the trainers for the personal training session. Each client may participate in zero or more personal training

You May Also Find These Documents Helpful

  • Good Essays

    Sa Sa Case Study

    • 950 Words
    • 4 Pages

    Founded in 1978, Sa Sa has grown from a 40 sq. ft. retail space to become today's regional "beauty". According to the "Retail Asia-Pacific Top 500" ranking of Retail Asia magazine and Euromonitor in 2014 the Sa Sa holdings is a topmost company in the Hong Kong. As one of the largest sole agents in cosmetics in Hong Kong, Sa Sa represents over 100 international beauty brands in Asia. Sa Sa prospers on its successful and proven "one-stop cosmetics specialty store" concept, offering customers with…

    • 950 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Sa Sa China Analysis

    • 2344 Words
    • 10 Pages

    Introducing the Sa Sa International Holding Limited (China) Sa Sa International Holding Limited, a Hong Kong leading cosmetics retailing group in Asia. Sa Sa has approximately 220 stores and retail counters across different regions in Asia. Together with it owns brand and other international brands; Sa Sa offered over 600 brands of skin care, and fragrance, make-up and hair care products. In 2005, in order to track the fast growing trend of China Cosmetic industry, Sa Sa International Holding Limited…

    • 2344 Words
    • 10 Pages
    Good Essays
  • Good Essays

    Fitness

    • 295 Words
    • 2 Pages

    or girl. While others exercise to lead a healthier lifestyle. Whatever the motivation is for working out there are certain basic concepts of fitness that should be thoroughly understood before beginning any type of physical activity. There are three basic divisions of fitness: Health Fitness, Motor-performance Fitness, and Cosmetic Fitness. “ Health Fitness is important for the prevention and remediation of hypokenetic diseases, … also focuses on strength and flexibility.” ( Siedentop…

    • 295 Words
    • 2 Pages
    Good Essays
  • Good Essays

    fitness

    • 840 Words
    • 4 Pages

    Physical Fitness and Nutrition Worksheet In order to obtain optimal health, it is critical to be physically fit and eat a healthy and balanced diet. Becoming knowledgeable about what it means to be physically fit and learning how to evaluate the nutritional value of what you eat may greatly increase your ability to improve your health and wellness. In this three-part worksheet, you identify the five components of health related fitness, critique a recipe for nutritional value, and respond to…

    • 840 Words
    • 4 Pages
    Good Essays
  • Better Essays

    Fitness

    • 1069 Words
    • 5 Pages

    Exercise for Health and Fitness Some people think that being physically fit means being in good general health. Other people think it means being able to lift a certain amount of weight or being able to run a particular distance in a certain time. There’s actually no single agreed upon definition of physical fitness. One common definition is that physical fitness is a set of attributes that people have or achieve relating to their ability to perform physical activity. Another common definition…

    • 1069 Words
    • 5 Pages
    Better Essays
  • Satisfactory Essays

    Fitness

    • 660 Words
    • 3 Pages

    Rose Esther Marcelin 22/04/14. Fitness and Walking Final Learning Outcome A big thing that I have learned in this call is the health of walking. The walks we went on I enjoyed very much. I learned many things in this class. I learned about strength, limitations, weaknesses, I loved the different paths and routes we walked even though some of them were hard at times. The main things that we were to be taught and learn in this class were know proper fitness walking techniques, knowing the…

    • 660 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Fitness

    • 683 Words
    • 3 Pages

    Demi Carter WRIT 110 November 19, 2012 Alim-Young Fitness Trainer What does it mean to be a fitness trainer? What does it involve? Does fitness training simply involve a love of exercise and the satisfaction gained from teaching others to do the same? These are kinds of questions that a fitness trainer should be able to answer. According to Ferguson’s Career Guide, a fitness trainer is a coach and a teacher who blends motivation, the right amount of program supervision, and appropriate exercise…

    • 683 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Fitness

    • 671 Words
    • 3 Pages

    Physical fitness has been defined as a set of attributes or characteristics that people have or achieve that relates to the ability to perform physical activity.The above definition from Physical Activity and Health: A Report of the Surgeon General is the most common currently used definition of physical fitness. It was originally used by Caspersen and has been used extensively. An alternative definition by Howley and Frank that provides additional descriptive information is: Physical fitness is a state…

    • 671 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    history of sas

    • 612 Words
    • 3 Pages

    SAS History SAS was founded in 1976 to help a wide range of customers, from pharmaceutical companies and banks to academic and governmental entities. SAS originally emerged as a program called the Statistical Analysis System. The program was developed in 1966 at North Carolina State University under a grant from the National Institutes of Health to analyze vast amounts of agricultural data collected through the United States Department of Agriculture. The early leaders of the project were NCSU…

    • 612 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Sa Pula Sa Puti

    • 3903 Words
    • 14 Pages

    SA PULA, SA PUTI Francisco "Soc" Rodrigo About the Author Francisco had a colorful career as politician, poet, playwright, essayist and nationalist. He is popular for his caustic comments on current events, which he writes in both English and Filipino. He is one of the foremost exponents of nationalism and was one of the writers censored and detained during the Marcos regime. He was also one of the youngest to be elected Philippine senator. CHARACTERS Kulas, an out-and-out sabungero, or cockfighting…

    • 3903 Words
    • 14 Pages
    Satisfactory Essays