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
expected.
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
table
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
EnID
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).

 

 

Sample Solution

 

 

What is the Better Purchase: LCD TV or Plasma TV?

GuidesorSubmit my paper for examination

We live in a universe of decision. In every second, we are given the chance to browse a variety of alternatives. In all actuality, however, that we don’t generally settle on our decisions deliberately. Now and then, rather than picking what is best for our own necessities, we fall in the snare of business deceives and buy an item we needn’t bother with. At the point when we need to settle on a decision dependent on realities and target thinking solely, we have to efficiently break down and look at every item dependent on the models we esteem. In this paper, I will attempt to do that while picking between the two most well known sorts of TVs: LCD and plasma. When entering the specialized division of any general store or a cutting edge store, numerous individuals ask themselves whether a LCD TV is superior to a plasma TV, or the other way around. To respond to this inquiry, we have to think about the two items dependent on a few important specialized rules.

LCDFrom a layman’s eye, LCD and plasma TVs may resemble the other the same; be that as it may, a sharp eye will see the contrast between these sets. These distinctions grant clients to have a complex of decisions dependent on their specific necessities. A plasma show includes two glass boards pressed in compartmentalized spaces, with numerous little plasma cells. Plasma cells are regularly charged to an exact electrical voltage level (Kith, Plasma TV Components). Then again, a LCD show is included fluid precious stones that are regularly preset between two boards of glass (Reed, Architecture of the TV). Showcases are additionally upgraded by using power voltage on the LCD TV set board.

Because of such specialized contrasts, an end can be drawn that plasma TV sets are better in contrast with LCD TV sets with regards to lighting (Howard, TV Comparisons: Modern). Likewise, numerous clients have noticed that plasma screens give an upgraded dark shading show when contrasted with LCD screens. Furthermore, a plasma TV bears better review edges.

Another vital measure to consider at whatever point we look at two results of regular use is the estimating range. The cost of any TV set relies upon the presentation distance across and the complex setup of the gadget. One may spend as much as a million dollars on a TV set that was planned and specially crafted solely for their inside, and may even be trimmed with valuable stones or an architect mark. In any case, when we plan to look at two items dependent on their cost, we have to choose two similarly measured, manufacturing plant made for mass utilization results of a couple of mainstream brands, and think about their costs. A normal plasma TV is less expensive than a LCD TV. This is to a great extent because of the way that a plasma TV costs less to gather, in this way converting into a lower value (Fields, Price Comparisons of Viewing). The value basis by and by supports the plasma TV. Simultaneously, when considering the value factor, we need to comprehend its variability. Since LCD TVs are a considerably more present mechanical innovation than the plasma TV, there is a high chance that the cost of LCD items will diminish substantially sooner rather than later, as innovative advancement offers us new other options.

Attempt our online task organizer!

It will direct you bit by bit through the way toward completing your assignments without stress, while likewise dealing with your time.

Task breakdown

into parts and cutoff times

Helpful task tips with

references and rules

Custom suggestions to wrap up

the task in time

USE ASSIGNMENT PLANNER

Simultaneously, it is coherent to expect that the LCD TV will likewise have some impressive points of interest that help it effectively rival the plasma TV on store racks and in shoppers’ families. One such significant bit of leeway of the LCD TV would be its life expectancy. LCD TVs have a more extended life expectancy rather than the plasma TV (Franz, TV Statistics). It additionally has unrivaled screen goals. This would be an unequivocal factor to pick LCD over plasma for those customers who appreciate playing high-goals computer games on their TVs. In any case, this would not extraordinarily matter to a normal TV watcher, since a plasma TV consummately adapts to different assignments of an ordinary TV set with no goals blemishes for the watcher.

At last, innovation matters less with regards to acquiring such a famous residential gadget as a TV set. All things considered, it is about the unwavering quality and security of the gadget that each individual from your family will utilize for all intents and purposes each day. Having thought about the two most famous sorts of TV sets, I reached the resolution that there ought to be no contention between LCD TVs and plasma TVs. It isn’t about which TV set is increasingly worth its expense, or which is better-selling, however about the reason for which the TV set is being utilized. Despite the likenesses among plasma and LCD TV sets, their downplayed contrasts may be significant when thinking about the TV’s utilization, nature, and area.

Purchasing the biggest, most exorbitant TV set that will involve no not exactly an entire divider in your lounge room probably won’t be perhaps the sharpest choice for a family unit with kids and pets, while it would superbly suit a hello there tech condo of a youthful representative. Customers ought to recollect two or three fundamental tips while picking one kind of TV over the other. For example, on the off chance that you need to fit a TV set into a gigantic space, at that point a plasma TV will improve because of the more extensive survey edge and the lower cost of enormous sizes. The discussion about which TV set is better is a long way from being done. At long last, the inquiry lies more in the hands of the purchaser. Next time you purchase a plasma or LCD TV set, don’t be shocked if your neighbor condemns your decision.

References:

1. Kith, Hendrick. Plasma TV Components. Hallwork Publishing. 2011.

2. Reed, Melanie. Engineering of the TV. Limpon Press. 2008.

3. Howard, Sarah. Television Comparisons: Modern. Francis Publishing. 2009.

4. Fields, Garry. Value Comparisons of Viewing. The Atlantis Times. 2012.

5. Franz, Liam. Television Statistics. The Seattle Daily. 2013.

article group, conclusion exposition, innovation paper

 

 

 

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, Welcome to Compliant Papers.