Kapalı

i need a help for my sql project -- 2

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: #35878639

Bu iş için 20 freelancer ortalamada $150 teklif veriyor

topithub

i need a help for my sql project -- 2 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 p Daha Fazla

$190 USD in 2 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
(15 Değerlendirme)
5.0
eduardoherreral4

Hi I have read your description carefully. I have rich experiences in ⭐ ER diagram, SQL, database, RMDB. ⭐ I worked on many similar projects. I can guarantee the quality of the job. Please kindly message me. Thank you.

$50 USD in 2 gün içinde
(10 Değerlendirme)
4.7
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 7 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
Muhammadzeesha59

Hello Client ! I am a skilled full stack developer. Having rich experience in Java , Python , C , C++ , C# , Mysql , Sql , Oracle , Object Oriented Programming , Data Structure , Algorithms . Daha Fazla

$40 USD in 7 gün içinde
(10 Değerlendirme)
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
hussainmuzammal4

✅ ⭐✅ ⭐✅ ⭐✅ ⭐✅ These are the recent projects solved https://www.freelancer.com/projects/statistics/Statistics-29769906/details https://www.freelancer.com/projects/vb-net/Use-simple-dll-net https://www.freelancer.com/pr Daha Fazla

$140 USD in 7 gün içinde
(3 Değerlendirme)
4.7
milospetkovic000

Hi, there I have checked your project description carefully and I think that I can help you to complete this project 100% perfectly sure to satisfy your requirement. I have more than 7 years of experience in Daha Fazla

$120 USD in 3 gün içinde
(0 Değerlendirme)
0.0
jaymacfreelance

"I am a Full stack web front-end /back-end Developer here for you" Hello, Warm Greetings !! Yes, This job matches my skill set.I would like to let you know that I have experts and commercial experience in this catego Daha Fazla

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

Hi there, How are you? I have gone through your project details. I would like to tell you that l have a great bunch of experience in SQL, Oracle, Database Administration, Database Development and Database Programming. Daha Fazla

$250 USD in 8 gün içinde
(0 Değerlendirme)
0.0
mohamedsamir3

At the university, I studied computer science in addition to its theoretical and practical applications. Computer science applies principles of mathematics, engineering, and logic to a wide number of jobs, including al Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
wael100

Hi I had a PhD in computer science. My area of expertise is database. I think I can help you. Contact me.

$200 USD in 3 gün içinde
(0 Değerlendirme)
0.5
aymenayadiTN

hello again, I am a weblogic/oracle 12c database Administrator with more than 6 years of experience creating schema files, PL/SQL scripts and packages. I can help you with the task in hand to convert the ER diagram and Daha Fazla

$170 USD in 4 gün içinde
(0 Değerlendirme)
0.0
diksha708

Have 6+ years of experience in Oracle database. Good in standalone, RAC and dataguard. Installed and configured Oracle databases on multiple environments using manual and DBCA  method Administrating Oracle databases (1 Daha Fazla

$140 USD in 2 gün içinde
(0 Değerlendirme)
0.3
nrlblqis

Hello Sir, I am writing in response to your advertisement for a “Data Entry". After carefully reviewing the experience requirements of the job description, I feel that I am a suitable match for the job. I’ve held seve Daha Fazla

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

Hello, the requirements are clear, to do the following (1) Covert ERD to scripts and displayed the keys (PK, FK and Unique constraints) (2) create 5 quiries to reterive data needed (3) create 2 SP to acheive the Daha Fazla

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

I have 2 years experience in SQL, Oracle database, I will help you finish this project clearly. You can ask me whenever you need. I support with all the responsibility.

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

I work with same tasks for years, so writing advanced sql scripts is my strongest side and I'll try my best to help you

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