CBSE Class 11 Computer Science Data Management Worksheet Set E

Read and download free pdf of CBSE Class 11 Computer Science Data Management Worksheet Set E. Download printable Computer Science Class 11 Worksheets in pdf format, CBSE Class 11 Computer Science Data Management Worksheet has been prepared as per the latest syllabus and exam pattern issued by CBSE, NCERT and KVS. Also download free pdf Computer Science Class 11 Assignments and practice them daily to get better marks in tests and exams for Class 11. Free chapter wise worksheets with answers have been designed by Class 11 teachers as per latest examination pattern

Data Management Computer Science Worksheet for Class 11

Class 11 Computer Science students should refer to the following printable worksheet in Pdf in Class 11. This test paper with questions and solutions for Class 11 Computer Science will be very useful for tests and exams and help you to score better marks

Class 11 Computer Science Data Management Worksheet Pdf

WS 9 – Data Management


1. What is a database system? What is its need?

2. What is SQL? What are different categories of commands available in SQL?

3. Differentiate between DDL and DML commands.

4. Write two usage of DESC in SQL.

5. Write SQL queries for (i) to (iv) and find outputs for SQL queries (v) to (viii), which are based on the tables:

CBSE Class 11 Computer Science Data Management Worksheet Set E 1

(i) To display all details from table MEMBER in descending order of ISSUEDATE.
(ii) To display the CODE and BNAME of all Fiction Type books from the table BOOK.
(iii) To display the TYPE and number of books in each TYPE from the table BOOK.
(iv) To display all MNAME and ISSUEDATE of those members from table MEMBER who have books issued (i.e ISSUEDATE) in the year 2017.
(v) SELECT MAX(ISSUEDATE) FROM MEMBER;
(vi) SELECT DISTINCT TYPE FROM BOOK;
(vii) SELECT A.CODE, BNAME, MNO, MNAME FROM BOOK A, MEMBER B WHERE A.CODE=B.CODE ;
(viii) SELECT BNAME FROM BOOK WHERE TYPE NOT IN ("Fiction", "Comic");

6. Create table Employee with the following structure:

CBSE Class 11 Computer Science Data Management Worksheet Set E 2

Ensure the following specification in created table: ID should be declared as Primary Key, User_ID shold be unique,Salary Must be greater than 5000 , First_Name and Lst_Name must not remain Blank

Write SQL queries for the following :

i. Show the structure of the table Employee.
ii. Insert 3 records in the table Employee.
iii. Modify the SALARY and increase by 1000, for all who get salary less than 6000
iv. For record with ID 4 update record with LAST_NAME as Sharma, USER_ID as E1004 and SALARY as 7800.
v. Add a new coloumn PHONE of type varcahr(12)
vi. Delete the EMPLOYEE record having FIRST_NAME as Manish
vii. Remove Employee Table permanently
viii. Count the total records in the table EMPLOYEE

7. What is foreign key? How do you define a foreign key in your table?

8. Explain the DELETE command in SQL with syntax and example.

9. Observe the following table and answer the parts (i) and (ii) :

CBSE Class 11 Computer Science Data Management Worksheet Set E 3
(i) In the above table, can we have Qty as primary key.[Answer as yes/no]. Justify your answer.
(ii) If you have to add a column email and phone, name the data types required for it.

10. Define Cardinality and degree of table what is the Degree and Cardinality of the following table.

CBSE Class 11 Computer Science Data Management Worksheet Set E 4

Please click on below link to download CBSE Class 11 Computer Science Data Management Worksheet Set E

Chapter 05 Getting Started with Python
CBSE Class 11 Computer Science Python Modules Worksheet
z More Worksheets for Class 11 Computer Science
CBSE Class 11 Computer Science Boolean Logic Worksheet
CBSE Class 11 Computer Science Data Management Worksheet Set A
CBSE Class 11 Computer Science Data Management Worksheet Set B
CBSE Class 11 Computer Science Data Management Worksheet Set C
CBSE Class 11 Computer Science Data Management Worksheet Set D
CBSE Class 11 Computer Science Data Management Worksheet Set E
CBSE Class 11 Computer Science Data Representation Worksheet
CBSE Class 11 Computer Science If Else Statements Worksheet
CBSE Class 11 Computer Science Operation And Expressions Worksheet
CBSE Class 11 Computer Science Output Worksheet
CBSE Class 11 Computer Science Programming and Computational Thinking Worksheet Set A
CBSE Class 11 Computer Science Programming and Computational Thinking Worksheet Set B
CBSE Class 11 Computer Science Programming and Computational Thinking Worksheet Set C
CBSE Class 11 Computer Science Programming and Computational Thinking Worksheet Set D
CBSE Class 11 Computer Science Programming Methodology Worksheet
CBSE Class 11 Computer Science Programming Question Worksheet Set A
CBSE Class 11 Computer Science Programming Question Worksheet Set B
CBSE Class 11 Computer Science Vacation Assignment Worksheet
CBSE Class 11 Computer Science Worksheet Set A
CBSE Class 11 Computer Science Worksheet Set B
CBSE Class 11 Computer Science Worksheet Set C
CBSE Class 11 Computer Science Worksheet Set D
CBSE Class 11 Computer Science Worksheet Set E Solved
CBSE Class 11 Computer Science Worksheet Set F Solved
CBSE Class 11 Computer Science Worksheet Set G Solved
CBSE Class 11 Computer Science Worksheet Set H Solved
CBSE Class 11 Computer Science Worksheet Set I Solved
CBSE Class 11 Computer Science Worksheet Set J Solved

