Assignment on Database Concepts - XII CS
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 ...