INTRODUCTION TO DATABASE, DATABASE DESIGN AND RELATIONAL MODEL Short Answer Questions 1. What is a weak and strong entity sets? Explain with example? [2M] 2. Explain about class hierarchy? [2M] 3. Define Entity, Attributes, Entity set, relationship with appropriate notations? [2M] 4. What is Relational Instance, Relational Schema? Give one examples? [2M] 5. Draw the notation for multivalued attributes? Give one example? [2M] 6. What is a data model? List the types of data model used [2M] 7. What are composite attributes? [2M] 8. What does the cardinality ratio specify? [2M] 9. What are the two types of participation constraint? [2M] 10. List any eight applications of DBMS [2M] Long Answer Questions 1. (a) Define Database? Discuss about applications of Database Systems? [5M] (b) Discuss about the purpose of Database Systems? [5M]. 2. (a) What is Data Abstraction? Explain about different views of data? [5M] (b) Define Instance and Schema? List different data models and explain? [5M] 3. Explain about Database languages with examples? [10M] 4. (a) Draw the Architecture of Database? [5M] (b) Discuss about Database users and Administrators? [5M] 5. (a) Draw ER diagram for Ternary Relationship set with suitable example? [5M] (b) Discuss about key constraints for Ternary Relationships? [5M] 6. Draw the ER diagram for a company needs to store information about employees (identified by ssn, with salary and phone as attributes), departments (identified by dno, with dname and budget as attributes), and children of employees (with name and age as attributes). Employees work in departments, each department is managed by an employee, a child must be identified uniquely by name when the parent (who is an employee; assume that only one parent works for the company) is known. We are not interested in information about a child once the parent leaves the company [10M] 7. Explain about integrity constraints over relations? [10M] 8. Write about logical database design (ER to Relational) with suitable examples? [10M] 9. List the database models and explain Architecture of database? [10M] 10. A college consists of number of employees working in different departments. In this context, create two tables employee and department. Employee consists of columns empno, empname, basic, hra, da, deductions, gross, net, date-of-birth. The calculation of hra, da are as per the rules of the college. Initially only empno, empname, basic have valid values. Other values are to be computed and updated later. Department contains deptno, deptname, and description columns. Deptno is the primarykey in department table and referential integrity constraint exists between employee and department tables? [10M

Identify the correct statement.

Logical level Abstraction: describes how schema is stored in a data base

If R and S are two relation then R ∩ S can be represented as.

(R ∪ S) - [(R - S) ∪ (S - R)]

Consider the following relations

student ( id, name, address, gpa, sizeHS )

campus ( location, enrollment, rank )

apply ( id, location, date, major, decision )

Identify the correct query to find name and address of all students with GPA > 3.7 and sizeHS < 1000.

∏name, address ( σ GPA > 3.7 ^ sizeHS < 1000 ( student ) )

Identify the number of tuples in the relation R1 ⋈ R2.

7INTRODUCTION TO DATABASE, DATABASE DESIGN AND RELATIONAL MODEL

Short Answer Questions

1. What is a weak and strong entity sets? Explain with example? [2M]

 2. Explain about class hierarchy? [2M]

 3. Define Entity, Attributes, Entity set, relationship with appropriate notations? [2M]

 4. What is Relational Instance, Relational Schema? Give one examples? [2M]

 5. Draw the notation for multivalued attributes? Give one example? [2M]

 6. What is a data model? List the types of data model used [2M]

 7. What are composite attributes? [2M]

 8. What does the cardinality ratio specify? [2M]

 9. What are the two types of participation constraint? [2M]

 10. List any eight applications of DBMS [2M]

Long Answer Questions

1. (a) Define Database? Discuss about applications of Database Systems? [5M]

(b) Discuss about the purpose of Database Systems? [5M].

2. (a) What is Data Abstraction? Explain about different views of data? [5M]

(b) Define Instance and Schema? List different data models and explain? [5M]

3. Explain about Database languages with examples? [10M]

4. (a) Draw the Architecture of Database? [5M]

(b) Discuss about Database users and Administrators? [5M]

5. (a) Draw ER diagram for Ternary Relationship set with suitable example? [5M]

(b) Discuss about key constraints for Ternary Relationships? [5M]

6. Draw the ER diagram for a company needs to store information about employees (identified by ssn,

with salary and phone as attributes), departments (identified by dno, with dname and budget as

attributes), and children of employees (with name and age as attributes). Employees work in

departments, each department is managed by an employee, a child must be identified uniquely by

name when the parent (who is an employee; assume that only one parent works for the company) is

known. We are not interested in information about a child once the parent leaves the company [10M]

7. Explain about integrity constraints over relations? [10M]

8. Write about logical database design (ER to Relational) with suitable examples? [10M]

9. List the database models and explain Architecture of database? [10M]

10. A college consists of number of employees working in different departments. In this context, create

two tables employee and department. Employee consists of columns empno, empname, basic, hra, da,

deductions, gross, net, date-of-birth. The calculation of hra, da are as per the rules of the college.

Initially only empno, empname, basic have valid values. Other values are to be computed and

updated later. Department contains deptno, deptname, and description columns. Deptno is the

primarykey in department table and referential integrity constraint exists between employee and

department tables? [10M