12th-D CS October Monthly test blue print

Max Marks: 35  Date:31/10/2017    1hour 30minutes

Boolean Algebra (8 + 4 + 8 +12 + 3 = 35 marks)

1)Expression to Circuit/Boolean Circuit to Expression:  2 + 2 +2+2=8 marks ( 4 questions)

2)  Writing SOP & POS Expression (3 variables): 1+1+1+1 = 4 marks (4 questions)

3)  Boolean Laws verification (truth table /Laws): 2 + 2+2+2 =8 marks ( 4 questions( any 4 laws) )

4)  K-Map SOP & POS simplifying expression: 3 + 3 +3 + 3= 12 marks (2 SOP problems and 2 POS problems)

5) Additional gates symbol and truth table of 2 variables - 3 marks (any three)

Reference: 12th Computer Science (C++) by Sumita Arora - It is not a NCERT text book, it is reference only.

and CBSE Board papers.

11th D CS Half Year Theory Exam pattern

Total Marks: 70                 Duration: 1hour 30minutes     Date:30/10/2017

Q1. Computer Fundamental  - 20 marks (10 questions)

Chapter-01 Computer Fundamental

Chapter-02 Software Concepts

Chapter-03 Data Representation

Chapter-04 Microprocessor


Q2. Introduction to C++  16 marks ( 7 questions)

Q3. Introduction to C++  13 marks (6 questions) 

Chapter-06 Getting Started with C++

Chapter-07 Data Handling

Chapter-08 Operator and Expression

Q4. Chapter - 14 Programming Methodology 21 marks ( 8 questions)





Reference: 11th Computer Science (C++) by Sumita Arora- It is not a NCERT text book, it is reference only

MONTHLY TEST OCTOBER 2017-18 TIME TABLE FOR CLASS XII

DATE	DAY	SUBJECT
25/10/17	WEDNESDAY	ENGLISH
26/10/17	THURSDAY	HINDI/SANSKRIT
27/10/17	FRIDAY	PHYSICS
28/10/17	SATURDAY	CHEMISTRY
30/10/17	MONDAY	MATHS
31/10/17	TUESDAY	COMP.SCI/BIO./IP

SQL-4 TWO TABLE PROBLEMS

SQL-4 Outside Delhi (2015) Consider the following Dept and Employee tables.  Write SQL queries for (1) to (4) and find outputs for SQL queries (5) to (8).

Table: Dept

DCODE	DEPARTMENT	LOCATION
D01	INFRASTRUCTURE	DELHI
DO2	MARKETTING	DELHI
D03	MEDIA	MUMBAI
D05	FINANCE	KOLKATA
D04	HUMAN RESOURCE	MUMBAI

Table: Employee

ENO	NAME	DOJ	DOB	GENDER	DCODE
1001	GEORORGE K	01-SEPT-2013	01-SEPT-1991	MALE	D01
1002	RYMA SEN	11-DEC-2012	15-DEC-1990	FEMALE	D03
1003	MOHITESH	03-FEB-2013	04-SEPT1987	MALE	D05
1007	ANILA JHA	17-JAN-2014	19-OCT-1984	MALE	D04
1004	MANILA SAHAI	09-DEC-2012	14-NOV-1986	FEMALE	D01
1005	R SAHAY	18-NOV-2013	31-MAR-1987	MALE	D02
1006	JAYA PRIYA	09-JUNE-2014	23-JUNE-1985	FEMALE	D05

CREATE TABLE DEPT1
( DCODE CHAR(3),
DEPARTMENT CHAR(15),
LOCATION CHAR(8));

INSERT INTO DEPT1 VALUES('D01','INFRASTRUCTURE','DELHI');
INSERT INTO DEPT1 VALUES('D02','MARKETING','DELHI');
INSERT INTO DEPT1 VALUES('D03','MEDIA','MUMBAI');
INSERT INTO DEPT1 VALUES('D05','FINANACE','KOLKATA');
INSERT INTO DEPT1 VALUES('D04','HUMAN RESOURCE','MUMBAI');

CREATE TABLE EMPLOYEE1
( ENO CHAR(4),
ENAME CHAR(15),
DOJ DATE,
DOB DATE,
GENDER CHAR(6),
DCODE CHAR(3));

