Đã hoàn thành

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.

Kĩ năng: Quản trị cơ sở dữ liệu, Phát triển cơ sở dữ liệu, MySQL, Oracle, SQL

Xem nhiều hơn: 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

Về Bên Thuê:
( 6 nhận xét ) Elkhart, United States

ID dự án: #19340196

Được trao cho:

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 trong 2 ngày
(1 Nhận xét)
2.0

18 freelancer đang chào giá trung bình $162 cho công việc này

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

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

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

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

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

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

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

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

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

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

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

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

$177 USD trong 12 ngày
(0 Nhận xét)
0.0
aap31374

I have more then 15 years of experience in DBMS.

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

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