You need to convert the entity relationship design into relational tables in the Oracle database environment. Add at least 10 rows of meaningful data into each table. Develop 8 SQL statements to produce meaningful query results from the data in the database to support business operations.
- Must use aggregate functions
- Must use ORDER BY
- Must use GROUP BY
- Must use more than tables
- WHERE clause using LIKE, IN, or BETWEEN
- Must use logical operators (AND, OR, NOT)
- Must use INSERT, DELETE, or UPDATE
Database implementation: Create tables, insert data, and create queries (new)
Tables must be in the 3NF.
i. Include data dictionary tables that list table name, attribute names, attribute description, data type, required, and foreign key referenced table.
ii. Include screenshots to show the data in the tables from SQL Developer.
iii. For each query, describe a business purpose of the query and include a screenshot that shows the query and its result.
iv. Attach SQL script files with the full report submission.
hi I can surly provide you desired result within timeframe. please share e-r diagram. thanks.
Bu iş için 32 freelancer ortalamada $51 teklif veriyor
I'm a database programmer who can support, develop and administer various databases. I code, update, debug and responsible for the integration of web technologies such as: Apache, PHP, JAVA and ASP Relevant Skills and Daha Fazla
HI I went through the requirements and I would like to see the database design that needs to be converted to oracle. Let me know if you are interested. Thanks. Relevant Skills and Experience Oracle, SQL, Database Pro Daha Fazla
Hi there, I have read the details, its an easy job for me. I have strong knowledge in plsql, dynamic sql, pivot tables, normalization (1NF, 2NF, 3NF, BCNF), umls and much more. Message me, Relevant Skills and Experien Daha Fazla
Greeting, I have understood your Database implementation task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 years of experience in Daha Fazla
Hello Client, i am really interested in your project, i want to discuss with you more details. Expérience et Compétences appropriées Oracle database; Étapes proposées $26 NZD - Complete task please come on chat for Daha Fazla
Hi, I hope to see my bid. I have more then seven years of experience in Oracle SQL, PL/SQL field, so I can help you to achieve your target. Relevant Skills and Experience Oracle Developer. PeopleSoft Developer. Oracle Daha Fazla
I am a certified Oracle PLSQL Developer Associate. Relevant Skills and Experience Oracle, SQL, PL/SQL Proposed Milestones $28 NZD - Completing the Job description related queries and screenshots. What is the need by Daha Fazla
I have been working on database queries from past 7 years. Created a lot of complex queries
I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. We are the team of 6 experienced [login to view URL] our team,2 members are OCP certified. Relevant Skills and Daha Fazla
Hello. I have a BS in Computer I formation Systems and Orqcle certified DBA.
I will deliver this work the next day after you go decision. Relevant Skills and Experience Experienced DB programmer, enterprise level solutions. SQL and Oracle skills. Proposed Milestones $16 NZD - Full work comple Daha Fazla