DATE OF SUBMISSION: 20/11/2017

CLICK HERE TO DOWNLOAD HOMEWORK

_________________________________________________________________________

DATE OF SUBMISSION: 06/11/2017

CLICK HERE TO DOWNLOAD HOMEWORK

_________________________________________________________________________

CLICK HERE TO DOWNLOAD HOMEWORK

DATE OF SUBMISSION: 18/08/2017

_________________________________________________________________________

C++ programming
1. What are C token?
2. What are the rules of defining an identifier?
3. What are the different types of operators in C++
4. Write notes on conditional and assignment operators?
5. Differentiate between pre increment and post increment operators in C++.
_______________________________________________________________________________

DATE OF SUBMISSION: 07/07/2017
1. What is ISCII
2. Differentiate between ASCII and UNICODE
3. Convert 100101 in binary to hexadecimal, decimal and octal number system
4. Express FACE in hexa decimal to binary,  decimal and octal number system
5. Express 6723 in octal to binary,  decimal and hexadecimal number system
_______________________________________________________________________________

DATE OF SUBMISSION: 27/07/2017

1.What is the features of first generation, second generation and third generation computers.
2.What is parallel processing
3.Differentiate between analog and digital computers.
4.What are embedded computers?
5.What is artificial intelligence?
_____________________________________________________________________________


DATE OF SUBMISSION: 12/07/2017

1.Which are the different types of OS
2. Differentiate application software and system software
3. List out few input output devices.
4. Give examples for language processors
___________________________________________________________________________

DATE OF SUBMISSION: 28/06/2017


Write a paragraph on Computers in our daily life

Date of Submission:  22.02.2017

1. Consider the following table employees. Write SQL commands for the

            statements (i) to (v)

            Employees

Empid	Firstname	Lastname	Address	City
010	Ravi	Kumar	Raj nagar	GZB
105	Harry	Waltor	Gandhi nagar	GZB
152	Sam	Tones	33 Elm St.	Paris
215	Sarah	Ackerman	440 U.S. 110	Paris
244	Manila	Sengupta	24 Friends street	New Delhi

           

            Write the SQL commands for the following :

(i)                 To show firstname,lastname,address and city of all employees living in paris                                              

(ii)               To display the content of Employees table in descending order of Firstname.                                             

(iii)             To delete the employee whose empid is 152 .

       (iv )    To display the details of those employees whose name ends with the letter ‘r’ .

       (v)       To count the number of employees who lives in New Delhi.

Date of submission: 25.02.2017 

1.. Consider the following tables BOOKS. Write SQL commands for the statements (i) to (iv) .

BOOKS                                                                                                                                 

Book_Id	Book_Name	Author_Name	Publishers	Price	Type	Quantity
C01	Fast Cook	Lata Kapoor	EPB	355	Cookery	5
F01	The Tears	William Hopkins	First	650	Fiction	20
T01	My C++	Brain & Brooke	FPB	350	Text	10
T02	C++ Brain	A.W.Rossaine	TDH	350	Text	15
F02	Thuderbolts	Anna Roberts	First	750	Fiction	50

                       

1.      To list the names from books of Text type.                                                                           

2.      To display the names and price from books in ascending order of their price.                     

3.      To increase the price of all books of EPB publishers by 50.                                                  

4.      To display the details of those books whose price is between 300 and 600.

5.      To increase the price of all books by 100 where is publisher is EPB

 DATE OF SUBMISSION: 04 -02-2017

Answer Qno. 5 and Q no. 6 of UNIT test III

DATE OF SUBMISSION :15-02-2017

 Write the output that the following statements will produce:
a) SELECT ROUND(7.3456, 2);
b) SELECT TRUNCATE(2.3456, 2);
 c) SELECT DAYOFMONTH('2009-08-25');
d) SELECT MONTH('2010-02-26');
e) SELECT RIGHT('Informatics', 4);

DATE OF SUBMISSION :13-02-2017

Write SQL statements to do the following:
 a) Using the three separate words "We," "study," and "MySQL," produce the following output:          "We  study MySQL"
 b) Use the string "Internet is a boon" and extract the string "net".
 c) Display the length of the string "Informatics Practices".
 d) Display the position of "My" in "Enjoying MySQL".
 e) Display the name of current month.
f) Display the date 10 years from now. Label the column "Future."
g) Display the day of week on which your birthday will fall or fell in 2010.

DATE OF SUBMISSION: 05.02.2017

FIND OPUTPUT OF THE FOLLOWING

 (i) Select length(“computer”)
 (ii) Select  right(“computer”, 3)
 (iii) Select mid(‘computer’, 3,2)
 (iv) Select power(5,2)
 (v) Select round(143.562,1)
 (vi) Select dayofmonth(‘2012-05-11’);
 (vii) Select month(‘2010-02-07’); 

IP HOMEWORK JANUARY 2017

HOMEWORK 1 :
SUBMISSION DATE 10/01/2015
1A)Differentiate between DDL and DML queries in SQL.
1 b) A relation in MySQL has 5 attributes and 8 tuples. What will be the cardinality and degree of the relation?
1 c) What is the difference between Candidate key and Alternate Key in a Relation?

HOMEWORK 2
SUBMISSION DATE 15/01/2015
 2 a) Give one word answer to the following questions:
 i. An attribute that is a Primary key of one table and used as non‐key attribute in another table.
ii. A SQL command used to display the structure of a table in MySQL
iii. A SQL command used to remove duplicate rows from a SELECT query.
 iv. An SQL query that uses SET command to make modification on table data.

2 b) What is a Column alias in SQL? Give an example of using column alias in a query

HOMEWORK 3
SUBMISSION DATE 25/01/2017

Q.3 a) What will be the output of the following SQL queries:
 i. SELECT MID('AVATAR',3,2)
 ii. SELECT CHAR(66,65,68)
 iii. SELECT DAYOFYEAR('2011‐12‐31')
 iv. SELECT ROUND(15.15, ‐1)

HOMEWORK 4 
 4 ) Study the following table’s  structure and answer the given questions.

Column Name	Data type	Size	Constraints	Description
V_id	BIGINT	8	Primary key	Voter identification
Vname	VARCH AR	25	Not null	Name of the voter
Age	INT	3	Check>17	Age should not less than equal to 17
Address	VARCH AR2	30		Address of voter
Phone	VARCH AR	10		Phone number of the voter

write SQL statements to create the above table.

(i)             Write the command to delete all the rows of particular voter from the table voter where voter ID between 10 and 20.

(ii) Display the voter details in descending order of voter names

(iii)Display the names of all voters between 17 and 25 years.

(iv) Display all voter names ending to a.

(v)Delete the voter with V_id=123456

5)Study the following table’s structure and answer the given questions.
Table: STUDENT
Column name        Data type         Limit                  Constraint
ROLLNO                Integer             4 digits                Not Null
SNAME                 Varchar              25 characters       Not Null
GENDER               Char                    1                      Not Null
DOB                     Date                                            Not Null
HOUSEID             Integer                  2                      Not Null
FEES                   Integer                4 digits                Not Null
HOBBY                Varchar               15 characters         Null
Primary Key is ROLLNO
i. Write SQL query to create the STUDENT table. (2)
ii. Write SQL query to increase the size of the SNAME to hold 30
characters (2)

iii. Write SQL query to insert a row in the student table. (2)