Færdiggjort

Fix Database and Create 6 queries

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.

Evner: Database Administration, Databaseudvikling, MySQL, Oracle, SQL

Se mere: fix database problems, access database create table, access 2007 fix database, how to create a database in access 2010 step by step, database table example, how to create employee database in access, how to create database in mysql, how to create a library database, database table design examples, how to make your own database, steps to create database in ms access, fix database sql wordpress, input output txt, create multiple csv output html, tile editor output txt, php sql database create file, php database create projects delete projects script, fix database website, access 2007 simple database create, mmorpg price database create

Om arbejdsgiveren:
( 6 bedømmelser ) Elkhart, United States

Projekt ID: #19340196

Tildelt til:

georgiynef

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 dage
(1 bedømmelse)
2.0

18 freelancere byder i gennemsnit $162 på dette job

truongnguyen86

Hello there, i'm expert on database designing, i can see now you need to finish 7 parts(6 parts with tables, queries and final one is with the report). I don't know what to say about the diagram now but it seems a mes Flere

$250 USD in 3 dage
(180 bedømmelser)
6.8
kipdev13

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 Dev Flere

$100 USD in 3 dage
(44 bedømmelser)
6.3
usman1493

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 på 1 dag
(36 bedømmelser)
5.2
KGeorgy

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 Flere

$150 USD in 3 dage
(10 bedømmelser)
4.8
paulprabhakarand

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 Flere

$120 USD in 2 dage
(18 bedømmelser)
4.7
bluesea1990

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 dage
(13 bedømmelser)
4.1
artemu1223

High-quality & Fast-delivery is promised! As a highly skilled full stack developer, I have rich experience in database management. I am very confident with my skills and I'd like to help your business by doing my b Flere

$200 USD in 3 dage
(9 bedømmelser)
4.1
huseyinaygun

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 des Flere

$225 USD in 3 dage
(5 bedømmelser)
3.1
wozny

Dear Sir, I'm a software engineer with over 12 years of experience mostly as a back-end developer. I've been optimizing SQL queries and DB model for years for the number of companies, including US-based banking corp Flere

$222 USD in 3 dage
(4 bedømmelser)
2.3
cyberleporis

Greeting! I have read you request for the work you are in search of.I'm happy to be in contact with you. Good News! I'm ready to deploy a surefire, professional work based on your theme. If you have additional questi Flere

$222 USD in 3 dage
(3 bedømmelser)
2.1
jayantavkumar

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 Inform Flere

$222 USD in 5 dage
(3 bedømmelser)
1.8
Karekin

Hello Law, Greetings of the day!!! I understand that you are seeking a reactjs developer to assist you in building a website having features very similar to workflowy website with some modification such as add tasks Flere

$222 USD in 3 dage
(1 bedømmelse)
1.4
atifr454

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. W Flere

$222 USD in 2 dage
(1 bedømmelse)
0.6
vikakdit

Hello, I’ve carefully gone through your job posting for a Shopify web development as you share the reference link, I am pleased to present my skills for your consideration as a Web Developer with a proven track record Flere

$177 USD in 12 dage
(0 bedømmelser)
0.0
aap31374

I have more then 15 years of experience in DBMS.

$155 USD in 3 dage
(0 bedømmelser)
0.0
aravindpeddola

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 dage
(0 bedømmelser)
0.0
kkdotcomk41

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 satisf Flere

$45 USD in 5 dage
(0 bedømmelser)
0.0