INSERT INTO EMPLOYEE1 VALUES('1001','GEORORGE','01-SEP-13','01-SEP-91','MALE','D01');
INSERT INTO EMPLOYEE1 VALUES('1002','RYMA SEN','11-DEC-12','15-DEC-90','FEMALE','D03');
INSERT INTO EMPLOYEE1 VALUES('1003','MOHITESH','03-FEB-13','04-SEP-87','MALE','D05');
INSERT INTO EMPLOYEE1 VALUES('1007','ANILA JHA','17-JAN-14','19-OCT-84','MALE','D04');
INSERT INTO EMPLOYEE1 VALUES('1004','MANILA SAHAI','09-DEC-12','14-NOV-86','FEMALE','D01');
INSERT INTO EMPLOYEE1 VALUES('1005','R SAHAY','18-NOV-13','13-MAR-87','MALE','D02');
INSERT INTO EMPLOYEE1 VALUES('1006','JAYA PRIYA','09-JUN-14','23-JUN-85','FEMALE','D05');

Q01 - To display Eno, Name, Gender from the table EMPLOYEE in ascending of Eno.
Ans: SELECT ENO,ENAME,GENDER FROM EMPLOYEE1 ORDER BY ENO;

Q02 - To display the Name of all the MALE emloyees from the table EMPLOYEE.
Ans: SELECT NAME FROM EMPLOYEE WHERE GENDER='MALE';

Q03 - To display the Eno and Name of those employees from the table EMPLOYEE   who are born between  '01-JAN-87' and '01-DEC-91'.
Ans: SELECT ENO,ENAME FROM EMPLOYEE1 WHERE DOB BETWEEN '01-JAN-87' AND '01-DEC-91';

Q04 - To  count and display FEMALE employees who have joined after '01-JAN-86'.
Ans: SELECT COUNT(*) FROM EMPLOYEE1 WHERE GENDER='FEMALE' AND DOJ>'01-JAN-86';


Q05 - SELECT COUNT(*), DCODE FROM EMPLOYEE GROUP BY DCODE HAVING COUNT(*)>1;
Ans: COUNT      DCODE
           2                  D01
           2                  D05

Q06 - SELECT DISTINCT DEPARTMENT FROM DEPT;
Ans: Department
         INFRASTRUCTURE
         MARKETTING
         MEDIA
         FINANCE
        HUMAN RESOURCE

Q07 - SELECT NAME, DEPARTMENT FROM EMPLOYEE E  , DEPT D WHERE E.DCODE=D AND ENO<1003;
Ans:  NAME             DEPARTMENT
          George K         INFRASTRUCTURE
          Ryma  Sen        MEDIA

Q08 - SELECT MAX(DOJ), MIN(DOB) FROM EMPLOYEE;
Ans: MAX(DOJ)              MIN(DOB)
        09-JUN-14                19-OCT-84

SQL- 3 TWO TABLE PRACTICAL

(2014) OUTSIDE DELHI

Table: SHOPEE

Id	SName	Area
S001	ABC Computronics	CP
S002	All Infotech Media	GK II
S003	Tech Shoppe	CP
S004	Greeks Tecno Soft	Nehru Place
S005	Hitech Tech Store	Nehru Place

create table shoppe
(Id character(10),
 Sname character(30),
 Area character(20)
);


insert into shoppe values('S001','ABC Computeronics','CP');

insert into shoppe values('S002','All Infotech Media','GK II');

insert into shoppe values('S003','Tech Shoppe','CP');

insert into shoppe values('S004','Geeks Techno Soft','Nehru Place');

insert into shoppe values('S005','Hitech Tech Store','Nehru Place');

Table: Accessories:

No	Name	Price	Id
A01	Mother Board	12000	S001
A02	Hard Disk	5000	S001
A03	Keyboard	500	S002
A04	Mouse	300	S001
A05	Mother Board	13000	S002
A06	Keyboard	400	S003
A07	LCD	6000	S004
T08	LCD	5500	S005
T09	Mouse	350	S005
T10	Hard Disk	4500	S003

create table accessories
(No character(5),
 Name character(30),
 Price decimal,
 Id character(5)
);

insert into accessories values('A01','Mother Board',12000.00,'S001');
insert into accessories values('A02','Hard Disk',5000.00,'S001');
insert into accessories values('A03','Key Board',500.00,'S002');
insert into accessories values('A04','Mouse',300.00,'S001');
insert into accessories values('A05','Mother Board',13000.00,'S002');
insert into accessories values('A06','Keyboard',400.00,'S003');
insert into accessories values('A07','LCD',6000.00,'S004');
insert into accessories values('T08','LCD',5500.00,'S005');
insert into accessories values('T09','Mouse',350.00,'S005');
insert into accessories values('T10','Hard Disk',4500.00,'S003');

Q.1  To display Name and Price FROM Accessories in ascending order of their Price.
Ans. SELECT NAME,PRICE FROM ACCESSORIES ORDER BY PRICE;

Q.2  To display Id, SName of  all shopee located in Nehru Place
Ans: SELECT ID,SNAME FROM SHOPPE WHERE AREA='Nehru Place';

