BPUT previous year question paper Of DATABASE MANAGEMENT SYSTEM, 7th Semester 2011

BPUT previous year question paper

 

BPUT.

• Biju Patnaik University of Technology ,BPUT, Rourkela Is a well-known and famous university in India.


• Biju Patnaik University of Technology , BPUT , Rourkela has been established by an Act of the Assembly, Government of Odisha in June 2002.


• Engineering, Pharmacy, Architecture, M.Tech, Fashion designing and MCA and MBA degree etc. are the courses provided under this university.


• You Can Download all previous year Semester question papers Of BPUT Here For Free.


• 

BPUT previous year question paper

 

Registration No.:

 

Total number of printed pages—3 B. Tech

 

FEEC 6301

 

Fifth Semester Examination — 2011

 

DATABASE MANAGEMENT SYSTEM

 

Full Marks—70

 

Time: 3- Hours

 

Answer Question No. 1 which ¡s compulsory and any five from the rest.

 

The figures in the right-hand margin indicate marks.

 

Answer the following questions: 2x10

 

(a) The ability to modify the physical scheme without causing application

 

Programs to be rewritten is in _____________.

 

(i) Physical Data Independence

 

(ii) Logical Data Independence

 

(b) Which of the following statements best describes the function of an entity relation model?

 

(j) An ER model ¡s concerned primarily with a logical view of the data and secondly with the physical implementation

 

(ii) An ER model is concerned primarily with a physical implementation of the data and secondly with the logical view,

 

(iii) An ER model provides a view of the logic of the data and not the physical implementation

 

(iv)An ER model is entirely concerned with modeling the physical implementation

 

c) How many distinct tuples are in a relation instance with cardinality 22?

 

d) Why some functional dependencies are called trivial?

(e) The rule that prohibits transitive dependencies is —

(I) second normal form -

(ii) First normal form

(iii) Third normal form

(iv) None of the above

(f) A weak entity type —

(i) Must have total participation in an identifying relationship

(ii) Does not have a key attribute(s)

(iii) Both O) and (ii)

(iv) None of the above

(g) What is a foreign key constraint? Why are such constraints important?

(h) Difference between the relation and relation schema.

(j) Convert the following algebra to SQL.

FI person name (cy company name “First Bank Corporation”(works))

If people may not work for any company:

n person name (employee) - FI person name

(Company name “First Bank Corporation”)(Works))

(j) What is the phantom problem?

2. (a) Explain the difference between external, internal, and conceptual schemas. How are these different schema layers related to the concepts of logical and physical data independence? 5

(b) Explain the distinctions among primary key, candidate key and super key. 5

3. A university database contains information about faculty (identified by

Identification number) and courses (identified by coursed). Faculties teach

Courses; each of the following situations concerns the Teaches relationship set. For each situation, draw an ER diagram that describes it.

(I) Faculties can teach the same course in several semesters, and each offering must be recorded. 2.5

(ii) Faculties can teach the same course in several semesters, and only the most recent such offering needs to be recorded. (Assume this condition applies in all subsequent questions.) 2.5

(iii) Every faculty must teach some course. 2.5

(iv) Every faculty teaches exactly one course (no more, no less), and every course must be taught by some faculty. 2.5

7. (a) Compare between timestamp and two phase locking schemes. 5

(b) Explain the difference between Hash indexes and B+—tree indexes. 5

8. (a) Write short notes on ACID properties. 5

(b) Describe the use of locks for improved conflict resolution in Optimistic

Concurrency Control.

BPUT previous year question paper Of DATABASE MANAGEMENT SYSTEM, 7th Semester 2011 Image Format.

BPUT previous year question paper Of DATABASE MANAGEMENT SYSTEM, 7th Semester 2011 PDF file.

Database Management System
First Like us on Facebook to get all the Question, Job, exam, Career related updates.

For more Question Visit http://www.careerodisha.in/