Skip to main content

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
1003
Rishkika Pal
40000
1004
Mohit Batra
23000

Emp

Emp.No.
Name
Salary
1002
Simran Dua
25000
1004
Mohit Batra
23000
1007
Sonal Gupta
26000
1009
Rohit Batia
50000


Last Date for Submission of Assignment : -  21/Nov/2014


Labels:

Popular posts from this blog

Project Work for Class XII Informatics Practices (065) - CBSE 2020-2021

  Marks  allotted : 05 Marks A. PROJECT GUIDELINES The aim of the class project is to create tangible and useful IT application. The learner may identify a real-world problem by exploring the environment. e.g. Students can visit shops/business places, communities or other organizations in their localities and enquire about functioning of the organization, and how data are generated, stored, and managed. The learner can take data stored in csv or database file and analyze using Python libraries and generate appropriate charts to visualize. If an organization is maintaining data offline, then the learner should create a database using MySQL and store the data in tables. Data can be imported in Pandas for analysis and visualization. Learners can use Python libraries of their choice to develop software for their school or any other social good. Learners should avoid plagiarism and violation of copyright issues while working on projects. Any resources (data, image etc.) used in t...
Read more

Assignments - XII Computer Science

POINTERS ASSIGNMENT Assignment Date: 09/09/15 Submission Date: 14/09/15 Q1. What will be the output of the following program: int main() { int x [ ] = { 50, 40, 30, 20, 10}: int *p, *t; p = x; t = x + 1; cout << *p << “,” << *t++; return 0; } Q2. What will be the output of the program( Assume all necessary header files are included) void print (char * p ) { p = "Comp"; cout<<"value is "<<p<<endl; } int main( ) { char * x = "Class XII"; print(x); cout<<"new value is "<<x<<endl; return 0; } Q3. Identify errors on the following code segment, and underline the error. float c[ ] ={ 1.2,2.2,3.2,56.2}; float *k,*g; k=c; g=k+4; k=k*2; g=g/2; cout<<”*k=”<<*k<<”*g=”<<*g; Q4. Write the output of the following program. void print (char * p ) { p = "Comp"; cout<<"valu...
Read more