C BYREGOWDA INSTITUTE OF TECHNOLOGY
DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING,COMPUTER ENGINEERING
SUBJECT: DATABASE MANAGEMNENT SYSTEM [BCS403]
Assignment -1 SEM: 4
SECTIONS: A,B ,C&CE. Date: - 09/03/2025
Module-1
1.i)Explain the characteristics of database.
ii)Define data base and describe the implicit properties of data base.
2. Explain the advantages of DBMS approach.
3. What is a Database? Describe the three-schema architecture. Why do we need mappings between schema
levels?
4. What are the different ways of classifying a DBMS?
5. Explain the different DBMS languages & interfaces.
6. With a neat diagram explain DBMS system environment?
7. Define the terms: a) Entity b) Attribute c) Composite attribute d) Derived attribute e) Complex attribute
f) Multi-valued attribute g) key attribute h) null value i) Participation constraint j) Participation role k)
Relationship degree l)Data Dictionary m)Weak entity n)Data base schema o)Data catalogue p)Instance
q)Physical and logical data independence.
8.Explain the categories of Data Models.
9.Explain the component modules of DBMS & their interactions with diagram
10. Describe the two alternatives for specifying structural constraints on relationship types.
11. What is the concept of weak entity type used in data modeling? Explain the role of partial key in design of
weak entity type.
12. Briefly discuss the different types of update operations on relational database. Show an example of
violation of the referential integrity in each of the update operation.
13.What are the responsibilities of DBA & database designers?
14.Write the E-R diagram and UML diagram for employee database the constraints are as fallows
i)An employee works for the department.
ii)Every department headed by a manager.
iii)An employee works on one or more projects
iv)An employee has dependents
v)A department controls the employees.
Module-2
1. Explain the different types of update operations on relational database. How basic operation deals with
constraint violation.
2. Explain the select and project operations as used in relational algebra.
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.
i)JOIN ii)SELECT iii)DIFFERENCE iv)UNION
6. Discuss the E.R to Relational mapping algorithm with example for each step.
7.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.
8.Consider the following relational schema
Works(Pname,Cname,salary)
Lives(Pname,Street,City)
located_in (Cname, city)
Manager(Pname,Mgrname)
Write the SQL queries for the following
i)Find the names of all persons who live in the city Bangalore.
ii)Retrieve the names of all person of "Infosys" whose salary is between Rs .50000
iii)Find the names of all persons who lives and work in the same city
iv)List the names of the people who work for “Tech M” along with the cities they live in.
v)Find the average salary of “Infosys” persons.
9.Define the following terms along with examples for each.
i)Domain ii)Attribute iii)Tuple iv)Degree of a realtion v)Relational database
10.List and explain the characteristics of relations.
Submission Date:17/03/2025
