i need a help for my sql project
Budget $30-250 USD
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
38 freelancers are bidding on average $158 for this job
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 More
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 More
Can do this. Results will be delivered as schema file , and set of queries. Everything will be well tested.
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 More
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.
♦ 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 More
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 More
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 More
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 More
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.
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 More
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 More
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 More
