
	Trending ▼ ICSE CBSE 10th ISC CBSE 12th CTET GATE UGC NET Vestibulares ResFinder

Pune University - FY BSc COMPUTER SCIENCE (Paper - II), April 2010

4 pages, 49 questions, 1 questions with responses, 1 total responses,

	pune_sci	+Fave Message
	Profile Timeline Uploads Q & A

Home > pune_sci >

Instantly get Model Answers to questions on this ResPaper. Try now!
NEW ResPaper Exclusive!

Formatting page ...

Total No. of Questions : 5] [Total No. of Printed Pages : 4 [3718]-2 F. Y. B. Sc. (Computer Science) Examination - 2010 COMPUTER SCIENCE PAPER - II FILE ORGANISATION AND FUNDAMENTALS OF DATABASE (New 2008 Pattern) Time : 3 Hours] [Max. Marks : 80 Instructions : (1) All questions are compulsory. (2) Figures to the right indicate full marks. (3) Neat diagrams must be drawn wherever necessary. Q.1) Answer the following : (Any Ten) (1) What is Logical File ? (2) Define Fixed Length Records . (3) What is Query Optimizer ? (4) What is Referential Integrity ? (5) Define Natural Join. (6) Define Domain . (7) Define Cardinality of an Entity. (8) Define DCL . (9) [1x10=10] What is Clustering Index ? (10) Define Ordering Field or Key Field of an Ordered File. (11) Explain use of Foreign Key Constraint. (12) List any 2 design goals of Relational Database. Q.2) Answer the following : (Any Four) [5x4=20] (a) What are different types of the Database Users ? (b) Consider the relation R = (A, B, C, D, G, H, I) and set of functional dependencies defined on R, F as {A B, A C, CG H, CG I, B H} (i) (ii) [3718]-2 Compute closure of F i.e. F+ and Compute closure of Attribute Set (AG)+ 1 P.T.O. (c) (d) Write a short note on B+ Tree Index Files. What is Aggregation ? Explain with example. (e) State rules to convert E-R diagram into tables. Q.3) Answer the following : (Any Four) [5x4=20] (a) State different File Organisations and explain Heap File Organisation in detail. (b) Write a note on Referential Integrity. (c) (d) What is Decomposition of Relation Scheme ? Write any four functions of DBA. (e) Differentiate between Weak Entity and Strong Entity with suitable example. Q.4) (A) Answer the following : (Any Three) (a) Consider the following database relations : [5x3=15] Country(Con-code, Name, Capital) Population (Pop-code, Population) Country and Population are related with one to one relationship. Create a relational database for the above and convert it in 3NF and solve the following queries in SQL : (i) (ii) List highest population country. Give name and population of country whose capital is Delhi . (iii) Print Countrywise Population. (b) Consider the following relation : Teacher (tno, tname, collegename, dept.) Etest (eno, testname) Teacher and Etest are related with many to many relationship. Create a relational database for the above and convert it in 3NF and solve the following queries in SQL : (i) Count no. of teachers who passed Set Exam of Computer Science. (ii) Delete all teacher details of Maths Dept. (iii) Print total no. of teachers passing respective exam. [3718]-2 2 Contd. (c) (B) [3718]-2 Consider the following relation : Employee (empno, empname, salary, comm., desg.) Department (deptno, deptname, location) Employee and Department are related with many to one relationship. Create a relational database for the above and convert it in 3NF and solve the following queries in SQL : (i) Find out employees who are working at Ahmednagar city location. (ii) Find maximum, minimum and average salary for every designation. (iii) Update commission for every employee by 5% who belongs to Computer Department . (d) Consider the following relation : Item (I_no, I_name, I_qty) Po (p_no, p_date, cost, qty) Supplier (s_no, s_name, s_addr.) Item and Po are related with one to many relationship and supplier and Po are related with one to many relationship. Create a relational database in 3NF and solve the following queries in SQL : (i) Find out po_no, po_date and supplier_name of Po which is maximum amount. (ii) List name of supplier to whom Po is given for Mouse . (iii) List name of supplier who is going to supply Monitor with minimum cost. Answer the following : (Any One) [5x1=05] (a) Consider the following relationships : Doctor (doct_no, doct_name, doct_address, doct_city) Hospital (hosp_no, hosp_name, street, hosp_city) Doct_Hosp (doct_no, hosp_no, date) Solve queries in Relational Algebra : (i) Find hospital name to which Dr. Padghan has visited. (ii) Find out all doctors who have visited hospital in the same city. 3 P.T.O. Q.5) (A) (B) (B) (iii) List name of hospital to which Dr. Shirsat has visited on 08/01/2010. (iv) List all doctors who visited Padghan Hospital . (v) List name of Hospital in Shrirampur . (b) Consider the following relationships : Player (pno, name, city) Game (gno, name, place) Player_Game (pno, gno, date) Solve queries in Relational Algebra : (i) Find list of players playing Cricket . (ii) Find list of games played by more than 10 players. (iii) Find list of players and games played on March 4, 2010 . (iv) List all available games in India. (v) List players playing cricket and football. Shramik Vidhyapit offers 10 courses on Information Technology . Each course is conducted in several batches, where the maximum batch size is of 50 students. For every batch separate instructor is appointed. When for a particular course minimum 25 students get admitted, then the timetable is prepared and separate classrooms and also instructors availability, daily one hour is allocated to each batch. As numbers of students is growing, it is difficult to the management to schedule the course. Suggest a suitable information system to handle the above problem : (i) Draw Entity-Relation Diagram for the Information System Design. (ii) Convert Entity-Relationship Diagram into Relational Database in 3NF. [07] Explain Degree of Relationship Type. [03] OR Write difference between Single Attribute and Multivalued Attribute. [03] [3718]-2/4

Formatting page ...

Top Contributors
to this ResPaper
(answers/comments)

Pari parmar
(1)

Formatting page ...

Additional Info : F.Y. B.Sc. COMPUTER SCIENCE (Paper - II) : File Organisation and Fundamentals of Database (New 2008 Pattern), Pune University
Tags : fy bsc computer science question papers, fybsc computer science paper II, file Organisation, database fundamentals, 2008 Pattern, new course, pune university exam papers, university of pune question papers, pune university science, pune university courses, bsc pune university, msc pune university, pune university solved question papers, pune university model question paper, pune university paper pattern, pune university syllabus, old question papers pune university

pune_sci chat

Horizontal lines at:
Guest Horizontal lines at:
AutoRM Data:
Box geometries: