Find Jobs
Hire Freelancers

Fix Database and Create 6 queries

$30-250 USD

已完成
已发布将近 5 年前

$30-250 USD

货到付款
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.
项目 ID: 19340196

关于此项目

12提案
远程项目
活跃5 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 在2天之内
5.0 (1条评论)
2.0
2.0
12威客以平均价$135 USD来参与此工作竞价
用户头像
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 在3天之内
5.0 (59条评论)
6.6
6.6
用户头像
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 在1天之内
4.9 (46条评论)
5.4
5.4
用户头像
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 在2天之内
4.9 (23条评论)
5.2
5.2
用户头像
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 在3天之内
5.0 (10条评论)
4.9
4.9
用户头像
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 在5天之内
5.0 (28条评论)
4.9
4.9
用户头像
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 在3天之内
5.0 (19条评论)
4.5
4.5
用户头像
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 在3天之内
5.0 (9条评论)
4.0
4.0
用户头像
I have more then 15 years of experience in DBMS.
$155 USD 在3天之内
5.0 (5条评论)
3.3
3.3
用户头像
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 在2天之内
5.0 (1条评论)
0.6
0.6
用户头像
Hi, please let me know your requirements. how can i help you on this? you can call me on +917981232413, Thanks, Aravind
$40 USD 在3天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在5天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
Elkhart, United States
5.0
6
付款方式已验证
会员自4月 4, 2018起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。