Design Of The Relational Database Structure

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 real-time number of bikes parked. Docking stations have computers running on them, a credit card reader, and a networking module that allows them 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. The 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 database.

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 to place an order?

Take a few steps to place an order on our site:

  • Fill out the form and state the deadline.
  • Calculate the price of your order and pay for it with your credit card.
  • When the order is placed, we select a suitable writer to complete it based on your requirements.
  • Stay in contact with the writer and discuss vital details of research.
  • Download a preview of the research paper. Satisfied with the outcome? Press “Approve.”

Feel secure when using our service

It's important for every customer to feel safe. Thus, at WritersABC, we take care of your security.

Financial security You can safely pay for your order using secure payment systems.
Personal security Any personal information about our customers is private. No other person can get access to it.
Academic security To deliver no-plagiarism samples, we use a specially-designed software to check every finished paper.
Web security This website is protected from illegal breaks. We constantly update our privacy management.

Get assistance with placing your order. Clarify any questions about our services. Contact our support team. They are available 24\7.

Still thinking about where to hire experienced authors and how to boost your grades? Place your order on our website and get help with any paper you need. We’ll meet your expectations.

Order now Get a quote