1. Asoftware company has the following information about its clients and theprojects given by them: Clients (client number, client name, address)Projects(project number, project name, total investment, no. of people working on theproject)Client project(client number, project number, date of startof project) Create a database with the tables given above. Give suitablefield names, keys and validation checks. Create data entry forms and enter at least 10 rows.Run thefollowing queries on the above database:a) List details of projects startedafter 1st January 2006.b) List clients who have assigned morethan 2 projects to the software company.c) List clients in order of decreasingtotal project investment.d) Show the details of the project with the maximum number of people working onthe it.
Tags: