En cours

Creating and manipulating data base using mySQL -- 4


You will need to answer all of the questions accordingly and please use MySQL workbench.

Refer to the abridged data file “2013-07 - Citi Bike Trip Data” (I will give you the data file later) 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!


And at last create 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.

Compétences : SQL, MySQL, Développement de bases de données, Relational Databases, Database Design

En voir plus : mysql data base pdf, world zip code data base mysql, creating email data base, sample systems using data report vb6 mysql, creating payroll using mysql, restore data base mysql deleated, search display mysql data base ajax, developing data base using, creating online proposal generator using php mysql, project hospital management using fox pro data base, mysql data manipulation using html, attendance data base using vb6, write mysql data base joomla, data migration php using mysql, report creator using mysql data, query mysql data base remotely, data base using matlab gui, insert data jsp using mysql, data mining using mysql, how to create an html form that stores data in a mysql database using php part 1 of 4

Concernant l'employeur :
( 0 commentaires ) BRONX, United States

Nº du projet : #30105320

Décerné à:


Hi, I'm an Oracle certified Expert and i also perform MySQL database development and administration .I read your requirements and I can design and implement your database in less time. Hire me and let me handle this ta Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 3 jours
(2 Commentaires)

8 freelances font une offre moyenne de 56 $ pour ce travail


Greetings!. I checked your Creating and manipulating data base using mySQL requirements. Your work is one of the tasks that can be done very perfectly by us. I am good in MySQL , MS ACCESS, MS SQL, Oracle , No SQL and Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(13 Commentaires)

Hi, there. I have read your project description very carefully so I had confidence that I can do it. I have experience over 9 years with the skills you required. So this project you post can be completed excellently fo Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(3 Commentaires)

Hi I have 15 years of experience in SQL server Database development, MySQL development, postgress SQL,c#, Python, power bi. I will be able to help you with the project. Please ping me offline to discuss further.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(4 Commentaires)

Hello Sir/ma'am I just went through your project. You need someone good at SQL QUERIES and an expert in DBMS. I'm an MCA and have been a computer science teacher for a while. I assure you that I can complete the work Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)

- Lead in creating business reports ,visualization and dashbpards using Crystal Reports,SSRS ,Tableau and Power BI. -Spearheaded on enhancing bulk report generation by using SQLstored procedure,functions ,views and e Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(0 Commentaires)

I have around 6.8 years of experience in SQL, and Data warehousing. ETL tool I extensively work on is Informatica power center, with the databases being Teradata,DB2

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)

Hi I'm Shayan and I'm new member of freelancer site. I have about 5 years of experience in SQL server query writing and I have a good knowledge of database analyzing. Please reply so that we can discuss over the proje Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)