Page 62 - ipp11
P. 62
23. Write a short note on Data Storage. [2]
24. What will be the output of the following code? [2]
st = "LearnProgramming"
print(st[:4] + st[4:].upper())
25. (a) What is a keyword in Python? Give two examples. [2]
OR
(b) Define smart cities.
26. What are tokens in Python? How many types of tokens are allowed in Python? Explain. [2]
27. Write any two advantages of using database. [2]
28. (a) A college library maintains a table named Books, which stores details of all the books in the library. The
table has 7 columns (Book_ID, Title, Author, Publisher, Genre, Price, Availability_Status) and 150 rows
representing books records. [2]
Based on this information, answer the following:
(i) What is the degree of the Books table?
(ii) What is the cardinality of the Books table?
OR
(b) An online shopping platform stores order data in a table named Orders with the attributes like Order_ID,
Customer_ID, Product_ID, Order_Date, Shipping_Address. Each order is assigned a unique Order_ID and
customers’ Customer_ID and Product_ID are also unique.
Based on this information, answer the following:
(i) Identify the Primary Key for this table.
(ii) List the possible candidate Keys and justify them.
SECTION C (3 × 3 = 9 Marks)
29. Define the following terms: [3]
(a) Entity (b) NULL value (c) Data Integrity
30. (a) Write an SQL statement to create a table, DOCTORS, with the following specifications: [3]
Column Name Data Type Constraints
DOC_ID Varchar(5) Primary Key
DOC_Name Varchar(40) NOT NULL
Department Varchar(30) NOT NULL
Salary Decimal(7,2)
Join_Date Date
OR
(b) Write SQL commands to perform the following tasks:
(i) Create a database named Office.
(ii) Open the database Office.
(iii) Display all records from a table named Staff.
31. Consider the following table: [3]
Table: CUSTOMER_FEEDBACK
Feedback_ID Name Rating Product Feedback_Date
F101 Simran Gupta 4 Vacuum Cleaner 2025-04-20
F102 Rajeev Arora 5 Blender 2025-05-22
F103 Meena Kumari 3 Iron 2025-03-24
F104 Ayaan Mehta 5 Microwave 2025-01-25
F105 Tanya Singh 2 Mixer Grinder 2025-02-27
P.8