**DATABASE SYSTEM**

**B.Tech – Computer Engineering [ SEM-5 ]**

Dec-2019 [Winter Semester Exmination]

**QuestionPapersHub**

**Q.1. Attempt any 3(4×3=12).**

- Explain the difference between two-tier & threee-tier architectures. Which is better suited for web applications? Why?
- Construct an E-R diagram for a car insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents. Each insurance policy coveres one or more cars, and has one or more.
- Suppose the numbers :
**50, 15, 62, 5, 20, 58, 91, 3, 8, 37, 60, 24**are inserted in order into an initially empty binary search tree. What is preorder, inorder & postorder transversal sequence of the tree? - What is garbage collection? Who will run garbage collection program? When it will be run?

**Q.2. Solve all the following questions(4×3=12).**

- What is sparse matrix? Convert the following sparse matrix.
- Suppose multidimensional arrays A & B are declared using
- What is header linked list? Use header linked list to the following polynomial
- What is hash data structure?The keys: 32, 18, 23, 2, 3, 44, 5 and 15 are inserted into an initially empty hash table of length 10 with hash function H(Key)= key mod 10 & linear probing is used to resolve collision. What is hash table content after every key insertion?

- 1 0 0 0

- 0 -2 11 0

- 0 0 0 0

- 0 6 0 5

**A (-1:3) & B (1:5, -3.1)**

**p(x)=2×8-5×7+3×2+4.**

**Q.3. Solve any 3 of the following questions(3×4=12).**

- Give an algorithm to complement binary search with its advantages & disadvantages.
- Explain the concept of skip list with an example. Give its advantages & disadvantages.
- Sort the following list using radix sort. Show all the passes neatly:
**3 45 7 18 9 4 89 103 11 21** - Suppose we are sorting an array of eight integers using quick-sort, and we have just finished the first partitioning with the array looking like this:
**2, 5, 1, 7, 9, 12, 21, 30**

**Q.4. Solve any 2 of the following (2×6=12).**

- Write an algortihm to insert a new node at the begining of the singly linked list.
- What is singly circular linked list? Write an algorithm to transverse the list & also enlist different operations performed on it.
- Write a short note on dynamic storage management. Explain how it is done in C.

**Q.5. Solve any 2 (2×6=12).**

- Consider the stack where N=6 memory cells allocated. Suppose initially stack contains
**A, D, E, F, G**

(Top of stack). Then the following operations called in order. Show the stack top & any other situation raised while doing each of the operations.- Push (Stack, K)
- Pop (Stack, Item)
- Push (Stack, L )
- Push(Stack, S)
- Pop(Stack, Item)
- Push(Stack, T)
- What is queue? Write an algorithm to implement insert item into queue using singly linked list.
- write an algorithm to evaluate postfix expression using stack & execute your algorithm with postfix expression

**10, 5, 6, *, +, 8, /.** - Show intermediate stack content after each operation.

**Q.6. Solve all of the following(4×3=12).**

- Give the characteristics of good algorithm. Also explain how do e analyze the algorithm.
- Store elements of the given below binary tree using
- One dimensional array
- Linked list

- What is an Abstract Data Type (ADT)? Explain why queue is called ADT?
- Explain the following graph terminology with figure

i) Undirected graph ii) Total degree of vertex iii) Simple path iv) Cycle