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.