Question: 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

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 3. 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 EnlD 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!