PURBANCHAL UNIVERSITY
Write SQL query to:
(a) Create the above table with primary key "Cust_id".
(b) Insert the given set of data in the table.
(c) Display Customer Names and contact numbers whose adress starts with 'B'.
3. Explaun the different types of database systems in detail.
4. Distinguish between DDL and DML with two examples of each.
5. Discuss the different data recovery strategies.
6. Define functional dependency and normalization. Why is normalization done?
7. Explain anyone security model for database security.
8. Discuss performance tuning. Write the strategies for performance tuning.
9. What is transaction? Define the ACID properties of a transaction.
10. What are cloud databases and databases as a service(DBaaS)?
Group C
Answer the questions. 5x3=15
11. Write short notes on the database and DBMS.
12. Write short notes on entity and attribute.
13. Discuss about SQL functions with examples.
14. Define authentication and authorization.
15. What is referential integrity.
*****THE END*****
2025
Bachelor of Business Administration (BBA)/Fifth Semester/Final
Time: 03:00 hrs Full Marks: 60 /Pass Marks: 24
IT 355: Database Management System (New Course)
Candidates are requires to give their answers in their own words as far as practicable.
Figures in the margin indicates full marks.
Group A
Case Study: 1×10=10
1. Design an Entity –Relationship (ER) diagram for a School Management System that keeps track of students, teachers, classes and subjects. Each student has a unique student ID, name, age, gender, and contact number. Students are assigned to a class , and each class has a class ID, name, subject specialization, and contact number. A teacher can teach multiple subjects, and a subject can be taught by mutliple teachers. The system also records the subject ID, subject name, and number of periods per week. Additionally, students can enroll in multiple subjects, and their performance is recorded with marks obtained in each subject. Create an ER diagram showing the entities, their attributes, and the relatonships between them. Convert ER diagram to relations.
Group B
Answer any SEVEN questions. 7x5=35
2. Consider the following "CUSTOMER" table:| Cust_Id | Cust_Name | Address | Contact No. |
|---|---|---|---|
| C005 | Rakesh | Birgunj | 9852011111 |
| C010 | Mahesh | Nepalgunj | 9862022222 |
| C012 | Aniket | Butwal | 9805033333 |
| C020 | Hitesh | Pokhara | 9812344444 |
| C025 | Mandip | Birgunj | 9842055555 |
| C028 | Hari | Pokhara | 9842166666 |