DAV MODEL SCHOOL, IIT KHARAGPUR
HOLIDAY HOMEWORK
SESSION: 2024-25
CLASS X SUB: IT (402)
QNo. QUESTIONS
1. Choose the correct alternative:
a) The default extension of OOBase database is ________.
i) oob ii) base iii) odb iv) dbo
b) _______________ specifies the type of data that may be stored in a database field.
i) Autosave ii) Autovalue iii) Field Type iv) Entry
c) Database servers are referred to as ______________.
i) Front ends ii) Back-ends iii) Clients iv) Model
d) Which of the following fields would not make a suitable primary key?
i) Customer Account No. ii) Date field
iii) Autonumber field iv) Student Admission Number
e) When a primary key contains more than one field, it is known as _____________.
i) Alternate key ii) Candidate Key iii) Foreign Key iv) Composite Key
2. Answer the following questions briefly:
i) Define DBMS and database with examples.
ii) Differentiate between primary key and foreign key.
iii) Mention the objects of DBMS and explain each.
iv) Explain the feature of Data Redundancy with examples.
v) v) Write short notes on –
a) Entity Integrity
b) Referential Integrity
3. Consider the following table MASTER.
Table: MASTER
Sno Name Age Department Salary
1 Shyam 21 Computer 12000
2 Shiv 25 Maths 15000
3 Rakesh 31 Hindi 14000
4 Sharmila 32 History 20000
5 Dushyant 25 Software 30000
i. How many fields and records are there in the table MASTER?
ii. Write the SQL queries to:-
a) Display all the records in descending order of their age.
b) Display name and department of the employees in MASTER Table having salary less
than 20000.
c) Display the total salary of the employees in the table given above.
d) Increase the salary of all the employees by 5%.
4.
Refer to the table below to answer the following queries in SQL:
a. To show all the information about COMPUTER teachers.
b. To list the details of all the teachers who are getting salary between 20000 and
35000.
c. To display the subject of all the teachers whose age is more than 40 years.
d. To display the list of names of all the teachers in alphabetical order.
5. In the given tables named TEACHER and PROJECT, identify the parent table, child table,
composite primary key (of PROJECT table) and foreign key.
6.
Answer the following questions based on the table given below:
i) How many records (cardinality) are there in the table Membership?
ii) How many fields (degree of table) are there in the table Membership?
iii) Write the SQL insert statement to enter the row (‘Mitin’,2202,’Piano’) in the above
table.
iv) Write the SQL statement to delete all the records from the above table.
7. Consider the following table Item and answer the queries from (i) to (iv) using SQL
commands.
Item_No Item_Name Price Quantity
11 Soap 40 80
22 Powder 80 30
33 Face Cream 250 25
44 Shampoo 120 100
55 Soap box 20 50
i) Write a command to insert a new record with the following values:
(66, ‘Gel’, 150, 70).
ii) Write a query to display all the records of table Item whose price is in the range of
50 and 100.
iii) Write a query to display all the records of a table in descending order of quantity.
iv) Write a query to increase the price of each item by Rs. 5.
