Programming Company B. The Things of Interest, ('THINGS'), include :-

1. invoices (invoice id, project id, money value, date)

2. Clients(clientid, anme ,address,telephone)

3. Projects(start date, end date, client id, project id, total cost, project Address)

4. Programmer (programmerid,name,addess,Hire date,birth date)

C. These THINGS_OF_INTEREST are Related as follows :-

a) A CLIENT can have zero, one or many PROJECTS

b) A PROJECT can have many PROGRAMMER but at least one.

c) A PROJECT can have zero, one or many invoices

d) PROGRAMMER can work on many PROJECTS but at least one.

e) the invoice for only one project and paid by only one client.

=============================================================

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

1. Which PROJECTS is a specific member of PROGRAMMER working on ?

2. For each project, display the name and address of his client.

3. Display the name of the programmer who working in more than three projects

4. Display the name of client who have more than two projects.

5. For each project. Display details of payment for it: including money value, date of payment.

6. Display name of the programmer whose address is the same of the address of the project he working on.

7. Display the average number of projects for each programmer

8. For each programmer, display his name, address, and the number of projects he working on and not finished yet.

9. Display details information(project id, client name,cost,total payment) about the projects that will finish tomorrow.

10. Display the client id ,name ,address who paid for his projects less than 20000.