Chat with us, powered by LiveChat BUSINESS CASE A healthy lifestyle advocacy group is aiming to build a bike sharing system within a medium size metropolit | WriteDen

BUSINESS CASE A healthy lifestyle advocacy group is aiming to build a bike sharing system within a medium size metropolit

 BUSINESS CASE
A healthy lifestyle advocacy group is aiming to build a bike sharing system within a medium size
metropolitan area. The group has signed a contract with a company to provide the bike sharing
technology and hardware (bike stations, bikes, network equipment, a server, and bike sharing software that automates the process of checking out and returning bicycles, and billing customers).
DOCKING STATIONS & BIKES
The docking station provides a limited number of bike parking spots, and is characterized by its location, bike capacity, and by real time number of bikes parked. Docking stations have computers running on them, credit card reader, and a networking module which allows it to be connected to the Internet. The fleet of bikes has also been purchased.
FUNCTIONING OF THE SYSTEM
There are two ways a user can get access to the system:
1) Using her annual subscription ($70)
2) Buying day pass ($5)
Every ride under 30 minutes is free. User is charged $1 dollar for a ride between 30 and 1 hour, 3 dollars for rides between 1 hour and 2 hours and a flat rate of 7 dollars for any ride over 2 hours. The users who haven’t returned a bike within 10 hours are billed with a $50 fine. 

  

Design of the Relational Database Structure

Data in IS can be stored in the database. Relational databases is the most commonly used type of databases.

Directions

Submit the following information in a Word document: 

1. Create a table(s) to describe current and historical rides;

2. Write SQL statements that would perform the following tasks:

· Compute the average ride duration for a given user;

· Compute the number of bikes checked out at the given bike station;

Retrieve the list of all currently active users. 

    HOW OUR WEBSITE WORKS

    Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of 
    HIGH QUALITY & PLAGIARISM FREE.

    Step 1

    To make an Order you only need to click ORDER NOW and we will direct you to our Order Page at WriteDen. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
     Deadline range from 6 hours to 30 days.

    Step 2

    Once done with writing your paper we will upload it to your account on our website and also forward a copy to your email.

    Step 3
    Upon receiving your paper, review it and if any changes are needed contact us immediately. We offer unlimited revisions at no extra cost.

    Is it Safe to use our services?
    We never resell papers on this site. Meaning after your purchase you will get an original copy of your assignment and you have all the rights to use the paper.

    Discounts

    Our price ranges from $8-$14 per page. If you are short of Budget, contact our Live Support for a Discount Code. All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.

    Please note we do not have prewritten answers. We need some time to prepare a perfect essay for you.