Task Programming Language and Technologies ${?}^{\text{'}}$

SQL Developer.

Oracle DBMS$.$

Evaluation Criteria ${?}^{\text{'}}$

$50\%$ on Logic.

$30\%$ program workflow.

$10\%$ Screenshots.

$10\%$ adding extra features that help archives better results.

Deadine

$27-$ October $-2024$

Notes $"$

Don't forget to add your creativity.

Solve the task individually.

Submit before the deadline.Create a database for the following scenario using SQL Commands, the primary key should be generated by default and create the class diagram.

The system is an integrated program developed to save time and effort. This website provides a quick and easy way to find out what medicines are available in the pharmacy as well as to buy medicine online.

There are employees in this system, and they are assigned to many roles.

Write the SQL Statement for the following:

Insert $5$ records in each table using one command and then:

Retrieve all the data from all tables.

Retrieve customers whose name contains an $\text{'}$a$\text{'}$ letter.

Retrieve employees whose position is Admin or Pharmacist.

Retrieve the employees whose name ends with $\text{'}d\text{'}$ and contains five alphabets.

Retrieve employees who have the $3$ highest salaries.

Retrieve the top $3$ records from employee table.

Retrieve the top $30\%$ records from employee table.

Retrieve the name with the uppercase first letter $($using built$-$in function$).$

Set the salary value $600$ JOD when dating of employment before $27/10/2021.$

Retrieve the name of customers who order medicine with the medicine name sort by the medicine name. Note: here is M to M relationship.

Retrieve the pill for each customer containing his$/$her name and the total price for all bought medicines sort by total price and then fetch only $3$ highest ones.

Retrieve the location of the pharmacies and the location for the employees using one query.

Retrieve the information of employees who live in the same location as the pharmacy.

Note: Submit the SQL Code for each exercise with a screenshot of the result.Oracle plz