Advertisements
Online Mock Tests
Chapters
1: Review of Phython
2: Concept of Object Oriented Programming
3: Classes in Python
4: Inheritance
Unit -2 : Advanced Programming with Python
1: Liner List Manipulation
2: Stacks & Queues in list
3: Data File Handling
4: Exception Handling & Generate Functions
Unit -3 : Databases Management Systems and SQL
▶ 1: Databases Concepts and SQL
2: Structure Query Language
Unit -4 : Introduction to Boolean Algebra
1: Boolean Algebra
2: Boolean Functions and Reduce Forms
Chapter 3: Application of Boolean Logic
Unit -5 : Communication Technologies
Chapter 1: Networking Concepts Part I
Chapter 2: Networking Concepts Part II
Chapter 3: Networking Protocols
Chapter 4: Mobile Telecommunication Technologies, Network Security and Internet Services
![CBSE solutions for कॉम्प्युटर सायन्स विद पाइथान [इंग्रजी] इयत्ता १२ chapter 1 - Databases Concepts and SQL - Shaalaa.com](/images/computer-science-with-python-english-class-12_6:c0c1e36c6bb846c19fd1bb8caad8e289.jpg "CBSE solutions for कॉम्प्युटर सायन्स विद पाइथान [इंग्रजी] इयत्ता १२ chapter 1 - Databases Concepts and SQL")
Advertisements
Solutions for Chapter 1: Databases Concepts and SQL
Below listed, you can find solutions for Chapter 1 of CBSE CBSE for कॉम्प्युटर सायन्स विद पाइथान [इंग्रजी] इयत्ता १२.
CBSE solutions for कॉम्प्युटर सायन्स विद पाइथान [इंग्रजी] इयत्ता १२ 1 Databases Concepts and SQL EXERCISE [Pages 173 - 175]
Expand the following:
SQL
Expand the following:
DBMS
What is relational database model?
What is relation?
Define the following:
Cardinality
Define the following:
Degree
Define the following:
Tuple
Define the following:
Field
Define the following key:
Primary key
Define the following key:
Candidate key
Define the following key:
Alternate key
What is DDL (Data Definition language)?
What all character types are possible in SQL?
What all numeric data types are possible in SQL?
Write all character data types in SQL.
Write all number data types in SQL.
Define the following:
Projection
Define the following:
Selection
Define the following:
Union
Define the following:
Cartesian product
Differentiate between CHAR and VARCHAR data types in SQL with appropriate examples.
Write the similarity between DECIMAL and NUMERIC data types.
What is the importance of primary key in a table? Explain with suitable example.
Differentiate between primary key and candidate key.
Give one difference between alternate key and candidate key.
What all domain values are possible in gender?
Write any four advantages of SQL.
In which situation one can apply union operation of two tables.
Differentiate between union and Cartesian product.
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?
A table 'game1' has 3 columns and 20 rows and another table 'game2' has the same column as game1 (ie 3) and 15 rows. 5 rows are common in both the table. If we take union, what is the degree and cardinality of the resultant table?
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?
From the following two tables, write the output of the Cartesian product. Also write primary key of customer and product table.
Customer
| Cust. No. | Name | Address | Phone No. |
|---|---|---|---|
| 111 | Rohan Aggarwal | Delhi | 28756389 |
| 222 | Kanika Jain | Delhi | 29807654 |
| 333 | Keshav Gupta | Mumbai | 25678945 |
| 444 | Dharna | Bambay | 24675678 |
Product
| P. No. | P. Name | Price | Qty |
|---|---|---|---|
| 101 | Computer | 35000 | 3 |
| 103 | Scanner | 20000 | 2 |
| 105 | Printer | 15000 | 1 |
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 | Rishika 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 |
Solutions for 1: Databases Concepts and SQL
CBSE solutions for कॉम्प्युटर सायन्स विद पाइथान [इंग्रजी] इयत्ता १२ chapter 1 - Databases Concepts and SQL
Shaalaa.com has the CBSE Mathematics कॉम्प्युटर सायन्स विद पाइथान [इंग्रजी] इयत्ता १२ CBSE solutions in a manner that help students grasp basic concepts better and faster. The detailed, step-by-step solutions will help you understand the concepts better and clarify any confusion. CBSE solutions for Mathematics कॉम्प्युटर सायन्स विद पाइथान [इंग्रजी] इयत्ता १२ CBSE 1 (Databases Concepts and SQL) include all questions with answers and detailed explanations. This will clear students' doubts about questions and improve their application skills while preparing for board exams.
Further, we at Shaalaa.com provide such solutions so students can prepare for written exams. CBSE textbook solutions can be a core help for self-study and provide excellent self-help guidance for students.
Concepts covered in कॉम्प्युटर सायन्स विद पाइथान [इंग्रजी] इयत्ता १२ chapter 1 Databases Concepts and SQL are .
Using CBSE कॉम्प्युटर सायन्स विद पाइथान [इंग्रजी] इयत्ता १२ solutions Databases Concepts and SQL exercise by students is an easy way to prepare for the exams, as they involve solutions arranged chapter-wise and also page-wise. The questions involved in CBSE Solutions are essential questions that can be asked in the final exam. Maximum CBSE कॉम्प्युटर सायन्स विद पाइथान [इंग्रजी] इयत्ता १२ students prefer CBSE Textbook Solutions to score more in exams.
Get the free view of Chapter 1, Databases Concepts and SQL कॉम्प्युटर सायन्स विद पाइथान [इंग्रजी] इयत्ता १२ additional questions for Mathematics कॉम्प्युटर सायन्स विद पाइथान [इंग्रजी] इयत्ता १२ CBSE, and you can use Shaalaa.com to keep it handy for your exam preparation.
