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