Database Management System Previous Questions Bank (DBMS)

 Database Management System Previous Questions Bank

Semester Final Examination, October-2023(Held in April-2024)

1.	a)	Differentiate between Centralized and Distributed database.	[4]
	b)	DBMS design depends upon its architecture. Explain different types of architecture with appropriate figure.	[5]
	c)	To maintain the integrity of the data, there are four properties described in the database management system, which are known as the ACID properties. Briefly describe ACID properties in database.	[5]
2.	a)	Write short note on Weak Entity, Strong Entity, Multivalued Attribute.	[3]
	b)	Explain types of relationships in ER Model.	[4]
	c)	Draw an ER Diagram for the following relation schemas. Worker (worker_id, worker_name,hourly_rate,skill_type,supervisor_id) Assignment (worker_id,building_id,start_date,num_days) Building(building_id,address,bulding_type)	[7]
3.	a)	Distinguish between DBMS and RDBMS.	[4]
	b)	Explain relationship among primary key, candidate key and super key with appropriate example.	[5]
	c)	Clarify functional dependency in a database table with proper example?	[5]
4.	a)	Define term “Transitive dependency” in database table.	[2]
	b)	Consider the following relational database schema consisting of the four relation schemas:                       passenger (pid, pname, pgender, pcity) agency (aid, aname, acity) flight (fid, fdate, time, src, dest) booking (pid, aid, fid, fdate) Answer the following questions using relational algebra queries; i)                Find out the complete details of all flights to Karachi. ii)              Find out the complete details of all flights from Saudi Arabia to Bangladesh. iii)             Find out the passenger names for passengers who have bookings on at least one flight. iv)             Find out only the flight numbers for passenger with pid 123 for flights to Chennai before 06/11/2020.	[1.5 X 4]
	c)	How can SQL Algebra expressions be used to perform Natural joins between different tables in a database?	[6]
5.	a)	Write down the SQL Aggregate functions.	[2]
	b)	Explain different types of SQL JOIN with proper example.	[4]
	c)	Consider the following schemas: Employess(emp_id,emp_name,job_name,manager_id,hire_date,salary,commission,dep_id) Salary(grade,max_salary,min_salary) Department(dep_id,dep_name,dep_location) i)                Write a SQL query to find the unique department name. ii)              Write a SQL query to find those employees whose name start with ‘Ra’. iii)             Write a SQL query to find those employees whose salaries are less than 3500. iv)             Write a SQL query to find maximum salary with employee name.	[4 X 2]
6.	a)	Write down the necessity of Normalization in database.	[3]
	b)	Differentiate between Candidate key and Super key.	[4]
	c)	Explain BCNF Normalization with appropriate example.	[7]
7.	a)	Define 2NF in context of Normalization in database.	[3]
	b)	Briefly describe about Data Center.	[5]
	c)	RAID is a technology which is used to connect multiple secondary storage devices for increased performance, data redundancy or both. Explain RAID 0, RAID 1 and RAID 10.	[3 X  2]

Semester Final Examination: April-2024 (Held in October-2024)

1.	a)	Define Database Management System (DBMS). Differentiate between file system and DBMS.	[1+4]
	b)	Write the roles and components of a storage manager of DBMS.	[4]
	c)	Explain three levels of data abstraction.	[5]
2.	a)	List the two commands of each DDL, DML, DCL and TCL languages.	[4]
	b)	Define the following terms- i. Data manipulation language    ii. Relational model    iii. Entity set   iv. Super key	[1.5x4]
	c)	Draw an ER Diagram for the following university relation schemas: department (dept_name, building, budget) instructor (ins_ID, name, designation, salary) section (section_id, semester, year) student (stu_ID, name, address)	[4]
3.	a)	Briefly describe any four relational operations of DBMS.	[6]
	b)	Illustrate two-tier and three-tier database architectures.	[4]
	c)	Show the relationship between primary key and foreign key with an example.	[4]
4.	a)	Mention five built-in SQL Aggregate functions.	[2]
	b)	Consider the following relational database schemas for the bank: customer (customer_name, address) branch (branch_name, branch_city, asset) account (account_no, branch_name, balance) depositor (customer_name, account_no) loan (loan_no, branch_name, amount) borrower (customer_name, loan_no) i)                Write an SQL query to find all customers who have both a loan and an account at the bank, in ascending order by customer name. ii)              Write an SQL query to find the names of all branches that have asset less than those of at least one branch located in Savar. iii)             Write an SQL query to find those branches where the total account balance is greater than 1000$. iv)             Write an SQL query to increase balance of all customers by 15% in account table.	[2x 4]
	c)	Write four differences between Candidate Key and Super Key.	[4]
5.	a)	Describe ACID properties of a transaction.	[5]
	b)	Examine different transaction states with the accompanying figure.	[6]
	c)	Define Multivalued and Derived attributes.	[3]
6.	a)	Make a short note on the Integrity Constraints.	[4]
	b)	Describe four types of mapping cardinalities.	[6]
	c)	Compare specialization and generalization in tabular format.	[4]
7.	a)	Define RAID. Briefly explain RAID 1, RAID 2 and RAID 3.	[1+6]
	b)	State Normalization. Describe 1NF, 2NF and 3NF in database.	[1+6]

Supplement/Improvement Examination: January – 2025

1.	a)	Differentiate between RDBMS and DBMS.	[4]
	b)	Define the following terms- i. Data abstraction    ii. Relational model    iii. Entity   iv. Tuple	[4]
	c)	Briefly describe different types of database language.	[6]
2.	a)	Define term ER Diagram.	[4]
	b)	Comparison between Strong Entity and Weak Entity.	[4]
	c)	Draw an ER Diagram for the following relation schemas: Worker (worker_id, worker_name,hourly_late,skill_type,supervisor_id) Assignment (worker_id, building_id, start_date, num_days) Building (building_id, address, building_type)	[6]
3.	a)	Mention the name of different types of keys.	[4]
	b)	Differentiate between Super key and Candidate key.	[4]
	c)	Consider the following relational database schemas for the bank: customer (customer_name, address) branch (branch_name, branch_city, asset) account (account_no, branch_name, balance) depositor (customer_name, account_no) loan (loan_no, branch_name, amount) borrower (customer_name, loan_no) i)                Write an SQL query to find all customers who have both a loan and an account at the bank, in ascending order by customer name. ii)              Write an SQL query to find the names of all branches that have asset less than those of at least one branch located in Nolam. iii)             Write an SQL query to find those branches where the total account balance is greater than 200$.	[2×3=6]
4.	a)	Define Multivalued and Derived attributes.	[2]
	b)	Show the relationship between primary key and foreign key with an example.	[5]
	c)	Briefly describe any four relational operations of DBMS.	[6]
5.	a)	Mention different types of Joins in database.	[4]
	b)	Describe four types of mapping cardinalities.	[5]
	c)	Illustrate two-tier and three-tier database architectures.	[5]
6.	a)	Define RAID in database.	[3]
	b)	Illustrate DBMS Architecture with appropriate figure.	[5]
	c)	Briefly describe ACID properties.	[6]
7.	a)	Define term Normalization.	[2]
	b)	Explain the necessity of Normalization in database.	[4]
	c)	Briefly describe 1NF, 2NF ,3NF and BCNF	[2×4=8]