Create a table for the following schema and insert at least 5 records in to the
tables?
Programmer(programmer_name,date_of_birth,date_of_joining,gender,profe
ssion1,profession2,salary)
Studies(programmer_name,study_place,course_name,Course_cost)
Software(programmer_name,title_of_software,platform_used,Selling_cost,
development_cost,no_of_products_sol
Display the names and ages of programmers
Which female programmer earning more than 3000 doesn’t know C+
+, Oracle or dbase
Which institute has the most number of students
Display language wise count of prof1
Display the number of people born in each year
Display details of programmers draw 2000-4000
Display the programmers name and their software’s
What is the highest numbers of copies sold by a package
Display each institute name with number of students
Display the number of people born in each month
What are the languages known by male programmers
Display lowest course fee
Which course has been done by most of the students
Display each institute name with number of courses, average cost per
course
Display the number of people studied in each institute
Display the details of software developed by Ramesh?
How many people draw 2000-4000
Which is the costliest software developed in .NET
Display the sales cost of the software’s developed by each
programmer
Which language have been stated as prof1 by most of the
programmers
What is the price of the costliest software developed in BASIC?
Display the details of programmers who don’t know Fortran, Cobol
or .NET
Display the names of programmers whose names contains up to 5
characters
Display the number of softwares sold by each programmer
How old is the oldest male programmer
Identify and include the keys (Primary Keys & Foreign Keys) in the
tables
Display the names of programmers who have done the DAP course
How many female programmers knowing Cobol have more than 2
years experience
Display the number of software’s in each language except C and C++
How many programmers don’t know .NET and C
Display the details of software’s whose sales have been crossed 2000
mark
Display the names of male and female programmers
Display the name of the highest paid programmers for each language
Display the selling cost of software’s developed in each language
Calculate the experience in years for each programmer and display
along with their names in descending order
Prepare all PL/SQL Programs?
