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 1500

5-increase (update) the salary of Staff member who work for 10 years ago with 0.25 from their original salary 10 25 %

6- display the number of sold items in each order

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

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

9-Perform a report that display the suppliername who provide us with the item that is with minimum price.

10- display number of items that are bought in the last two month along with their suppliers .