Suljettu

i need a help for my sql project

Job Description:

Convert your ER diagram to a relational schema. (

➢ Underline all key attributes in your relations.

➢ Specify all functional dependencies for each relation. (Mapping)

- Use Oracle to create the normalized tables.

- Populate your tables with 5 rows at least.

- Design and implement at least 4 queries. As specified below

Data Retrieval Queries with Select (total of 4 Queries)

➢ Where

➢ Order By

➢ Group By

➢ Aggregate functions

➢ Subquery

➢ Join query

- Note:

➢ You are free to mix between all those clauses in one or more query, but you have to use them all so the total number of queries for Data Retrieval Queries with Select in the end will be 4.

➢ Using select all (*) is NOT accepted.

- Design two stored procedures as the following

➢ Create a PARAMETER based SELECT QUERY stored procedure which return records based on parameters?

➢ Create an UPDATE query based stored procedure

Taidot: Oracle, SQL, Tietokantaohjelmointi, Tietokantakehitys, Tietokannan hallinto

Tietoa asiakkaasta:
( 0 arvostelua ) Jeddah, Saudi Arabia

Projektin tunnus: #35878638

38 freelanceria on tarjonnut keskimäärin $158 tähän työhön

schoudhary1553

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

$220 USD 4 päivässä
(42 arvostelua)
6.4
topithub

i need a help for my sql project Hi, hope you are doing well, I am free nowadays and can start your work. For my experience kindly once have a look on my profile and check my work samples which I attached on my profil Lisää

$190 USD 3 päivässä
(13 arvostelua)
5.2
awais26

Hello, Thanks for job posting. I read your project description . I have extensive experience in SQL server DBA and development. I am one of Microsoft certified SQL server DBA. I specialized in SQL server and Azure. Pr Lisää

$80 USD 7 päivässä
(14 arvostelua)
5.0
ahmedkamran9

I'm a UK based database developer/designer with over 18 years of experience in various databases, including Oracle, SQL Server, PostgreSQL and MySQL. I'm also an Azure certified data engineer with experience in the ETL Lisää

$100 USD 7 päivässä
(22 arvostelua)
4.8
bizmanas

Hi I have 15 years of experience in Sql server database development, mysql database development, postgresql database development. Expert in data analysis. Reporting using power Bi. Programming using C#and sql server. Lisää

$500 USD 6 päivässä
(12 arvostelua)
4.5
noureen23

Hi There, hope you having good day. I am glad to offer my services for "Sql Project". I have 15+ years of experience in Oracle Databases. Designing Schema, SQL Programming , Creating Procedures/ Functions for Data R Lisää

$150 USD 5 päivässä
(23 arvostelua)
4.2
algispetkuns

Can do this. Results will be delivered as schema file , and set of queries. Everything will be well tested.

$140 USD 4 päivässä
(2 arvostelua)
3.8
merinsinha

SQL expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from t Lisää

$240 USD 4 päivässä
(26 arvostelua)
3.9
ashinnd84

Hi there, we are experts in SQL, Database Programming, Database Development, Oracle, MySQL and PostgreSQL. Please, send me a message to discuss the work on the project. Thanks Ashish.

$250 USD 12 päivässä
(2 arvostelua)
3.1
arunkumarragee

♦ PL/SQL Expert ♦ Database Expert ♦ Immediate Start ♦ I’m a Software Engineer with 9+ years of experience in database development. I’m expertise in multiple databases Oracle, Snowflake, PostgreSQL, MSSQL, and MYSQL. I Lisää

$150 USD 7 päivässä
(1 arvostelu)
3.2
Bhatti1987

I have more than 12 years of experience in Oracle/ SQL/ MySQL/ PostGre Server database modelling, design, development, and Administration. I have worked for database designing and modelling of complex business an effic Lisää

$50 USD 1 päivässä
(10 arvostelua)
2.9
CourserXu

Hello there, I have read your requirements and am confident I am the right candidate for the job. Among other things, I have over ten years of experience in Oracle PLSQL, PostgreSQL, MySQL, MS SQL, and others NoSQL. F Lisää

$140 USD 7 päivässä
(2 arvostelua)
2.9
rodrigomoraes89

Hello I have a lot of experience with Oracle pl/sql I am available ....

$140 USD 7 päivässä
(2 arvostelua)
3.0
arunkumar9896

Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Exc Lisää

$80 USD 1 päivässä
(3 arvostelua)
2.7
indrajitpaul

Hello, I am an UML and Database designer. I design class diagrams and data models. For databases, I create ER diagrams and also provide SQL scripts to create the tables, constraints, triggers, objects, cursors, stored Lisää

$250 USD 5 päivässä
(5 arvostelua)
2.7
preitymathur0422

Hello, Have almost 15+ years experience working with SQL. Can do this for you with utmost accuracy and generate most efficient queries for the mentioned requirement. Can complete this in less than a day.

$140 USD 1 päivässä
(7 arvostelua)
2.7
Tourist88

Hi, I read the complete description of the project mentioned. I can work on this project and deliver it within the given deadline. Please share the ER diagram so we can go ahead with the next steps. I am available fo Lisää

$99 USD 2 päivässä
(1 arvostelu)
2.2
hayatkhan511

Hi, I have 7+ years of experience in SQL and PL/SQL development, and I understood your requirement I am sure that I will complete it in an efficient way. I have done this before with ERD into rational schema, Normaliza Lisää

$250 USD 5 päivässä
(2 arvostelua)
1.6
vanshika2022

Hi There, Good day! Hope you are doing fine. I gone through requirement still want to ask few questions to start your project now. ⭐ I will work with milestone only and release money as per good work progress. ⭐ I Lisää

$140 USD 7 päivässä
(0 arvostelua)
0.0
alphatech235

DATABASE ADMINISTRATION EXPERT DATABASE PROGRAMMING EXPERT GOOD IN JAVASCRIPT, MYSQL, PYTHON, C PROGRAMMING AND HTML HELLO DEAR CLIENT Thank you for sharing your project requirement, I have carefully read the project Lisää

$140 USD 7 päivässä
(0 arvostelua)
0.0