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
Get step-by-step solutions from verified subject matter experts
