Veer Narmad South Gujarat University 2011-4th Sem Certification MS-CIT SB-3822 - 402 : RDBMS - 1 B.sc ( IT ) ( ) - Question Paper
B. Sc. (IT) (Sem. IV) Examination
March / April - 2011
Paper : 402 - RDBMS-I
SB-3822
Time : 3 Hours] [Total Marks : 70
Instructions :
N Seat No.:
6silq<3i Puunki(l faaim SuwiA u* <Hh41. Fillup strictly the details of signs on your answer book.
Name of the Examination :
B. Sc. (IT) (Sem. 4)
Name of the Subject:
402-RDBMS-1
Student's Signature
|
-Subject Code No.: |
|
-Section No. (1,2......): Nil |
Answer the following questions in brief (any six)
18
(a) What is candidate key ? How it is different than primary key ?
(b) What is insertion anomaly ? Explain with example.
(c) Aggregate function is used only with group by clause.
Yes or No. Justify with examples.
(d) Explain any 5 rules of CODDs rule.
(e) What is view ? Is the view physically located in disk ?
(f) How to revoke different privileges from the user ?
(g) Which query is executed by the oracle engine first ? Sub query or Main query ? Why ?
2 Attempt any three : 18
(a) Consider following relation and normalize it upto 2nd normal form. Generate different tables and show the primary key for each relation.
Cricket (team_no, teamname, matchno, matchdate, playerno, playername, country, win_or_loose, no_of_players, bowler_no, bowler_name, overno, noof_overs)
(b) Construct the ER-diagram for online reservation system for railway. Consider the specialization and other features.
(c) What is data dictionary ? Why it is important ? Create the data dictionary for the college database considering 4 main tables the college.
(d) What is Join ? If user is not specifying the join clause which type of join is internally implemented by the oracle ? What is the difference between left and right outer join ?
3 Answer the following questions (any six) 18
(a) What is total participation of the entity ? Explain with example.
(b) The BCNF is always in 3NF. Justify.
(c) What is the use of to_char and to_date function ?
(d) In having clause of group by clause, which type of conditions user can give ?
(e) What is grant command ? Which type of privileges the user can give to another user ?
(f) Why SQL is called the structured language ?
(g) Explain IN and NOT IN clause with example.
4 Answer the following questions (any four) 16
(a) Write SQL statements by considering following tables (tables are already created)
Stud_master (srno, sname, sdiv,s_sem,city,area,bdate)
Assign_master(assign_no, assign_name, assign_sub, due_date, no_of_assign)
Assign_complt (srno, assign_no, assign_sub, status (C for complete, I for incomplete), submitted_date)
(i) Find the students who have not submitted dbms assignments of b division.
(ii) Find the student detail who is greater than 15 years and submitted the assignment of cpp.
(b) Find the functional dependencies exist in all the tables mentioned in A. Is there any partial dependency exist ?
(c) Explain ALTER table command to add, remove and modify the constraints with the table including example.
(d) What is business constraint ? How to give the constraint? Where the constraints are stored in oracle ?
(e) There is one database regarding patient and hospital. Assume the required fields and give the answer.
(i) Find the charges paid by the patient admitted for 3 days in deluxe room.
(ii) Find the patients who admitted in general ward and belonging to Baroda.
SB-3822] 3 [200 ]
|
Attachment: |
| Earning: Approval pending. |