CBSE Class 11 Computer Science Data Management Worksheet

The above practice worksheet for Data Management has been designed as per the current syllabus for Class 11 Computer Science released by CBSE. Students studying in Class 11 can easily download in Pdf format and practice the questions and answers given in the above practice worksheet for Class 11 Computer Science on a daily basis. All the latest practice worksheets with solutions have been developed for Computer Science by referring to the most important and regularly asked topics that the students should learn and practice to get better scores in their examinations. Studiestoday is the best portal for Printable Worksheets for Class 11 Computer Science students to get all the latest study material free of cost.

Worksheet for Computer Science CBSE Class 11 Data Management

Teachers of studiestoday have referred to the NCERT book for Class 11 Computer Science to develop the Computer Science Class 11 worksheet. If you download the practice worksheet for the above chapter daily, you will get better scores in Class 11 exams this year as you will have stronger concepts. Daily questions practice of Computer Science printable worksheet and its study material will help students to have a stronger understanding of all concepts and also make them experts on all scoring topics. You can easily download and save all revision Worksheets for Class 11 Computer Science also from www.studiestoday.com without paying anything in Pdf format. After solving the questions given in the practice sheet which have been developed as per the latest course books also refer to the NCERT solutions for Class 11 Computer Science designed by our teachers

Data Management worksheet Computer Science CBSE Class 11

All practice paper sheet given above for Class 11 Computer Science have been made as per the latest syllabus and books issued for the current academic year. The students of Class 11 can be assured that the answers have been also provided by our teachers for all test paper of Computer Science so that you are able to solve the problems and then compare your answers with the solutions provided by us. We have also provided a lot of MCQ questions for Class 11 Computer Science in the worksheet so that you can solve questions relating to all topics given in each chapter. All study material for Class 11 Computer Science students have been given on studiestoday.

Data Management CBSE Class 11 Computer Science Worksheet

Regular printable worksheet practice helps to gain more practice in solving questions to obtain a more comprehensive understanding of Data Management concepts. Practice worksheets play an important role in developing an understanding of Data Management in CBSE Class 11. Students can download and save or print all the printable worksheets, assignments, and practice sheets of the above chapter in Class 11 Computer Science in Pdf format from studiestoday. You can print or read them online on your computer or mobile or any other device. After solving these you should also refer to Class 11 Computer Science MCQ Test for the same chapter.

Worksheet for CBSE Computer Science Class 11 Data Management

CBSE Class 11 Computer Science best textbooks have been used for writing the problems given in the above worksheet. If you have tests coming up then you should revise all concepts relating to Data Management and then take out a print of the above practice sheet and attempt all problems. We have also provided a lot of other Worksheets for Class 11 Computer Science which you can use to further make yourself better in Computer Science

Where can I download latest CBSE Practice worksheets for Class 11 Computer Science Data Management

You can download the CBSE Practice worksheets for Class 11 Computer Science Data Management for the latest session from StudiesToday.com

Can I download the Practice worksheets of Class 11 Computer Science Data Management in Pdf

Yes, you can click on the links above and download chapter-wise Practice worksheets in PDFs for Class 11 for Computer Science Data Management

Are the Class 11 Computer Science Data Management Practice worksheets available for the latest session

Yes, the Practice worksheets issued for Data Management Class 11 Computer Science have been made available here for the latest academic session

How can I download the Data Management Class 11 Computer Science Practice worksheets

You can easily access the links above and download the Class 11 Practice worksheets Computer Science for Data Management

Is there any charge for the Practice worksheets for Class 11 Computer Science Data Management

There is no charge for the Practice worksheets for Class 11 CBSE Computer Science Data Management you can download everything free

How can I improve my scores by solving questions given in Practice worksheets in Data Management Class 11 Computer Science

Regular revision of practice worksheets given on studiestoday for Class 11 subject Computer Science Data Management can help you to score better marks in exams

Are there any websites that offer free Practice test papers for Class 11 Computer Science Data Management

Yes, studiestoday.com provides all the latest Class 11 Computer Science Data Management test practice sheets with answers based on the latest books for the current academic session

Can test sheet papers for Data Management Class 11 Computer Science be accessed on mobile devices

Yes, studiestoday provides worksheets in Pdf for Data Management Class 11 Computer Science in mobile-friendly format and can be accessed on smartphones and tablets.

Are practice worksheets for Class 11 Computer Science Data Management available in multiple languages

Yes, practice worksheets for Class 11 Computer Science Data Management are available in multiple languages, including English, Hindi