Computer Science & Informatics Practices - KV

Assignment of Database Concepts 01.    Differentiate between primary key and candidate key. 02.    Differentiate between char and varchar. 03.    What is the importance of primary key in a table? Explain with suitable example. 04.    A table 'student1' has 4 columns and 10 rows and 'student2' has 5 columns and 7 rows. If we take Cartesian product of these two tables, what is the degree and cardinality of the resultant table? 05.    A table 'customer' has 10 columns but no row. Later, 10 new rows are inserted and 3 rows are deleted in the table. What is the degree and cardinality of the table 'customer? 06.    What all are domain name possible in gender? 07.    In the following two tables, find the union value of employee and emp. Employee Emp.No. Name Salary 1000 Abishek Garg 25000 222 Prachi Goal 30000 1002 Simran Dua 25000 ...

22/Oct/2014 (KV Balasore 2014-15) XII B (CS) 1). What is the difference between call by reference and call by value with respect to memory allocation ? Give a suitable example to illustrate using C++. 2). Define a class Competition in C++ with the following descriptions: Data Members: Event_no integer Description char(30) Score integer qualified char Member functions: - A constructor to assign initial values Event_No number as 101, Description as “State level”, Score is 50 and qualified as ‘N’. - Input(), To take the input for event_no, description and score. - Award(int), To award qualified as ‘Y’, if score is more than the cutoffscore passed as argument to the function else ‘N’. - Show(), To display all the details. 3). Obtain output from following program after including the desired header files. int main( ) { int array [ ]={ 2, 3, 5, 6}; int *arptr = array; int value =*arptr;  cout<<value<<'\t'; value = *...

Diwali Assignments - 22/Oct/2014 (KV Balasore 2014-15) XII C (IP) WEB APPLICATION DEVELOPMENT TYPE A: VERY SHORT ANSWER QUESTION 1.  In the URL, http://www.mycorp.com/pr/master.htm, whatis the http component? 2.  In the URL, http://www.mycorp.com/pr/master.htm, whatis the www.mycorp.com component? 3.  In the URL, http://www.mycorp.com/pr/master.htm, whatis the /pr/master.htm component? 4.  What do you mean by Web Browser, and  Web Server? 5.  Which protocol is used to upload/ transfer the file from host to server Internet? 6.  What is WWW? How does it function? 7.  A  web  browser  &  web  server are  an  application  of  client/server  computing  concept.  Comment  on these statements? 8.  What is URL ? What are its components?  Exemplify? Basic HTML Components  TYPE A: VERY SHORT ANSWER QUESTION 1.  What is HTML? Why ...