BANGALORE TECHNOLOGICAL INSTITUTE
(An ISO 9001:2015 Certified Institution)
Kodathi Village,VarthoorHobli, Bangalore East Tq, Bangalore Urban District,
Bangalore-560035, Karnataka
[email protected] www.btibangalore.org
Phone: 7090404050
Department of Computer Science and Engineering
DATABASE MANAGEMENT SYSTEM (BCS403)
Module1
1. What is a Database? Explain the three schema architecture with neat diagram.
2. Describe the characteristics of database.
3. Explain component modules of DBMS and their interactions with a diagram.
4. What are the responsibilities of DBA & database designers?
5. What are the advantages of using DBMS approach? Explain
6. Explain the types of end users with examples.
7. Explain the categories of Data Models.
8. Explain the difference between logical and physical data independence.
9. Explain three schema architecture. Why mappings b/w schema levels are required?
10. Explain the different types of attributes in ER model.
11. Define the following terms with example for each using ER notations:
Entity, attribute - Composite attribute, multivalued attribute, and participation role.
12. Define the following terms
i) Key ii) Super key iii) Candidate key iv) Primary key v) Foreign key
13. Explain the following.
a. Cardinality Ratio
b. Weal Entity
c. Recursive relationship
d. Specialization
e. Data Dictionary
f. Canned Transaction
g. Schema
h. Data Definition Language
i. Data Manipulation Language
j. Value Sets
k. Degree of a relationship
l. DBMS Catalog
m. Metadata
n. Snapshot
14. Draw an ER diagram for an COMPANY database with employee, department, and project as Strong entities and
dependent as weak entity. Specify the constraints, relationships and Ratios in the ER diagram.
15. Write a UML class diagram for company conceptual schema
16. Write an ER diagram to represent CAR entity type with two key attributes Registration and Vehicle ID
Module2
1. Explain the different types of update operations on relational database. How basic operation deals with constraint
violation?
2. Explain the different Relational Model constraints.
3. Explain Unary relational operations with examples.
4. What is an Integrity Constraint? Explain the importance of Referential Integrity Constraint.
5. Explain the following relational algebra operation. JOIN, DIFFERENCE, SELECT, UNION and PROJECT, DIVISION.
6. Discuss Equi join and Natural join with suitable examples
7. Explain the relational algebra operation for set theory with examples.
8. Explain Aggregate functions and grouping.
9. Discuss the characteristics of the relation that makes them different from ordinary tables and files
10. Consider the following COMPANY database EMP(Name,SSN,Salary,SuperSSN,Gender,Dno)
DEPT(DNum,Dname,MgrSSN,Dno)
DEPT_LOC(Dnum,Dlocation)
DEPENDENT(ESSN,Dep_name,Sex)
WORKS_ON(ESSN,Pno,Hours)
PROJECT(Pname,Pnumber,Plocation,Dnum)
Write the relational algebra queries for the following
(i)Retrieve the name, address, salary of employees who work for the Research department.
(ii) find the names of employees who work on all projects controlled by department number4.
iii) Retrieve the SSN of all employees who either in department no :4 or directly supervise an employee
who work in department number :4
(iv) Retrieve the names of employees who have no dependents
(v) Retrieve each department number, the number of employees in the department and their average salary.
11. Consider the following two tables
12. Perform the below operations
13. Solve the below
14. Summarize the steps involved in converting the ER constructs to corresponding relational tables or Describe the steps of
an algorithm for ER to relational mapping
15. Create Table
16. Solve
