Type here to search Hardbody Fitness Center Hardbody Fitness Center is a well-established fitness facility located...

  
 
 
 

Transcribed Image Text:

Type here to search Hardbody Fitness Center Hardbody Fitness Center is a well-established fitness facility located in a busy metropolitan area. The fitness center offers a wide range of services, including various exercise classes personal training sessions, state-of-the-art gym equipment, and wellness programs. With a diverse membership base, Hardbody Fitness Center aims to help its clients achieve their fitness and wellness goals. Major Activities Eitness Classes Hardbody Fitness Center offers a variety of group fitness classes such as yoga, spinning, HIIT, Zumba, and strength training. These classes cater to individuals with different fitness preferences and levels. Personal Training Certified personal trainers provide one-on-one coaching and personalized workout plans to assist members in achieving their fitness objectives. om Eacilities The center boasts a well-equipped gym area with cardio machines, weightlifting equipment, and designated areas for functional training. Nutrition and Wellness Hardbody Fitness Center provides nutrition consultations and wellness programs to help members adopt a healthy lifestyle, including diet planning and stress management. Membership Management The fitness center handles a substantial mumber of members with varying membership types, subscription plans, and payment schedules Scheduling and Booking Members book fitness classes and personal training sessions, and the center must manage schedules efficiently Need for a New Database Hardbody Fitness Center currently relies Introducing pageless forma The pageless format allows you to add wide tables, and view documents without the inter breaks. You can change the format for any on documents from File Page setup Leam m OF Need for a New Database: Hardbody Fitness Center currently relies on outdated and fragmented systems for managing its operations. These systems include paper-based records, standalone spreadsheets, and disparate software tools for scheduling, member management, and financial tracking. These methods have several drawbacks: Inefficiency: The current systems are time-consuming and error-prone. Managing scheduling and membership information across multiple platforms is labor-intensive, leading to scheduling conflicts, billing errors, and member frustration. Limited Reporting The lack of a centralized database makes it difficult to generate comprehensive reports on membership statistics, class attendance, or revenue. This hampers the management's ability to make data-driven decisions. Member Experience The suboptimal management system negatively impacts the member experience, causing inconvenience when booking classes, updating personal information, or accessing billing details. Security and Data Integrity Storing sensitive member information in disparate systems poses a security risk Maintaining data integrity and ensuring compliance with data protection regulations are ongoing challenges. To address these issues and improve overall efficiency, member satisfaction, and business performance, Hardbody Fitness Center recognizes the necessity of creating a new database system. This modern database will integrate membership management, scheduling, financial tracking, and reporting functions into a centralized, secure, and user-friendly platform, ultimately enhancing the organization's ability to serve its members and grow its business. orate INSTRUCTIONS Your INLT 290 project will be to build a database application for a real-world company of your choosing You will design a schema on paper. Then, you will create an actual database using Microsoft access or Microsoft SQL Server 2014 You will populate the database, write interactive queries and modifications on the database, develop programs that manipulate the database, and create reports and forms Examples of projects can be database management applications for Hotel, Hospital, Real Estate Company, Bank, Auto Dealer, Transportation Company, Electronics Store, Post Office, Police Station, Restaurant, Part 1: Choose a project and provide an Overview. (10% of grade) 1. Your first step is to identify the company/project you would like to manage with your database 2 Write an overview of the company organization that includes a brief summary of its major activities 3. Discuss why the organization needs to create a new database Part 2: Conceptual Design (Read Lecture 2) (10%) Identify the major entities and attributes of your database. You need to have at least five entities Construct on Entity Relationship diagram for the database. At least one of the relationships should be many to many Use the FIRST attached diagram as an old RD Sampdoo Report REGION Located RegonName STORE Stone REGION RegionID RegionName STORE Product StorelD Store Zip RegionID (PK) NoOftems Occurred ProductPrice PRODUCT Solva SALES TRANSACTION Tat Product Name PRODUCT ProductID ProductName ProductPrice Relational schema: Retail Company Sales Department Database VendorID (K) CategoryID (FK) SOLDVIA ProductID ) TID (PK) NoOfitems SALESTRANSACTION Supptelly TID TDate StorelD (K) Customer ID (FK) Belongs to Buyvia Vendor Category t Customer Vendorfiame VENDOR CATEGORY CategoryName Customerhame Customer CUSTOMER VENDOR VendorID VendorName CATEGORY CategoryID CategoryName CUSTOMER Customer1D CustomerName Customer Zip I Type here to search Hardbody Fitness Center Hardbody Fitness Center is a well-established fitness facility located in a busy metropolitan area. The fitness center offers a wide range of services, including various exercise classes personal training sessions, state-of-the-art gym equipment, and wellness programs. With a diverse membership base, Hardbody Fitness Center aims to help its clients achieve their fitness and wellness goals. Major Activities Eitness Classes Hardbody Fitness Center offers a variety of group fitness classes such as yoga, spinning, HIIT, Zumba, and strength training. These classes cater to individuals with different fitness preferences and levels. Personal Training Certified personal trainers provide one-on-one coaching and personalized workout plans to assist members in achieving their fitness objectives. om Eacilities The center boasts a well-equipped gym area with cardio machines, weightlifting equipment, and designated areas for functional training. Nutrition and Wellness Hardbody Fitness Center provides nutrition consultations and wellness programs to help members adopt a healthy lifestyle, including diet planning and stress management. Membership Management The fitness center handles a substantial mumber of members with varying membership types, subscription plans, and payment schedules Scheduling and Booking Members book fitness classes and personal training sessions, and the center must manage schedules efficiently Need for a New Database Hardbody Fitness Center currently relies Introducing pageless forma The pageless format allows you to add wide tables, and view documents without the inter breaks. You can change the format for any on documents from File Page setup Leam m OF Need for a New Database: Hardbody Fitness Center currently relies on outdated and fragmented systems for managing its operations. These systems include paper-based records, standalone spreadsheets, and disparate software tools for scheduling, member management, and financial tracking. These methods have several drawbacks: Inefficiency: The current systems are time-consuming and error-prone. Managing scheduling and membership information across multiple platforms is labor-intensive, leading to scheduling conflicts, billing errors, and member frustration. Limited Reporting The lack of a centralized database makes it difficult to generate comprehensive reports on membership statistics, class attendance, or revenue. This hampers the management's ability to make data-driven decisions. Member Experience The suboptimal management system negatively impacts the member experience, causing inconvenience when booking classes, updating personal information, or accessing billing details. Security and Data Integrity Storing sensitive member information in disparate systems poses a security risk Maintaining data integrity and ensuring compliance with data protection regulations are ongoing challenges. To address these issues and improve overall efficiency, member satisfaction, and business performance, Hardbody Fitness Center recognizes the necessity of creating a new database system. This modern database will integrate membership management, scheduling, financial tracking, and reporting functions into a centralized, secure, and user-friendly platform, ultimately enhancing the organization's ability to serve its members and grow its business. orate INSTRUCTIONS Your INLT 290 project will be to build a database application for a real-world company of your choosing You will design a schema on paper. Then, you will create an actual database using Microsoft access or Microsoft SQL Server 2014 You will populate the database, write interactive queries and modifications on the database, develop programs that manipulate the database, and create reports and forms Examples of projects can be database management applications for Hotel, Hospital, Real Estate Company, Bank, Auto Dealer, Transportation Company, Electronics Store, Post Office, Police Station, Restaurant, Part 1: Choose a project and provide an Overview. (10% of grade) 1. Your first step is to identify the company/project you would like to manage with your database 2 Write an overview of the company organization that includes a brief summary of its major activities 3. Discuss why the organization needs to create a new database Part 2: Conceptual Design (Read Lecture 2) (10%) Identify the major entities and attributes of your database. You need to have at least five entities Construct on Entity Relationship diagram for the database. At least one of the relationships should be many to many Use the FIRST attached diagram as an old RD Sampdoo Report REGION Located RegonName STORE Stone REGION RegionID RegionName STORE Product StorelD Store Zip RegionID (PK) NoOftems Occurred ProductPrice PRODUCT Solva SALES TRANSACTION Tat Product Name PRODUCT ProductID ProductName ProductPrice Relational schema: Retail Company Sales Department Database VendorID (K) CategoryID (FK) SOLDVIA ProductID ) TID (PK) NoOfitems SALESTRANSACTION Supptelly TID TDate StorelD (K) Customer ID (FK) Belongs to Buyvia Vendor Category t Customer Vendorfiame VENDOR CATEGORY CategoryName Customerhame Customer CUSTOMER VENDOR VendorID VendorName CATEGORY CategoryID CategoryName CUSTOMER Customer1D CustomerName Customer Zip I