Oracle Review

In this lab, you will demonstrate you are comfortable navigating the AWS Oracle RDS environment and
creating basic Schema objects using SQL developer or similar tool. This lab is a review of basic SQL.
You must connect to the AWS Educate Oracle RDS environment and complete these task to earn
credit for this lab.
Lab Requirements
1. Write and test a set of SQL statements that will drop the following tables:
a. Engineers
b. Faculty
c. Classes
d. ClassEnrollments
Be sure to use the exact table names as listed.
Note: Since you probably have not yet created there tables, you will receive an error which is Okay and
2. Write and test a set of SQL statements that will create the following tables:
a. Engineers
Primary Key: EID
Columns: Lastname, Firstname, Email, Graddate
b. Faculty
Primary Key: FID
Columns: Lastname, Firstname, Email, Hiredate
c. Classes
Primary Key: CID
Columns: Subject (e.g. SDEV), Catalognbr (e.g. 350), Title (e.g Database Security )
d. ClassEnrollments
Primary Key: EnID
Foreign Keys: CID (from Classes), FID (from Faculty), EID (from Engineers)
Be sure table and column names exactly match the requirements.
3. Write and test a set of SQL statements that will insert the following quantity of records into each
a. 15 Engineers
b. 3 Faculty
c. 3 Classes
d. 15 ClassEnrollments
Your Primary Key IDs should always start with 1 and increment by 1. You can use an Oracle sequence but
it is not required. Just hardcoding the Primary Key ID is Okay for this exercise.
4. Write and test a set of SQL statements that will select all records from each table. The output
should display the records in descending order by Primary key.
5. Write and test a set of SQL statements that will Update records with the following specifications
a. Update the Lastname of one faculty in the Faculty table to be “Friendship”.
b. Update the Firstname of one engineer in the Engineers table to be “Amadeus”.
c. Update the Subject of one class in the Classes table to be “IOT Cyber”.
You may need to use these requirements as you design your insert statements for step 3.
6. Write and test a SQL statement that will Delete the ClassEnrollments record with the lowest
7. Write and test a SQL statement that creates a view joining the required tables such that a user
can retrieve the Engineer’s Lastname and Firstname, the Faculty Lastname and Email and the
Classes’s Subject and Title for each Course enrollment.
Deliverables (100 points total)
Three separate files should be provided with your name, date, course information (e.g. SDEV 350 6380)
and professor name. Using a zip file to compress all three files into one file is recommended.
o One SQL file that contains all SQL statements used. Comments must be included in the
SQL file briefly describing groups of SQL statements. The SQL file should run without
issue from start to finish and produce the SQL output file. (30 points)
o One SQL output results showing the results of running your SQL file (30 points)
o Screen capture(s) showing you successfully running the SQL file from the AWS Educate
classroom environment (40 points).



The post Oracle Review first appeared on COMPLIANT PAPERS.

Calculate your paper price
Pages (550 words)
Approximate price: -

High Quality Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level or professional level, and we will assign a writer who has a respective degree.


Experienced Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.


Free Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document.


Timely Delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension.A 100% refund is guaranteed.


100% Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text.


24/7 Customer Services

Tutorpro support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Tutorpro Homework Help Services

At Tutorpro, we have top rated masters and PhD writers who will help you tacke that homework and score A+ grade. Tutorpro services covers all levels of education : high school, college, university undergraduate, masters and PhD academic level.


Essay Writing

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.



Admission Essays

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.



Essay Editing

Tutorpro academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.



Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. This is free because we want you to be completely satisfied with the service offered.