Kapalı

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

Beceriler: Oracle, SQL, Veritabanı Programlama, Veritabanı Geliştirme, Veri Tabanı Yönetimi

Müşteri Hakkında:
( 0 değerlendirme ) Jeddah, Saudi Arabia

Proje NO: #35878638

Bu iş için 38 freelancer ortalamada $158 teklif veriyor

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 Daha Fazla

$220 USD in 4 gün içinde
(42 Değerlendirme)
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 Daha Fazla

$190 USD in 3 gün içinde
(13 Değerlendirme)
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 Daha Fazla

$80 USD in 7 gün içinde
(14 Değerlendirme)
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 Daha Fazla

$100 USD in 7 gün içinde
(22 Değerlendirme)
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. Daha Fazla

$500 USD in 6 gün içinde
(12 Değerlendirme)
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 Daha Fazla

$150 USD in 5 gün içinde
(23 Değerlendirme)
4.2
algispetkuns

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

$140 USD in 4 gün içinde
(2 Değerlendirme)
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 Daha Fazla

$240 USD in 4 gün içinde
(26 Değerlendirme)
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 in 12 gün içinde
(2 Değerlendirme)
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 Daha Fazla

$150 USD in 7 gün içinde
(1 Yorum)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(10 Değerlendirme)
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 Daha Fazla

$140 USD in 7 gün içinde
(2 Değerlendirme)
2.9
rodrigomoraes89

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

$140 USD in 7 gün içinde
(2 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
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 Daha Fazla

$250 USD in 5 gün içinde
(5 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(7 Değerlendirme)
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 Daha Fazla

$99 USD in 2 gün içinde
(1 Yorum)
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 Daha Fazla

$250 USD in 5 gün içinde
(2 Değerlendirme)
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 Daha Fazla

$140 USD in 7 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$140 USD in 7 gün içinde
(0 Değerlendirme)
0.0