Create a table named PROGRAMMERS with the following structure:

i) Display the name of the programmer, which has the highest salary.
ii) Update the salary of all programmer by 2000 whose name start with letter 'R'.

How many input combinations can be there in the truth table of a logic system having(N) input binary variables?

Why are NAND and NOR gates called Universal gates?

Consider the following supplier table:
TABLE: Supplier

Write a query to find all suppliers, who reside in Noida and also give the resultant table.

What is the need of normalization?

Observe the following table carefully and write the names of the most appropriate columns, which can be considered as (i) candidate keys and (ii) primary key.
Table: Product

Convert \((\overset { \_ \_ \_ \_ \_ \_ \_ }{ \bar { X } .Y } ).(\overset { \_ \_ \_ \_ \_ \_ \_ \_ }{ \bar { X } .\bar { Z } } )\) into canonical Sum of Products form

Write SQL queries for (a) to (f) and write the outputs for (g) parts (i) to (iv) on the basis of tables APPLICANTS and COURSES.
TABLE: APPLICANTS

TABLE: COURSES 

(a) To display NAME, FEE, Gender, JOINYEAR about the APPLICANTS, who have joined 
before 2010.
(b) To display the names of applicants, who are paying FEE more than 30000.
(c) To display the names of all applicants in ascending order of their joinyear.
(d) To display the year and the total number of applicants joined in each year
from the table APPLICANTS>
(e) To display the C_ID and the number of applicants registered in the course 
from the APPLICANTS table.
(f) To display the applicant's name with their respective course's name from the 
tables APPLICANTS and COURSES.
(g) Give the output of the following SQL statements:
(i) SELECT NAME,JOINYEAR FROM APPLICANTS WHERE GENDER='F' AND C_ID='A02';
(ii) SELECT MIN(JOINYEAR) FROM APPLICANTS WHERE GENDER='M';
(iii) SELECT AVG(FEE) FROM APPLICANTS WHERE C_ID='A01' OR C_ID='A05';
(iv) SELECT SUM(FEE), C_ID FROM APPLICANTS GROUP BY C_ID HAVING COUNT(*)=2;

Consider the following tables GARMENT and FABRIC. Write SQL commands for the statements (a) to (d) and give outputs for SQL queries (e) to (h).
TABLE: GARMENT

TABLE: FABRIC 

(a) To display GCODE and DESCRIPTION of each GARMENT in descending order of GCODE.
(b) To display the details of all the GARMENTs, which have READYDATE in between 08-DEC-07 and 16-JUN-08(inclusive of both the dates)
(c) To display the average PRICE of all the GARMENTs. Which are made up of FABRIC with FCODE as F03.
(d) To display FABRIC wise highest and lowest price of GARMENTS from GARMENT table.(Display FCODE of each GARMENT along with highest and lowest price.)
(e)SELECT SUM(PRICE) FROM GARMENT WHERE FCODE='F01';
(f) SELECT DESCRIPTION , TYPE FROM GARMENT, FABRIC
  WHERE GARMENT.FCODE=FABRIC.FCODE AND GARMENT.PRICE>=1260;
(g) SELECT MAX(FCODE) FROM FABRIC;
(h) SELECT COUNT(DISTINCT PRICE) FROM GARMENT;

Write SQL commands for (a) to (f) and write the outputs for (g) on the basis of table STUDENT
TABLE: STUDENT 

(a) List the name of all students, who have taken stream as COMPUTER.
(b) To count the number of female students.
(c) To display the number of students stream wise.
(d) To insert a new row in the STUDENT table
9,'KARISHMA','ECONOMICS',300.18,'F'
(e) To display a report, listing NAME, STREAM,SEX and stipend, where stipend is 20% of fees.
(f) To display all the records in sorted order of name.
(g) Give the output of the following SQL statements based on STUDENT table:
  (i) SELECT AVG(FEES) FROM STUDENT WHERE STREAM='COMPUTER';
  (ii) SELECT MAX(AGE) FROM STUDENT;
 (iii) SELECT COUNT(DISTINCT STREAM) FROM STUDENT;
 (iv) SELECT SUM(FEES) FROM STUDENT GROUP BY STREAM;

Study the following tables DOCTOR and SALARY and write SQL commands for the equations (a) to (d) and give outputs for SQL queries (e) and (f) 
TABLE: DOCTOR 

TABLE: SALARY 

(a) Display NAME of all doctors who are in MEDICINE department having more than 10 yrs experience from the table DOCTOR.
(b) Display the average salary of all doctors working in ENT department using the tables DOCTOR and SALARY.SALARY=BASIC+ ALLOWANCE.
(c) Display the minimum ALLOWANCE of female doctors.
(d) Display the highest consultation fee among all male doctors.
(e) SELECT COUNT(*) FROM DOCTOR WHERE SEX='F';
(f) SELECT NAME, DEPT, BASIC FROM DOCTOR, SALARY
WHERE DEPT='ENT' AND DOCTOR.ID=SALARY.ID;

Write SQL commands for (a) to (g) on the basis of the table SPORTS
TABLE: SPORTS 

(a) Display the names of the students, who have grade 'C' in either GAME1 or GAME2 or both.
(b) Display the number of students getting grade'A' in cricket.
(c) Display the names of the students who have same game for both GAME1 and GAME2.
(d) Display the games taken up by the students, whose name starts with 'A'.
(e) Add a new column names MARKS.
(f) Assign a value 200 for Marks for all those who are getting grade 'B' or grade 'A' in both GAME1 and GAME2.
(g) arrange the whole table in the alphabetical order of NAME.