Find Jobs
Hire Freelancers

Fix Database and Create 6 queries

$30-250 USD

Completed
Posted almost 5 years ago

$30-250 USD

Paid on delivery
I have an oracle database that was created a week ago. Had it checked out and it needs some fixes/additions to be made. I have an image of what the database needs to look like with all the attributes and table names provided. Then i need someone to fix the relational algebra file attached and then develop 6 SQL queries based on the algebra. This will be a 3 phase Project due by Saturday April 27th. Each phase is described below. Phase 1 - Use the SQL Data modeler tool which is free from Oracle. ([login to view URL]) to fix the database ([login to view URL] file) and make it mach the image of the fixed database ([login to view URL]). Phase 2 - There are 3 attached files related to Relational Algebra. ([login to view URL] which shows the errors in the [login to view URL] files). The Edit_Algebra file already has queries 1-3 completed. I need you to create three new relational algebra queries for 4,5,6 based on the attached ([login to view URL]) Select one from the options provided for each 4,5,6 and then create the relational algebra. Once the relational algebra is done for all 6 queries, develop the SQL Statements based on the relational Algebra. Once this is completed you can move on to phase 3 Phase 3 - The database you fix in phase one will auto generate to SQL statements using the link provided in the ([login to view URL]). In this phase i need you to follow the (Required_Files) attachment and create TXT documents for each of the highlighted names. Parts 1, 2, 3 will be auto generated for you in the previous step. Part 4, will require you to create and insert enough data to run the queries you designed in phase 2. Insert tuples or rows into the necessary tables to run the 6 queries from the ([login to view URL] file in phase 2 that you created). I ask that the inserted data be related to American based names and cities and locations. Previous project the hired freelancer used Indian based names and locations which wasn't compatible with what i needed. Please and thank you. Part 5 will require just simple select * statements to insure that the data you inserted in part 4 can be requested. Part 6 will be the document that you created in phase 2 that has the SQl queries written in it. Part 7 will be a word document that shows the results of the 6 written queries to ensure that they are accurate and working. At the end of phase 3 you should have 6 text documents (Create,Drop,Delete,insert,select, and queries) then one word document that shows the output of the queries from part 6.
Project ID: 19340196

About the project

12 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello, I have good sql skills that I got at college. For me this project is an opportunity to prepare for my informatics study at the university.I will probably be not the fastest, so I wont ask a high price.
$100 USD in 2 days
5.0 (1 review)
2.0
2.0
12 freelancers are bidding on average $135 USD for this job
User Avatar
Nice to meet you. I've read the project description and can develop definitely. I'll provide you with the highly skilled & professional HTML/CSS, PHP/WordPress/CodeIgniter, JavaScript, MySQL, Front & Back-End Web Development Services and complete the site in time. Please contact with me. Thank you very much.
$100 USD in 3 days
5.0 (59 reviews)
6.6
6.6
User Avatar
Hey A Database design and database expert developer is here I have good advanced expertise in SQL and database development This is an initial bid Regards
$40 USD in 1 day
4.9 (46 reviews)
5.4
5.4
User Avatar
Hi, I am expert databases like Oracle / MYSQL and MongoDB. More than a decade I am working as a database designer cum administrator. I would like to work on this project and produce best result for u. Please come for chat, let us discuss and will start the work immediately. Thanks Paul
$120 USD in 2 days
4.9 (23 reviews)
5.2
5.2
User Avatar
Hi, Thanks for your job posting. I've read your project description carefully. You want someone fix database and build 6 queries. As a database expert, I have rich experience in this kind of projects . I am sure I can handle this project as you expected. If you have desire to work with me, please respond me to discuss more. Thanks.
$150 USD in 3 days
5.0 (10 reviews)
4.9
4.9
User Avatar
I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below: Database - SQL Server, Oracle, MySQL BI - Microsoft MSBI and Informatica ETL Dotnet - C# (core), ASP.Net (core), MVC, Javascripting etc... Cloud - Azure (Paas and IaaS) Let me know if you want to discuss further. My Technical background • A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
$222 USD in 5 days
5.0 (28 reviews)
4.9
4.9
User Avatar
Hi, Dear. I have read your project description and am ready for discussing with you about project. I have 6 years experienced in developing Laravel and CodeIgniter. I will work very hard and best for you. Best regards.
$200 USD in 3 days
5.0 (19 reviews)
4.5
4.5
User Avatar
Dear Sir/Madam, I have SQL and relational database design and development experience of 10 years. Lately I completed 5 Database Systems course projects which cover: - Conceptual design (ER diagram), Logical design, Normalization - Writing relational algebra statements - Creation of database schema (tables and constraints) - Writing simple and complex SQL queries including joins and subqueries I have the following database design and implementation experience: - Oracle Financials (Oracle EBS) Project - Cognos BI project (MSSQL) - Oracle Transportation Management (OTM) Project - Siber Logistics Software Project (MSSQL) - CargoMax Logistics Software Project (PostgreSQL) For the above projects: - I performed data cleansing using SQL - I wrote queries running automatically and sending alert messages to users automatically - I wrote Oracle packages to send automatic emails (Arrival Notice messages, Cargo Spec messages, Invoices, Reconciliation Letters) to customers at predefined time intervals. - I developed reports or enhanced performance of queries in the reports using Oracle Reports, Oracle BI reports, Oracle SQL, Stored Procedures/Functions, and packages. I am sure that I am a good fit for your project. Hope to hear from you soon. Best Regards Huseyin Aygun
$225 USD in 3 days
5.0 (9 reviews)
4.0
4.0
User Avatar
I have more then 15 years of experience in DBMS.
$155 USD in 3 days
5.0 (5 reviews)
3.3
3.3
User Avatar
I am available to do your task on time. I have an experience of 5 years in development. Expert in Database , Web development nd Java Desktop applications development.I can send you my work videos as a demo on demand. Waiting for your quick responce. I am new freelancer here but surely i am the best developer according to my experience.
$222 USD in 2 days
5.0 (1 review)
0.6
0.6
User Avatar
Hi, please let me know your requirements. how can i help you on this? you can call me on +917981232413, Thanks, Aravind
$40 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Myself a Oracle developer with overall of 3+ years of experience and solved many complex queries, triggers procedures and functions. If you provide a opportunity it will be glad to work with you and Client satisfaction is on my top priority. Thanks and Regards, KK.
$45 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Elkhart, United States
5.0
6
Payment method verified
Member since Apr 4, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.