Đã Đóng

Create a Database

First: Refer to the abridged data file “2013-07 - Citi Bike Trip [login to view URL]” (data from CitiBike) will be given.

Part 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 facts.

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.

Part 2:

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)

Part 3:

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 station.

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!

Kĩ năng: MySQL, Quản trị cơ sở dữ liệu, Phát triển cơ sở dữ liệu

Xem nhiều hơn: create database design wine shoppe company, access assignment create database, create database online, create database access 2003 access 2007, create database properties website, create database word documents, create database normalize data, create database schema csv file, php class create database tables, create database dreamweaver frontend backend, create database table xml schema, create database flex mysql, create your first excel 2013 workbook, how to create database in visual studio 2013 step by step, entity framework code first create database, entity framework core code first create database

Về Bên Thuê:
( 0 nhận xét ) The Bronx, United States

ID dự án: #30205254

21 freelancer chào giá trung bình$158 cho công việc này

Truonggiang86

Hello there, The citibike project is an interesting project for the New York city who want to hire the bike to run from station to another station. Depend on your project's description i can understand that you need to Thêm

$200 USD trong 3 ngày
(13 Nhận xét)
4.2
punmsharma93

Hi sir, I can complete your job. I have rich experience in Web development. Also dont worry about time frame I will try to complete ASAP. I have worked on more than 100+ projects so far where I worked on HTML5, CSS, Thêm

$220 USD trong 5 ngày
(11 Nhận xét)
4.0
pratikpatelborsa

Dear sir, I'm very excited to work with you on your project. I have read the description and I can do this because I had completed this so many times for my clients. Hence, I'm very familiar with this. Kindly share Thêm

$50 USD trong 1 ngày
(16 Nhận xét)
4.0
adricabrelles

Hi, I am a Senior DBA with more than 20 years experience in databases, Oracle, sql sever, mysql, ... modeling and programming. I can help you. Regards.

$140 USD trong 1 ngày
(12 Nhận xét)
4.0
(5 Nhận xét)
3.0
MWaseemAmeen

*** EXPERT DEVELOPER *** I may provide you full application according to your requirements and customizations. My expertise includes the following : - .NET - ASP.NET - C#.NET - MYSQL - MS SQL - WPF - WEB FORMS - WINDOW Thêm

$90 USD trong 2 ngày
(4 Nhận xét)
2.4
bmoatar1

Hi, I have full experience with MySQL. ========================================================== I'm sure I can complete your project on time with high quality. you can contact me and discuss project more detail via c Thêm

$120 USD trong 2 ngày
(3 Nhận xét)
1.7
bizmanas

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

$278 USD trong 15 ngày
(5 Nhận xét)
1.8
angelsoftpune23

Hi there, I have gone through the description of Database [login to view URL] and I can provide you the quality work within the deadline. By the time, I will provide you more creative and professional ideas. Hoping to connect so Thêm

$140 USD trong 7 ngày
(2 Nhận xét)
0.9
indrajitpaul

Hello, I am a Database developer. I prepare data models and create ER diagrams and also write SQL scripts to create the tables, constraints, triggers, objects, procedures. I also carry out data normalization by followi Thêm

$190 USD trong 12 ngày
(1 Nhận xét)
0.6
josehusam

Hi, there. I can start just now. I am a creative and professional Database and database convert application developer having more than 5+ years of professional experience as a senior developer in this field. My main a Thêm

$100 USD trong 2 ngày
(0 Nhận xét)
0.0
thuha0201

Hi. I have read proposal, fully. I have good experience with C++, Python, Java programming. I experienced in nlp and machine learning with rasa dialog flow ai and api.ai. I good at mathematic and usually participate Thêm

$111 USD trong 2 ngày
(0 Nhận xét)
0.0
softwexperts

Hi, I have 9+ years of experience in Database development and management. I would be able to build your application in NoSQL, which will work with high performance considered your size of data. Will commit long-te Thêm

$220 USD trong 7 ngày
(0 Nhận xét)
0.0
shakil248

I have a good background in mySQL and Oracle along with database administration. Hope I can deliver your requirements in required time

$227 USD trong 7 ngày
(0 Nhận xét)
0.0
pouyasadrifard

Hi I’m SEYEDPOUYA and i have 21 years old. Since i was 14 years old i started to work as a developer and now i’m here to work with you. As i mentioned i have 6+ years experience in this field i know ups and downs of t Thêm

$110 USD trong 5 ngày
(0 Nhận xét)
0.0
AllanNS

i have read job description i have a nice background in Database design and administation. I can complete every bit of requirement which you are looking for. your task is fairly easy and simple. We can discuss further Thêm

$100 USD trong 1 ngày
(0 Nhận xét)
0.0
Sumeet110294

Have delivered similar projects in the past with 100% accuracy and providing support and training of the work completed.

$250 USD trong 10 ngày
(0 Nhận xét)
0.0
AzlanAhemd

I am a computer science graduate with 5 years of experience in development and database field .I can create and upgrade and your database tables in SQL .I can write and optimize your stored Procedure and create views a Thêm

$120 USD trong 7 ngày
(0 Nhận xét)
0.0
kareemnabil83

Hi there, I am Kareem I am a professional database administrator with 15 years of experience in the filed of Database development and administration I have read carefully your description and i fully understand your r Thêm

$100 USD trong 7 ngày
(0 Nhận xét)
0.0
Vickybobo

Hello! I hope you are doing well. I am an experienced database adminstrator using SQL for a long time. I have read your project description and I am very interested in your project. But I didn't see your attached fil Thêm

$100 USD trong 2 ngày
(0 Nhận xét)
1.8