New Orleans Fitness Center (NOFC) Introduction In 2022, John and Joan Smith opened the New Orleans...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
New Orleans Fitness Center (NOFC) Introduction In 2022, John and Joan Smith opened the New Orleans Fitness Center (NOFC) in New Orleans, Louisiana. This business was the culmination of a dream of the Smiths to open their own bealth and fitness business, after having worked in this industry for others for several years. As husband and wife, John and Joan have thoroughly enjoyed the opportunity to work together over the last five years in building a successful family business. NOFC is somewhat different than many other businesses in the personal fitness industry in that it is not simply a gymnasium facility stocked with exercise equipment for use by paying customers. Instead, the Smiths' business plan was to create a learning center that emphasized offering classes on fitness techniques and skills that could be learned by patrons from trained instructors. The fees paid by members of the center for these classes make up the largest of the three sources of revenue for the business. Another revenue source is the initial membership fee paid by center members upon joining NOFC. The other revenue source is the sale of fitness supplies in the store located in the center. This store carries both fitness clothing (e.g, work-out suits, sweat bands) and also utritional supplements (eg, vitamins, protein powder). As the business has grown and developed, John and Joan have found that the volume of paperwork associated with running the business has also substantially increased and has become very difficult to properly maintain. They are concerned that their business will not be able to successfully continue growing without a more timely and accurate means of maintaining the records of the business. This realization has led them to decide that the adoption of a computer- based record keeping system is their best interests. They have invited several system development consulting firms, including yours, to visit them to discuss their business needs and to propose an automated solution. They will review the proposed solutions from the competing consulting firms and will ultimately select one firm to develop and implement their final system. A systems analyst with your consulting firm has already conducted an initial interview with the Smiths and has provided the information contained below on NOFC. You and the other members of your consulting group will take this information and go forward with your plan for presenting the Smiths with a system solution that you hope will win their approval. Personnel NOFC employs a Aurbet of different types of employees: fitness courte instructors, clerks in the fitness store and administrative personnel. Records on each past and present employee of the company is maintained that include the employee name, address, phone number(s), hire date, position and status (current or former), Employees also have a unique sequential four-digit employee ID number assigned to them when they are originally hired. For clerks, NOFC would also like to record negotiated hourly rate. Payroll is presently outsourced to an accounting firm. This is expected to continue and will not be a part of the system to be developed. Members Of course, information is also recorded for members of NOFC. When joining the center, individuals have a unique sequential six-digit member ID assigned to them. Also recorded for each member is his or her name, address, phone number (home or cell), gender, age, date of birth and date of joining NOFC. Fitness Courses NOFC offers over thirty different personal fitness courses to its members. Courses include such exercise hased subjects as yoga, tai-chi, weight training and aerobics and also other fitness- oriented topics such as nutrition and natural medicine. Each fitness course instructor needs to be qualified to teach a course. Both John and Joan Smiths are experts in all subject matter taught at NOFC and are the judges of when an instructor is qualified to teach a course. The date a fitness course instructor qualifies for teaching a particular course needs to be recorded. A fitness course instructor can be qualified to teach many different courses or may not be qualified to teach any course. Each course has a unique course number assigned to it when it is created. Additional important information related to each course is the course name, description, category (3 categories - novice, intermediate and advanced), usual duration (number of weeks that a course is designed to be run) and fee (price of the course prior to discounts). There are no prerequisites, as such, for taking courses, but members are encouraged to take courses in logical progression, i.e., from novice to intermediate to advanced. Courses are offered periodically in the form of classes-a class is a specific offering of a course. Each class has an associated reference number, which is unique. Also recorded on the teaching schedule for each class is the start date for the class, the days of the week the class will be held (eg, M, M/WF, Th F), the time period that the class will be held and the instructor who will teach the class. Ismally the Smiths try to ensure that instructors who are qualified to teach a course are the ones who teach a class- but then it is not always possible to find a qualified instructor for each class. Each class is taught by exactly one fitness course instructor. Each fitness course instructor must teach at least one class and could teach many classes. Each class is allocated exactly one room. Facilities and Equipment Each room in the center has a unique sequential room number and a class capacity associated with it. The latter is the maximum number of members that can participate in a class being held in that room. This number is important in preventing classes from being overenrolled. Some of the rooms in the center contain pieces of exercise equipment, which are not moved across the rooms. Each such piece of equipment has a unique serial number (provided by the manufacturer) that is used to track it in the center. Also recorded for each piece are its purchase date and the date of its last maintenance. Each piece of equipment belongs to a specific equipment type; for example, the equipment type of "Healshades, R60" is treadmill. Merchandise Sales As mentioned earlier, NOFC also maintains an in-center store for the sale of merchandise to members. The items for sale in the store are identified by a unique item number. Also recorded for each item is its description, standard price (price before discount), the quantity on hand and the reorder point. Reander point is the minimum quantity of an item that should be kept on hand. If an item's inventory level falls below this point, the item is noted for reorder from the vendor that supplies it Whenever a NOFC member comes into the store and purchases one or more items, a unique seven-digit order number is generated; note that only NOFC members can make a purchase. The member making the purchase and the date of transaction are also recorded. Of course, the specific items purchased, along with the quantity of each item and the selling price per unit of each item is also recorded. The overall purchase total is also calculated for each order. Conclusion The Smiths need to keep track of various activities in the store and would like you to ensure that the following reports can be generated. They want to know the total number of members enrolled in each class, the most popular course (ie, a course with the most number of offered classes and most number of enrolled members), and the different courses that each facility course instructor is qualified to teach. Many times, a scheduled employee may not turn up for work. In order schedule a backup, the Smiths would like to find all the employees (employee name) who live in a locality with a certain zip code, usually the same as that of the NOFC. The Smiths are optimistic that a well-designed database system will substantially improve their business processes. They are depending on you to analyze their business to identify areas that can benefit from such system and to design and develop the system itself. They have promised to work closely with you and to provide full support in the development process. You and your team are excited at the prospect of undertaking this challenge. Things to complete: 2.1 CONCEPTUAL DESIGN 2.2 LOGICAL DESIGN 2.3 PHYSICAL DESIGN 3 IMPLEMENTATION OF THE DATABASE 4 USER INTERFACE 4.1 DESIGN 4.2 IMPLEMENTATION 4.2.1 Reports 4.2.2 Forms New Orleans Fitness Center (NOFC) Introduction In 2022, John and Joan Smith opened the New Orleans Fitness Center (NOFC) in New Orleans, Louisiana. This business was the culmination of a dream of the Smiths to open their own bealth and fitness business, after having worked in this industry for others for several years. As husband and wife, John and Joan have thoroughly enjoyed the opportunity to work together over the last five years in building a successful family business. NOFC is somewhat different than many other businesses in the personal fitness industry in that it is not simply a gymnasium facility stocked with exercise equipment for use by paying customers. Instead, the Smiths' business plan was to create a learning center that emphasized offering classes on fitness techniques and skills that could be learned by patrons from trained instructors. The fees paid by members of the center for these classes make up the largest of the three sources of revenue for the business. Another revenue source is the initial membership fee paid by center members upon joining NOFC. The other revenue source is the sale of fitness supplies in the store located in the center. This store carries both fitness clothing (e.g, work-out suits, sweat bands) and also utritional supplements (eg, vitamins, protein powder). As the business has grown and developed, John and Joan have found that the volume of paperwork associated with running the business has also substantially increased and has become very difficult to properly maintain. They are concerned that their business will not be able to successfully continue growing without a more timely and accurate means of maintaining the records of the business. This realization has led them to decide that the adoption of a computer- based record keeping system is their best interests. They have invited several system development consulting firms, including yours, to visit them to discuss their business needs and to propose an automated solution. They will review the proposed solutions from the competing consulting firms and will ultimately select one firm to develop and implement their final system. A systems analyst with your consulting firm has already conducted an initial interview with the Smiths and has provided the information contained below on NOFC. You and the other members of your consulting group will take this information and go forward with your plan for presenting the Smiths with a system solution that you hope will win their approval. Personnel NOFC employs a Aurbet of different types of employees: fitness courte instructors, clerks in the fitness store and administrative personnel. Records on each past and present employee of the company is maintained that include the employee name, address, phone number(s), hire date, position and status (current or former), Employees also have a unique sequential four-digit employee ID number assigned to them when they are originally hired. For clerks, NOFC would also like to record negotiated hourly rate. Payroll is presently outsourced to an accounting firm. This is expected to continue and will not be a part of the system to be developed. Members Of course, information is also recorded for members of NOFC. When joining the center, individuals have a unique sequential six-digit member ID assigned to them. Also recorded for each member is his or her name, address, phone number (home or cell), gender, age, date of birth and date of joining NOFC. Fitness Courses NOFC offers over thirty different personal fitness courses to its members. Courses include such exercise hased subjects as yoga, tai-chi, weight training and aerobics and also other fitness- oriented topics such as nutrition and natural medicine. Each fitness course instructor needs to be qualified to teach a course. Both John and Joan Smiths are experts in all subject matter taught at NOFC and are the judges of when an instructor is qualified to teach a course. The date a fitness course instructor qualifies for teaching a particular course needs to be recorded. A fitness course instructor can be qualified to teach many different courses or may not be qualified to teach any course. Each course has a unique course number assigned to it when it is created. Additional important information related to each course is the course name, description, category (3 categories - novice, intermediate and advanced), usual duration (number of weeks that a course is designed to be run) and fee (price of the course prior to discounts). There are no prerequisites, as such, for taking courses, but members are encouraged to take courses in logical progression, i.e., from novice to intermediate to advanced. Courses are offered periodically in the form of classes-a class is a specific offering of a course. Each class has an associated reference number, which is unique. Also recorded on the teaching schedule for each class is the start date for the class, the days of the week the class will be held (eg, M, M/WF, Th F), the time period that the class will be held and the instructor who will teach the class. Ismally the Smiths try to ensure that instructors who are qualified to teach a course are the ones who teach a class- but then it is not always possible to find a qualified instructor for each class. Each class is taught by exactly one fitness course instructor. Each fitness course instructor must teach at least one class and could teach many classes. Each class is allocated exactly one room. Facilities and Equipment Each room in the center has a unique sequential room number and a class capacity associated with it. The latter is the maximum number of members that can participate in a class being held in that room. This number is important in preventing classes from being overenrolled. Some of the rooms in the center contain pieces of exercise equipment, which are not moved across the rooms. Each such piece of equipment has a unique serial number (provided by the manufacturer) that is used to track it in the center. Also recorded for each piece are its purchase date and the date of its last maintenance. Each piece of equipment belongs to a specific equipment type; for example, the equipment type of "Healshades, R60" is treadmill. Merchandise Sales As mentioned earlier, NOFC also maintains an in-center store for the sale of merchandise to members. The items for sale in the store are identified by a unique item number. Also recorded for each item is its description, standard price (price before discount), the quantity on hand and the reorder point. Reander point is the minimum quantity of an item that should be kept on hand. If an item's inventory level falls below this point, the item is noted for reorder from the vendor that supplies it Whenever a NOFC member comes into the store and purchases one or more items, a unique seven-digit order number is generated; note that only NOFC members can make a purchase. The member making the purchase and the date of transaction are also recorded. Of course, the specific items purchased, along with the quantity of each item and the selling price per unit of each item is also recorded. The overall purchase total is also calculated for each order. Conclusion The Smiths need to keep track of various activities in the store and would like you to ensure that the following reports can be generated. They want to know the total number of members enrolled in each class, the most popular course (ie, a course with the most number of offered classes and most number of enrolled members), and the different courses that each facility course instructor is qualified to teach. Many times, a scheduled employee may not turn up for work. In order schedule a backup, the Smiths would like to find all the employees (employee name) who live in a locality with a certain zip code, usually the same as that of the NOFC. The Smiths are optimistic that a well-designed database system will substantially improve their business processes. They are depending on you to analyze their business to identify areas that can benefit from such system and to design and develop the system itself. They have promised to work closely with you and to provide full support in the development process. You and your team are excited at the prospect of undertaking this challenge. Things to complete: 2.1 CONCEPTUAL DESIGN 2.2 LOGICAL DESIGN 2.3 PHYSICAL DESIGN 3 IMPLEMENTATION OF THE DATABASE 4 USER INTERFACE 4.1 DESIGN 4.2 IMPLEMENTATION 4.2.1 Reports 4.2.2 Forms
Expert Answer:
Related Book For
Posted Date:
Students also viewed these databases questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Craps is a dice game in which two fair dice are cast. If the roller shoots a 7 or 11 on the rst roll, he or she wins. If the roller shoots a 2, 3, or 12 on the rst roll, he or she loses. (a) Compute...
-
It was a dark and stormy night, when suddenly you saw a flash of lightning. Six and a half seconds later you heard the thunder. Given that the speed of sound in air is about 340 m/s, how far away was...
-
Fit Fixtures Incorporated (FFI) is a manufacturer of exercise equipment such as treadmills, stair climbers, and elliptical machines. The company has a December 31 year end and uses ASPE. The...
-
A certain random process \(U(t)\) takes on equally probable values +1 or 0 with changes occurring randomly in time. The probability that \(n\) changes occur in time \(\tau\) is known to be \[...
-
Would a court be likely to decide that the transaction between Holcomb and TCG was covered by the Uniform Commercial Code (UCC)? Why or why not?
-
A 79.0 kg person is riding a bike on a level horizontal street. Together, the bike and person have a mass of 90.1 kg and a speed of 3.00 m/s. The person jumps off the bike, and just after the jump...
-
Bennett et al. (2003) measured the refractive index (RI) of a pane of glass at 49 di erent locations. She took a sample of 10 fragments at each location and determined the RI for each. The data from...
-
1. The order is for 400mcg of thyroxin. The label reads 0.2 mg tablets. How many tablets would you give? 2. Mrs. N is taking Motrin 600mg PO q6hr around the clock for joint pain. How many grams of...
-
You are planning to manufacture a new high tech toaster. It will cost you $3 million to develop and you plan to manufacture for three years with straight line depreciation to zero. Due to the rapidly...
-
5) Calculate the steady state response, x(t), of the system with the overall transfer function to given below to a sinusoidal input y(t)= 0.8* sin(5*t) . (15P) S X(s) Y(s) 0.2s+1 T(s)=-
-
1. The government wishes to stimulate the economy and considers the following tax policy change: firms would receive a subsidy 7 in the current period for each unit of output produced. Current...
-
Why are used goods, financial assets, and government assets not counted as GDP expenditures? A few years ago BP experienced a well explosion in the Gulf of Mexico that resulted in massive amounts of...
-
2. Consider the following stress state 1- - 0 0 00 00 1]... where do is some stress value and a is a dimensionless parameter a (0, 1). (a) Calculate the principal invariants of the stress tensor: I =...
-
A boy walks 4.0m East and 3.0 m North. What is his resultant displacement vector? 5.0 m, 37 deg N of E 5.0 m, 37 deg E of N 5.0 m, 37 deg N of W 5.0 m, 37 deg W of N
-
Which internal control principle is especially diffi cult for small organizations to implement? Why?
-
You invested a total of $12,000 at 4 1/2% and 5% simple interest. During one year, the two accounts earned $580. How much did you invest in each account?
-
Use a determinant to find an equation of the line passing through the points. 1. (0, 0), (5, 3) 2. (0, 0), (2, 2) 3. (4, 3), (2, 1) 4. (10, 7), (2, 7)
-
The number of bacteria in a culture is increasing according to the law of exponential growth. The initial population is 250 bacteria, and the population after 10 hours is double the population after...
-
Why is macroeconomic forecasting so difficult? Does this difficulty mean economics is a worthless field of study?
-
Which of the following statements are positive in nature and which are normative? a. A tax cut will raise interest rates. b. A reduction in the payroll tax would primarily benefit poor and...
-
a. Calculate the total percentage growth in average labor productivity in the U.S. economy for the 1950s, 1960s, 1970s, 1980s, 1990s, and 2000s. Define average labor productivity for any year as real...
Study smarter with the SolutionInn App