BSc IT Sem III 2012 2013 2013 Comp III 2102 13 Question Paper - Mumbai University | munotes

Questions asked in this paper

• Figures to the right indicate full marks,

1. Q2 , a. Write a short note on = 1, Specialization,
2. Q2 Generalization. 8 marks
   • b. What do you mean by Weak Entity set ? Design an E-R for a reservation system. Customer (7) Teserves ticket. Railway has trains, trains contains and boggies contain seats, Train has particular schedule provided to customers, Consider following tables - (8) Solve following queries 1, How many employees works in each department ? 7
3. Q2 Display employee details with their with subquery)
4. Q3 Display employee details if and onty if any of the employee in city Mumbai '. (Solve with ANY operetor ),
5. Q4 How many employees in each city ?
   • b. What do you mean by join ? Explain equi-join and left-join with
   • b. What do you mean by constraint ? Explain primary key constraint and foreign key constraint with suitzble example, (7) a, are triggers ? How trigger achieves data integrity? Explain types of triggers. (8) What is an index ? Explain with syntax, Give example of it, (7) b, Create a procedure for addition of two numbers, Execute it, (7)

Read from the scan above, so a character or two may differ. The scan is the original.