Telah Dianugerahkan

Database management mysql


Refer to the abridged data file “2013-07 - Citi Bike Trip [login to view URL]” ( will DM the data file) You are required to design and implement a relational database to help better manage the

CitiBike program in New York City.


1- Study the data provided for the use of Citi bikes to gain an understanding of the program utilization.

2- Explore the information on the program available on the Web to verify the basic facts and collect

additional information regarding the utilization of Citi Bikes. Write down the additional

information and/or requirements you gathered. Give the URLs for the sites contacted.

3- Draw an appropriate E/R diagram that satisfies the basic and additional facts, indicating, weak and

subclass entity sets, whenever exist, multiplicity of relationships, and the key, or keys, for each

entity set. Distinguish between the parts of the E/R diagram pertaining to the given and extra basic


4- Translate the E/R diagram in [3] to a relational database schema.

5- Specify a number of essential functional dependencies for each relation. Identify possible keys,

whenever exist, and the primary key and foreign keys for each relation.

6- Examine the database relations for possible BCNF and/or 3NF violations. Decompose the relations

as appropriate.


Create SQL expressions to break the data provided in the file into the following tables:

Stations(Id, Name, Latitude, Longitude)

Trips(StationId, MinTripDuration, MaxTripDuration, AvgTripDuration, NumberUsers)

UsageByDay(StationId, NumberUsersWeekday, NumberUsersWeekend)

UsageByGender(StationId, NumberMaleUsers, NumberFemaleUsers)

UsageByAge(StationId, NumberUsersUnder18, NumberUsers18To40, NumberUsersOver40)


1- Create appropriate SQL expressions to determine the most frequent trips between any two stations

by the day of the week.

2- Create appropriate SQL expressions to determine usage patterns by gender and age for any given


3- Create appropriate SQL expressions to identify any dormant or vacant bike stations.

4- Reconstruct the tables and recreate the SQL expressions above to include zip codes, hence allowing

for aggregation by area. Identify the area with the highest usage of the program. Note that zip


codes are not included in the data provided but may be related to the StationId by its Latitude and

Longitude. This could be part of your research and may require some coding!


Submit a written report that includes:

1- The complete E/R diagram and schema of the relational database fully specifying the given

requirements and any other requirements gathered. Identify all keys, foreign keys, functional

dependencies of the database relations.

2- SQL code that creates the tables’ structure.

3- SQL code that loads the data.

4- SQL code that answer the given queries.

5- Sample outputs for your SQL code.

6- Provide a narrative explaining the outputs produced whenever possible.

Kemahiran: MySQL, Pembangunan Pangkalan Data, Computer Science, Relational Databases, Database Design

Lihat lagi: php mysql relational database frontend, mysql relational database, biuld mysql relational database, forms relational database mysql, ffmpeg mysql database management, relational database integration asterisk mysql, database management mysql php html, convert xml relational database mysql, html php create mysql relational database retrieve form, school database management system php mysql, mysql database management tools, unity mysql database management, student database management system project in mysql, sql azure is a cloud-based relational database service that is based on mysql, mysql database management system, how to create relational database in mysql, real time database or firestore must be included to enable user profile, mysql database management system download, mysql database management system free download

Tentang Majikan:
( 0 ulasan ) The Bronx, United States

ID Projek: #30216121

4 pekerja bebas membida secara purata $146 untuk pekerjaan ini


Hello! I can help you with my best. I have done many projects using SQL, My SQL, Maria DB, MongoDB and PostgreSQL. I will do it in time perfectly. Lets discuss more detail in chat.

$120 USD dalam sehari
(0 Ulasan)

hey there greetings As a Oracle expert I am having more than 4 years of experience in developing and maintaining database design and implementation just ask me if you have any query with any doubt InshAllah

$45 USD dalam sehari
(0 Ulasan)

Dear client, I am a Mysql expert with 5+ years of experience. I have a lot of experience in function, procedure, trigger, foreign key, primary key, and etc,,,,,I have experience using mysql functions or procedures to r Lagi

$250 USD dalam 7 hari
(0 Ulasan)

Hello Sir, I am having more than 6 years of experience in Database Management. I am good at MYSQL and SQL SERVER. So I can help you with all matters you have and anytime feel free to contact me. Hope to work with you Lagi

$167 USD dalam 7 hari
(0 Ulasan)