i need a help for my sql project

Đã Đóng Đã đăng vào 1 năm trước Thanh toán khi bàn giao
Đã Đóng Thanh toán khi bàn giao

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

Oracle SQL Lập trình cơ sở dữ liệu Phát triển cơ sở dữ liệu Quản trị cơ sở dữ liệu

ID dự án: #35878638

Về dự án

37 đề xuất Dự án từ xa 1 năm trước đang mở

37 freelancer chào giá trung bình$158 cho công việc này

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 Thêm

$220 USD trong 4 ngày
(42 Nhận xét)
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 Thêm

$190 USD trong 3 ngày
(13 Nhận xét)
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 Thêm

$80 USD trong 7 ngày
(17 Nhận xét)
5.2
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 Thêm

$100 USD trong 7 ngày
(23 Nhận xét)
4.9
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 Thêm

$150 USD trong 5 ngày
(23 Nhận xét)
4.6
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. Thêm

$500 USD trong 6 ngày
(12 Nhận xét)
4.5
algispetkuns

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

$140 USD trong 4 ngày
(2 Nhận xét)
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 Thêm

$240 USD trong 4 ngày
(27 Nhận xét)
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 trong 12 ngày
(2 Nhận xét)
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 Thêm

$150 USD trong 7 ngày
(1 Nhận xét)
3.2
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 Thêm

$140 USD trong 7 ngày
(5 Nhận xét)
3.1
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 Thêm

$50 USD trong 1 ngày
(10 Nhận xét)
2.9
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 Thêm

$250 USD trong 5 ngày
(4 Nhận xét)
3.0
rodrigomoraes89

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

$140 USD trong 7 ngày
(2 Nhận xét)
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 Thêm

$80 USD trong 1 ngày
(3 Nhận xét)
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 Thêm

$250 USD trong 5 ngày
(5 Nhận xét)
2.7
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 Database Development, SQL, Database Administration, Oracle and Database Programming. Thêm

$250 USD trong 8 ngày
(1 Nhận xét)
2.5
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 trong 1 ngày
(8 Nhận xét)
2.9
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 Thêm

$99 USD trong 2 ngày
(1 Nhận xét)
2.2
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 Thêm

$140 USD trong 7 ngày
(0 Nhận xét)
0.0