Question:

1. A software company has the following...

by  |  earlier

0 LIKES UnLike

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:

   Report
Please Login to view 1 answers to this question

Question Stats

Latest activity: earlier.
This question has 1 answers.

BECOME A GUIDE

Share your knowledge and help people by answering questions.