Post Project
  • Search
    • Buyers can
    • Search offers to buy now
    • Search freelancers to request a proposal
    • Freelancers can
    • Search projects to quote on
  • How it works
  • Log in
  • Sign up
  • Freelancer?
Browse by Category
    Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media

    SQL database Queries for booking system

    - or -

    Post a project like this
    05/05/2015
    £300(approx. $368)
    • Posted: 8 years ago
    • Proposals: 14
    • Remote
    • #738860
    • Expired
    Bals S.
    Bals S.
    ASP.NET MVC Website, Web Application and Windows Application Development
    Top Endorsed
    India Chennai
    Vijendra Singh S.
    Vijendra Singh S.
    Development experience in ASP.NET | MVC | C# | NodeJs | WebAPI | Jquery | SQL Server | Stripe
    Top Endorsed
    India Delhi
    Co-Development (Hull) ltd ..
    Co-Development (Hull) ltd ..
    Microsoft Access Developer, Access Developer, Access Development, Access Database Developer, MS Access VBA Developer
    Top Endorsed
    France Paris
    Vijeet D.
    Vijeet D.
    Wordpress-Woocommerce/Python/React/PHP/Laravel/Node/ASP/Android-IOS
    Top Endorsed
    United States Bay Minette
    Philip R.
    Philip R.
    Senior Developer
    United Kingdom Halifax
    Adnan S.
    Adnan S.
    ASP.NET, C#, MVC, LINQ, MS-SQL, Javascript/JQuery
    Pakistan Islamabad
    Muhammad F.
    Muhammad F.
    Database & Software Developer
    Top Endorsed
    Pakistan Karachi
    Bhargav M.
    Bhargav M.
    Technology Consultant
    Top Endorsed
    Germany Dusseldorf
    Syed Zeeshan Haider S.
    Syed Zeeshan Haider S.
    Top Magento developer,Laravel, Vue.js, WordPress,angular, Node.JS Expert ( PHP Mysql ).Front-end: Angular, React, Vue . Framework: Laravel, Symfony, CodeIgniter, Yii, CakePHP, Zend, Slim
    Top Endorsed
    United States Dallas
    Rajeev B.
    Rajeev B.
    Web Developer
    India Delhi
    Inkey Solutions
    Inkey Solutions
    Dynamic CRM & Business Intelligence consultant
    India Surat
    John R.
    John R.
    IT Consultant and Developer
    Top Endorsed
    United Kingdom London
    • 1
    • 2
    256409624653323452696248621560122210723760513586815316916725589459364815
    Bals S.Vijendra Singh S.Co-Development (Hull) ltd ..Vijeet D.Philip R. + 9 others have already sent a proposal.
    • 3
    • 3

    Description

    Experience Level: Expert
    Estimated project duration: 1 - 2 weeks
    I am building a booking engine for a gym. The gym has multiple locations with opening hours and closures. Each gym will have one or multiple rooms which can hold one or multiple classes which have different operating hours and available slots.

    I need assistance with not only a database model (one exists but needs extending) as well as writing some stored procedures to get the available sessions and bookings for users.

    UPDATE:

    I have added my current database schema (this is a smaller version of the full database, but covers the major tables required for the queries.

    I will need to run through the database, and how i am currently storing different values in the database as well as the "nuances" that relate around the project. I have the requirement that I will be adding the concept of Studios and Classes to each location. Currently the database assumes one type of session for one gym (this is not a typical gym business). We will want to provide the ability that there are potentially multiple Studios in a Gym and multiple classes for each studio. Each of these classes will require different operating times for them to be running and also run for variable lengths.
    •  
    Chris P.
    Chris P.
    0% (0)
    Projects Completed
    -
    Freelancers worked with
    -
    Projects awarded
    0%
    Last project
    5 Feb 2023
    United Kingdom

    New Proposal

    Login to your account and send a proposal now to get this project.

    Log in

    Clarification Board Ask a Question

      There are no clarification messages.
    05/05/2015
    £300(approx. $368)

    - or -

    Post a project like this
    Chris P.
    Chris P.
    0% (0)
    Projects Completed
    -
    Freelancers worked with
    -
    Projects awarded
    0%
    Last project
    5 Feb 2023
    United Kingdom

    Related project Searches


    database modeling structured query language (sql) stored procedure development

    Product

    • About
    • Team
    • Careers

    Support

    • How it works
    • Trust & Safety
    • Help Centre

    Discover

    • GuidesStoriesNews

    Resources

    • Customer Stories
    • Business Cost Calculator
    • Startup Cities

    Browse

    • Freelance Services
    • Freelance Services By Country
    • Freelance Skills
    • Terms
    • Privacy
    • Sitemap
    • Company Details
    • © 2023 People Per Hour Ltd
    We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
    Cookie Settings
    Accept All Cookies