MUST BE mySQL, RELATIONAL/ DATABASE EXPERT
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.
[I]
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.
[II]
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)
[III]
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
2
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!
[IV]
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.
Hello. How are you?
I've read your job description and it's very interesting to me.
As an experienced relational database expert I have rich experience and skills in SQL.
I'd like to review the text you mentioned in the job description.
Hope to discuss in more detail via chat.
Thank you.
I have read your JOB DESCRIPTIO and i am willing to work with you. Can we do QUICK CHAT right now so that we can discuss the project briefly?
I am interested in this project. I will put all my efforts and skills to deliver a masterpiece for you.
I offer UNLIMITED REVISIONS until you are 100% satisfied. I'm ready to start your project immediately, let's discuss further so that I can surprise you with my skills and professional work.
And Plese Igone the bidding price we can discuss the Price in chat later. Looking forward to hearing from you and potentially working with you. Thank you so much for your time and consideration.
Thanks,
QaceSolutions
Hey
Database is backbone of any project. I can offer my expertise in the same and then create a schema with documentation
which your team will be able to understand then take the development from there
Will submit the report as expected:
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.
Hi I have 15 years of experience in SQL server Database development,C#,Python and MySQL. I will be able to help you with the project. Please ping me offline to discuss further.
Hello!
I am really interested in this job. I’m data scientist working remotely with various analytical companies.
I’m offering best quality and highest performance at a price we are both comfortable with. I can complete your project on time and your will experience great satisfaction with me.
I’m well versed in R, python, SPSS, Stata, Excel etc
I have rich experienced in Database Design, MySQL, Database Development, Computer Science and Relational Databases.
For more information about me, please refer to my portfolios.
I’m ready to discuss your project and start immediately.
Looking forward to hearing you back and discussing all details..
Thank you!
Hi I am Vicky from Grailo , let us assist you on this project we have
a team of expert freelancers ready to assist you in no time.
We deliver productivity with emphasis on quality .
Whether it is FullStack Development in MERN Stack ,Mongo,MySQL,PostgreSql,React,React Native,Express,Node js, C++,Java etc.,
Digital Marketing, Graphich Designing,UI/UX Design
We are all you need.
Let us know more about your requirements ,
ping us and let's talk
Hello!
I am an experienced database adminstrator using SQL for a long time.
I have read your project description and I have the confidence that I can do it for you.
Please feel free to contact me and discuss more about the detail.
Best regards.
Dear Sir / Madam
As an ICT Specialist, I always strive to be on top of the fast technology changes by investigating and researching new technologies and solutions across a variety of systems, networks and infrastructures.
My future aspiration is to further my knowledge within the IT industry and becoming one of the best in the field namely BI/DW and Data Analytics/Science solutions.
As a Senior Information Specialist, I adept in researching scientific and technical information requests.
Resourceful, energetic, competent and results orientated multitasked with good IT all-rounder skills such as Client/Server Development, Network Technology, BI and Data Warehousing, Data Analytics, Training and Project Management.
Strong data collection, analysis and reporting skills. Capable of interpreting and relaying highly technical information to various audiences while maintaining integrity of data and findings.
I lead through mutual respect, honest communication and trust. I keep my eye on the bottom line. I maintain a strong work ethic and governance. I have a healthy competitive attitude and thrive under pressure.
I feel certain that the skills I have gained throughout my career will be of value to you and your organization.
Thank you for taking the time to read through my application in regards to the position advertised by your company.
Kind Regards