Q.3. To display Minimum and Maximum Price of each Name of Accessories.
Ans:  SELECT NAME,MIN(PRICE),MAX(PRICE) FROM ACCESSORIES GROUP BY NAME;

Q.4 To display Name, Price of all Accessories and their respective SName where they are available.
Ans:  SELECT NAME,PRICE,SNAME FROM ACCESSORIES A , SHOPPE S WHERE A.ID=S.ID;

12-C October -2017 Monthly Test Blue-Print

12th-C October -2017 Monthly Test Blue-Print .  Max Marks:  35marks , Duration : 1 Hour 30minutes
Date: 31/10/2017  Time: 1.00PM to 2.30PM

I DBMS Concepts-  11 marks

*  Relational model, Tupple, Attribute, Degree, Cardinality,  Selectioon(   ), Projection (π),  Candidate Key, Primary Key, Alternate Key, Foriegn Key, Relational Algebra: Union, Intersection, cartesian product, difference.

a) Any two concepts as per the board pattern- 2+2=4 marks

b) Any two concepts as per the board pattern- 2 marks

c) Any two concepts as per the board pattern- 2+1=3 marks

d) Any two concepts as per the board pattern- 2 marks

SQL COMMANDS : CREATE TABLE, DROP TABLE, ALTER TABLE, UPDATE...SET...,INSERT, DELETE;
SLECT, DISTINCT, FROM WHERE, IN, BETWEEN, GROUP BY, HAVING, ORDER BY;

SQL FUNCTIONS: SUM, AVG, COUNT, MAX and MIN

II SQL  4+2 =6+6=12 marks   (As per the Board Pattern)
Table1 and Table2

a) Writing sql query  with the help description, refering Table1  and Table2  - 1 mark
b) Writing sql query  with the help description, refering Table1  and Table2  - 1 mark
c) Writing sql query  with the help description, refering Table1  and Table2  - 1 mark
d) Writing sql query  with the help description, refering Table1  and Table2  - 1 mark

e) Writing Output for the sql query, refering Table1 and Table2 -   ½ mark
f) Writing Output for the sql query, refering Table1 and Table2 -   ½ mark
g) Writing Output for the sql query, refering Table1 and Table2 -   ½ mark
h) Writing Output for the sql query, refering Table1 and Table2 -   ½ mark

III SQL  4+2 =6+6=12 marks   (As per the Board Pattern) (one more set  as per IInd Question)
Table1 and Table2

a) Writing sql query  with the help description, refering Table1  and Table2  - 1 mark
b) Writing sql query  with the help description, refering Table1  and Table2  - 1 mark
c) Writing sql query  with the help description, refering Table1  and Table2  - 1 mark
d) Writing sql query  with the help description, refering Table1  and Table2  - 1 mark

e) Writing Output for the sql query, refering Table1 and Table2 -   ½ mark
f) Writing Output for the sql query, refering Table1 and Table2 -   ½ mark
g) Writing Output for the sql query, refering Table1 and Table2 -   ½ mark
h) Writing Output for the sql query, refering Table1 and Table2 -   ½ mark

  

11-D CS Half Yearly Practical Exam Problems, Date of Exam ; 16/10/2017, Monday

11-D Half Yearly Practical Exam Problems Date of Exam ; 16/10/2017, Monday, Max Marks:30

Ist Batch: 8.30AM to 11.30AM   and  IInd Batch 11.40 to 2.40PM

11-D Program-7 Write a program to read the value of a variable of a quadratic equation and find the discriminant and give the root of the quadratic equation.

11-D Program-8 Write a program to input number of week days (1-7) and translate to its equivalent name of the week. (1 to Monday, 2 to Tuesday……7 to Sunday)

11-D Program-9 Write an algorithm and program to check whether a given number is palindrome or not.

11-D program-10 Write a algorithm and program to calculate area of rectangle, circle and triangle depending upon the user choice

12-C Two Table General Syntax

 Two Table General Syntax and Example:

SELECT  T2C,  T1C,  FROM  TABLE2  T2,  TABLE1 T1 WHERE T2..PKEY=T1..FKEY  CONDITION

EXAMPLE:
SELECT NAME, DEPARTMENT FROM EMPLOYEE E, DEPT D WHERE E.DCODE=D.DCODE AMD ENO<1003;      (OD. 2015)

