Hardware Company

C. Information about the system

C.1 Each Client purchases one or many Items.

C.2 Each Client can deal with one or many Staff.

C.3 Each Staff can deal with one or many Clients.

C.4 Each item can be shipped by many suppliers

c.4 Each Staff deal with one and only one item

Requirements :-

Draw relationship between entities using Edraw Max , then Create tables using oracle,. After that write 10 SQL statements to perform these queries.

1- Find the clients who have purchased any of the items named "Central Processor" "Memory", "Hard Disk" and have purchased a total quantity of all these items above 1000.

2- Find out the StaffNumber and names of those members who have been dealing with the times which has been sold the maximum quantity.

3- displays the total number of Staff member in the company

4- Perform a report that display information about Staff member that take salary && his Hier date is before 3 year Name an employee who takes a salary of less than EGP 1500 and has been appointed for more than three years

5-increase (update) the salary of Staff member who work for 10 years ago with 0.25 from their original salary Increase the salaries of employees who have been appointed for 10 years by 25% of the original salary

6- display the number of sold items in each order

7- displays the name of item in which the maximum quantity has been sold

(Name of the product from which the largest number was sold)

8- display the number of orders that has been requested for each client.

9-Perform a report that display the supplier name who provide us with the item that is with minimum price.Name the supplier that offers items at the lowest price

10- display number of items that are bought in the last two month along with their suppliers And the names of the suppliers who provided these items in the number of items

last two months