PLEASE ANSWER THE FOLLOWING QUESTIONS IN DETAILS PLEASE

SUBJECT: Design of database design

Note: Please can you answer the remaining question. I already posted the previous question but this is the remaining part of the question. Please give me the SQL COMMAND AND THE OUTPUT IN ORACLE

THANKS

Description of Homework For each question below, provide solution for DBMS of your choice (Oracle or Microsoft SQL Server) as shown in class. So, your answer must contain the following: SQL command Output from DBMS (Oracle or Microsoft SQL Server)