|
Computer Science
Class XII 2000(CBSE)
You are on questions 4 to 7
Q 4 (a)Name two member functions of ofstream class.
Q 4 (b) Assuming the class DRINKS
defined below, write functions in C++ to perform the following:
(i)Write the objects of DRINKS to a binary
file.
(ii) Read the objects of DRINKS from binary file and display them
on screen when DNAME has value "INDY COLA". class DRINKS
{
int DCODE;
char
DNAME[13]; //Name of the drink
int DSIZE; //Size
in liters float DPRICE;public:void
getdrinks( )
{cin>>DCODE>>DNAME>>DSIZE>>DPRICE;}
void
showdrinks(
)
{cout<<DCODE<<DNAME<<DSIZE<<DPRICE<<endl;}
char
*getname( ){return DNAME;} };
Q 5. (a) What is the need for normalistion? Define third normal
form.
Write SQL commands for (b) to (e) and write the
outputs for (g) on the basis of table CLUB.
Table: CLUB
|
COACH_ID |
COACHNAME |
AGE |
SPORTS |
DATOFAPP |
PAY |
SEX |
|
1 |
KUKERJA |
35 |
KARATE |
27/03/1996 |
1000 |
M |
|
2 |
RAVINA |
34 |
KARATE |
20/01/1998 |
1200 |
F |
|
3 |
KARAN |
34 |
SQUASH |
19/02/1998 |
2000 |
M |
|
4 |
TARUN |
33 |
BASKETBALL |
01/01/1998 |
1500 |
M |
|
5 |
ZUBIN |
36 |
SWIMMING |
12/01/1998 |
750 |
M |
|
6 |
KETAKI |
36 |
SWIMMING |
24/02/1998 |
800 |
F |
|
7 |
ANKITA |
39 |
SQUASH |
20/02/1998 |
2200 |
F |
|
8 |
ZAREEN |
37 |
KARATE |
22/02/1998 |
1100 |
F |
|
9 |
KUSH |
41 |
SWIMMING |
13/01/1998 |
900 |
M |
|
10 |
SHAILYA |
37 |
BASKETBALL |
19/02/1998 |
1700 |
M |
Q 5 (b) To show all the information
about the swimming coaches in the club.
Q 5 (c)To list names of all the coaches
with their date of appointment (DATOFAPP) in descending order.
Q 5 (d) To isplay a report showing
coachname, pay, age, and bonus (15% of pay) for all the coaches.
Q 5 (e) To insert a new row in the CLUB
table with the following data: 11, "PRAKASH",37,
"SQUASH",{25/02/1998},2500, "M"
Q 5 (f) Give the output of following SQL
statements:
(i)Select COUNT (distinct SPORTS) from
CLUB;
(ii) Select MIN(AGE) from CLUB where SEX="F";
(iii) Select
AVG(PAY) from CLUB where SPORTS="KARATE";
(iv) Select SUM(PAY) from
CLUB where DATOFAPP>(31/01/98);
Q 5 (g)Assume that there is one more
table COACHES in the database as shown below:
Table: COACHES
| SPORTS
PERSON |
SEX
|
COACH_NO
|
| AJAY |
M |
1 |
| SEEMA |
F |
2 |
| VINOD |
M |
1 |
| TANEJA |
F |
3
|
What will be the output of the following query:
SELECT SPORTS PERSON, COACHNAME
FROM CLUB, COACHES
WHERE COACH_ID=COACH_NO;
Q 6. (a)State Absorption Laws. Verify one of the Absorption Laws using a
truth table.
Q 6 (b) Prove
X’.Y+Y’.Z=X’.Y.Z+X’.Y’.Z’+X.Y’.Z+X’.Y’.Z algebraically.
Q 6 (c) Obtain simplified form for a
boolean expression
F(x,y,z,w)= å(1,3,4,5,7,9,11,12,13,15) using
Karnaugh Map.
Q 6 (d) Draw the logic circuit for a
half adder.
Q 6 (e) Represent the Boolean expression
X’Y+Y’Z with the help of NAND gates only.
Q 6
(f) Write the Sum of Products form
of the function G(U,V,W). Truth table representation of G is as follows:
| U |
V |
W |
G |
| 0 |
0 |
0 |
0 |
| 0 |
0 |
1 |
0 |
| 0 |
1 |
0 |
1 |
| 0 |
1 |
1 |
1 |
| 1 |
0 |
0 |
1 |
| 1 |
0 |
1 |
0 |
| 1 |
1 |
0 |
0 |
| 1 |
1 |
1 |
1 |
Q 7 (a) What are Routers?
Q 7(b) What is the purpose of using a
Modem?
Q 7 (c) Write two advantages and two
disadvantages of Bus Topology in network.
Q 7 (d) What is the difference between
LAN and WAN?
|
