Homework answers / question archive / Use ORACLE SQL DEVELOPER, SO THAT I CAN RUN IT ON MY SYSTEM Design and implement in Oracle a relational database scheme for a cellphone store

Use ORACLE SQL DEVELOPER, SO THAT I CAN RUN IT ON MY SYSTEM Design and implement in Oracle a relational database scheme for a cellphone store

Computer Science

Share With

Use ORACLE SQL DEVELOPER, SO THAT I CAN RUN IT ON MY SYSTEM

Design and implement in Oracle a relational database scheme for a cellphone store. 

1. Declare your relations using the SQL DDL
2. Specify and write five queries that are needed by the application
3. Based on your expected use of the database, choose some attributes that should have indexes specified on them
4. Implement the database in Oracle. (Add at least three records to each table).
5. Submit the database design in a PDF file
6. Submit your 1 SQL file.

Create the following database in Oracle.

In SQL, write the following queries on the database specified above using the concept of nested queries. (IMPORTANT: submit a .SQL file. No other type of file will be accepted. Make sure the extension is .sql)

1. Retrieve the names of all employees who work in the department that has the employee with the highest salary among all employees.
2. Retrieve the names of all employees whose supervisor has '888665555' for SSN.
3. Retrieve the names of employees who make at least $10,000 more than the employee who is paid the least in the company.