(Grade XII) Lab Assignment
Chapter 1: Database Management System
1. What
is normalization? Explain 1NF, 2NF and 3NF with example.
2. Differentiate
between centralized and distributed database system.
3. Differentiate
between DDL and DML with example.
4. Explain
the Relational Data model with example.
5. Explain
any two advantages of DBMS over traditional file system.
6. What
is transmission medium? Explain its major types with advantages and
disadvantages.
7. What
is database model? Explain with example.
8. Write the SQL
statement to perform the following task.
a. Create a
database named 'hospital'.
b. Create a
table 'patient' with following fields:
patient_id —
integer patient_name — varchar(100)
patient_disease
— varchar(100)
patient_age — integer
c. Insert any 5
records.
d. Display all
the records of all fields.
e. Display all
the records of fields patient_id and patient_name.
f. Display records of patients whose name starts with letter 'S'.
g. Display
records of patients whose disease ends with letter 'A'.
h. Display all
the records of patients whose age is 30.
i. Display all
the records of patients whose age is greater than 40 and whose disease is
'Diabetes'.
j. Update the
patient name with any other name for the patient with id 3.
k. Delete the
record of the patient whose id is 2.
l. Display the
records of patients in sorted order using field 'patient_name'. Use 'ORDER BY
field_name ASC/DESC'.
m. Alter the
table to add one more field: patient_address — varchar(100).