SELECT  PNAME, SNAME FROM PRODUCTS P , SUPPLIERS S WHERE P.SUPCODE=S.SUPCODE AND QTY>100;  (OD 2013

12 - C SQL-2 PROGRAM

2.       Given the following tables for a database FURNITURE:

Table1: FURNITURE

No	Item_name	Type	Date of stock	Price	Discount
1	White lotus	Double bed	23-FEB-02	30000	25
2	Pink feather	Baby cot	20-JAN-02	7000	20
3	Dolphin	Baby cot	19-FEB-02	9500	20
4	Decent	Office table	01/01/02	25000	30
5	Comfort zone	Double bed	12/01/02	25000	25
6	Donald	Baby cot	24/02/02	6500	15
7	Royal finish	Office table	20/02/02	18000	30
8	Royal tiger	Sofa	22/02/02	31000	30
9	Econo sitting	Sofa	13/12/01	9500	25
10	Eating paradise	Dining table	19/02/02	11500	25

create table FURNITURE

(

 No integer,

 Item_name char(15),

 Type char(15),

 DOS date,

 Price decimal,

 Discount integer

);

insert into FURNITURE values( 1,'WHITE LOTUS','DOUBLE BED','23-FEB-02',30000.00,25);

insert into FURNITURE values( 2,'PINK FEATHER','BABY COT','20-JAN-02',7000.00,20);

insert into FURNITURE values( 3,'DOLPHIN','BABY COT','19-FEB-02',9500.00,20);

insert into FURNITURE values( 4,'DECENT','OFFICE TABLE','01-JAN-02',25000.00,30);

insert into FURNITURE values( 5,'COMFORT ZONE','DOUBLE BED','12-JAN-02',25000.00,25);

insert into FURNITURE values( 6,'DONALD','BABY COT','24-FEB-02',6500.00,15);

insert into FURNITURE values( 7,'ROYAL FINISH','OFFICE TABLE','20-FEB-02',18000.00,30);

insert into FURNITURE values( 8,'ROYAL TIGER','SOFA','22-FEB-02',31000.00,30);

insert into FURNITURE values( 9,'ECONO SITTING','SOFA','13-DEC-01',9500.00,25);

insert into FURNITURE values( 10,'EATING PARADISE','DINING TABLE','19-FEB-02',11500.00,25);

Table 2: Arrivals

No	Itemname	Type	Dateofstock	Price	Discount
11	Wood comfort	Double bed	23/03/03	25000	25
12	Old fox	Sofa	20/02/03	17000	20
13	Micky	Baby cot	21/02/03	7500	15

create table ARRIVALS

(No integer,

 itemname character(15),

 type character(15),

 DOS date,

 Price decimal,

 Discount integer);

insert into ARRIVALS values( 11,'WOOD COMFORT','DOUBLE BED','23-MAR-   03',25000.00,25);

 insert into ARRIVALS values(12,'OLD FOX','SOFA','20-FEB-03',17000.00,20);

 insert into ARRIVALS values( 13,'MICKY','BABY COT','21-FEB-03',25000.00,25);

I  Write SQL queries for Q1 to Q6:

a   Q1.  To show all information about Baby cots from the FORNITURE table.

      Ans: SELECT * FROM FURNITURE WHERE TYPE='BABY COT';

b   Q2.  To list the Itemname which are priced more than 15000 from the FURNITURE table.

      Ans: SELECT ITEM_NAME FROM FURNITURE WHERE PRICE>15000;

c    

      Q3. To list the Itemname and Type of those items, in which Dateofstock is before 22/01/02 from the FURNITURE table in descending order of Itemname.

      Ans: SELECT ITEM_NAME,TYPE FROM FURNITURE WHERE DOS<'22-JAN-02' ORDER BY ITEM_NAME DESC;

d    

       Q4. To display the Itemname and Dateofstock of those items, in which Discount percentage is more than 25 from FURNITURE table.

      Ans: SELECT ITEM_NAME,DOS FROM FURNITURE WHERE DISCOUNT>25;

e   

        Q5.  To count the number of items, whose Type is “Sofa” from FURNITURE table.

A       Ans:    SELECT COUNT(*) FROM FURNITURE WHERE TYPE='SOFA';

         Q6. To insert a new row in the ARRIVALS table with the following data :

           14, “Velvet touch”, “Double bed”, {25/03/03}, 25000, 30

    Ans:  insert into arrivals values( 14,'Velvet touch', 'Double bed', '25-MAR-03', 25000.00,30);

g

        II   Give the output of the following SQL statements :

                                    i.            Select count(distinct Type) from FURNITURE;

                                Ans: 5:     A

                                   ii.            Select max(Discount) from FURNITURE;

                                Ans: 30

                                  iii.            Select avg(Discount) from FURNITURE where type=”BABY COT”;

                              Ans: 18.3333

                                   iv.            Select sum(price) from FURNITURE where DOS< '12-FEB-02';

       Ans: 66500