Data Normalization and other Tasks

Imefungwa Ilichapishwa miezi 6 iliyopita Kulipwa wakati wa kujifungua

$10-30 USD

Kulipwa wakati wa kujifungua

Imefungwa Kulipwa wakati wa kujifungua

I need to learn about these topics. Ususally I m using MS Access for design. Please check my previous work but stuck at data normalization.

Task 1: Data Normalization

Convert each of your relations schemas / tables to 3NF, showing all intermediate stages, that is, 1NF and 2NF

Task 2: Queries:

Minimum 5 different queries. For each query, provide the question that the query should answer and the SQL statement or Access Query required to answer the question. The questions should be of business value and should provide information you think is important to the management. Include screenshots of the result of each query in your report as a proof that it worked and produced the desired result.

Queries should include these if/when possible:

• Conditions using various operators on numbers, text and date columns with results sorted

• Conditions applied to more than one column (AND/OR in the WHERE clause)

• Arithmetic calculations and concatenated columns

• Column aliases where required

• Aggregate functions. (SUM, AVG, MIN, MAX, COUNT etc.)

• Queries displaying results from more than one table (joins)

• Queries including GROUP BY and HAVING

Task 3: Views / Reports

At least three useful and well designed data views / reports based on Task 2

Microsoft Access SQL Kuprogramu Database Usimamizi wa Uhifadhi Data Ujenzi wa Database

Kitambulisho cha Mradi: #37396996

Kuhusu mradi

17 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Unapania kutengeneza pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda
Lipwa kwa kazi yako
Onyesha ombi lako
Ni bure kujisajili na kuweka zabuni kwa kazi

17 wafanyakazi huru wanazabuni wastani wa $36 kwa kazi hii

Picha ya Profaili ya schoudhary1553
schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Zaidi

$80 USD kwa siku 2
(Maoni 53)
6.6
Picha ya Profaili ya mobimubasir
mobimubasir

Hello. I read your requirement i will do that. Please come on chat we will discuss more about this. I will waiting your reply.

$25 USD kwa siku 1
(Maoni 20)
4.7
Picha ya Profaili ya Vickybobo
Vickybobo

Hello there, I hope you are doing well. I am an experienced data engineer/ database administrator/ data analyst using ETL Tools/ SQL/ Reporting Tools (SSRS, Jasper Report, Power BI) for more than 10 years. I have rea Zaidi

$50 USD kwa siku 2
(Maoni 30)
4.3
Picha ya Profaili ya odhiamborober
odhiamborober

Hello there! My name is Robert and I am a highly skilled and detail-oriented Data Analyst with a Bachelor's degree in Applied Statistics With IT. I understand you need help with data normalization and queries; specific Zaidi

$25 USD kwa siku 7
(Maoni 2)
3.1
Picha ya Profaili ya Ghazik
Ghazik

Hello Ready to make Data Normalization and other Tasks. Please send me a message to discuss further requirements of this project in chat. Thanks

$30 USD kwa siku 2
(Maoni 1)
2.7
Picha ya Profaili ya preitymathur0422
preitymathur0422

Hello, I am Preeti, having almost 15+ years of industrial hands-on experience working with multiple programming languages & database(s) and preparing relevant technical documentations. Currently working as a freelanc Zaidi

$20 USD kwa siku 5
(Maoni 9)
3.2
Picha ya Profaili ya braincenter
braincenter

Hello, I am delighted to have come across your project post and express my sincere interest in working with you. As an experienced contractor, I am confident that I possess the skills and expertise required to deliver Zaidi

$80 USD kwa siku 2
(Maoni 1)
2.8
Picha ya Profaili ya omarsaad5
omarsaad5

Hello I am a data analyst certified of udacity nano degree of data analysis using SQL I have four years of experience in access databases I could make data normalization to the 3NF and make relationship between tables Zaidi

$25 USD kwa siku 3
(Maoni 4)
1.8
Picha ya Profaili ya malikyawarabbas
malikyawarabbas

Hello there! My name is Yawar and I'm a professional data analyst with 3+ years of experience in the field of data analysis. I understand that you need to learn about data normalization and other tasks. I would be de Zaidi

$20 USD kwa siku 1
(Maoni 0)
0.0
Picha ya Profaili ya sahilbhosale7
sahilbhosale7

I am writing to express my interest in working with you on your data-related projects. As a freelancer with a strong academic background in pursuing a master's degree in Data Science and a proven track record in SQL an Zaidi

$20 USD kwa siku 7
(Maoni 1)
0.0
Picha ya Profaili ya sheetal001
sheetal001

Subject: Experienced T-SQL Developer for Efficient Database Solutions Hello, I hope this message finds you well. I am writing to express my interest in the MySQL Developer position you posted on Upwork. With my stron Zaidi

$20 USD kwa siku 7
(Maoni 0)
0.0
Picha ya Profaili ya purvigupta28085
purvigupta28085

Hi , I am professional SQL server developer with 5+ years of experience and would to help you out. I am very fluent with RDBMS ,transactions ,joins ,schemas and in depth database concepts.

$25 USD kwa siku 2
(Maoni 0)
0.0
Picha ya Profaili ya abs674
abs674

Hi there, I'm interested in the project you have posted. Task 1: Data Normalization Normalize your schema to 3NF Ensure data integrity and efficiency Task 2: Queries Create 5 meaningful SQL queries Include query sta Zaidi

$50 USD kwa siku 7
(Maoni 0)
0.0
Picha ya Profaili ya gurunath123jaisw
gurunath123jaisw

Good knowledge in aggregate function and normalization and understanding of database function, procedure, views, partition, and window function etc.

$20 USD kwa siku 5
(Maoni 0)
0.0
Tuma Mradi Kama huu