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.
Được trao cho:
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.
18 freelancer đang chào giá trung bình $162 cho công việc này
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
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.