University Of Pune Question Paper
B. F. T. / B. B. M. (I.B.) ( Semester - III ) Examination - 2013
BASICS OF COMPUTERS - II
(Old 2004 Pattern)
Time : 3 Hours] [Max. Marks : 80
Q.1) Attempt any two of the following :
(a) Describe Various DML Commands. [10]
(b) Explain the Prototyping Model. [10]
(c) Define System with example and describe following types of
System : [10]
(i) Open and Closed System
(ii) Deterministic and Probabilistic System
Q.2) Attempt any two of the following :
(a) Write a note on Natural Join. [10]
(b) Define : [10]
(i) Domain
(ii) Primary Key
(iii) Cardinality
(iv) Single Valued Attribute
(v) Entity Set
(c) Consider the following Actor Table and solve SQL querries : [10]
(Act_no, Act_name, Movie_name, Release_year)
(i) Insert two records in Actor Table.
(ii) Display all actors of movie ‘Dhoom’.
(iii) Display all movies of actor ‘Kajol’.
(iv) Count all movies released in year 2012.
(v) Display actorwise movie details.
[4374]-307 1 P.T.O.
Seat
No.
Q.3) Attempt any two of the following :
(a) Explain the term : LAN, WAN, MAN. [10]
(b) Define Network. Explain various uses of Network. [10]
(c) Explain various types of Viruses. [10]
Q.4) Attempt any two of the following :
(a) Define Feasibility Study. Explain the following types of Feasibility
Study : [10]
(i) Technical Feasibility Study
(ii) Operational Feasibility Study
(iii) Economical Feasibility Study
(b) Explain the term Normalisation with suitable example. [10]
(c) A grocery market ‘G-MART’ comprises of wholesale grocery
merchants. Grocery Merchants buy all grocery items directly
from farmers. Any merchant can buy an item from only one
farmer (that is, if he buys rice from farmer ‘A’, he cannot buy
from anyone else.). There are registered small shop owners who
buy from wholesale grocery merchants. The wholesale merchants
can sell to many small shop owners. Each small shop owner
hires street vendors and sells his product.
Construct E-R Diagram for above case.
B. F. T. / B. B. M. (I.B.) ( Semester - III ) Examination - 2013
BASICS OF COMPUTERS - II
(Old 2004 Pattern)
Time : 3 Hours] [Max. Marks : 80
Q.1) Attempt any two of the following :
(a) Describe Various DML Commands. [10]
(b) Explain the Prototyping Model. [10]
(c) Define System with example and describe following types of
System : [10]
(i) Open and Closed System
(ii) Deterministic and Probabilistic System
Q.2) Attempt any two of the following :
(a) Write a note on Natural Join. [10]
(b) Define : [10]
(i) Domain
(ii) Primary Key
(iii) Cardinality
(iv) Single Valued Attribute
(v) Entity Set
(c) Consider the following Actor Table and solve SQL querries : [10]
(Act_no, Act_name, Movie_name, Release_year)
(i) Insert two records in Actor Table.
(ii) Display all actors of movie ‘Dhoom’.
(iii) Display all movies of actor ‘Kajol’.
(iv) Count all movies released in year 2012.
(v) Display actorwise movie details.
[4374]-307 1 P.T.O.
Seat
No.
Q.3) Attempt any two of the following :
(a) Explain the term : LAN, WAN, MAN. [10]
(b) Define Network. Explain various uses of Network. [10]
(c) Explain various types of Viruses. [10]
Q.4) Attempt any two of the following :
(a) Define Feasibility Study. Explain the following types of Feasibility
Study : [10]
(i) Technical Feasibility Study
(ii) Operational Feasibility Study
(iii) Economical Feasibility Study
(b) Explain the term Normalisation with suitable example. [10]
(c) A grocery market ‘G-MART’ comprises of wholesale grocery
merchants. Grocery Merchants buy all grocery items directly
from farmers. Any merchant can buy an item from only one
farmer (that is, if he buys rice from farmer ‘A’, he cannot buy
from anyone else.). There are registered small shop owners who
buy from wholesale grocery merchants. The wholesale merchants
can sell to many small shop owners. Each small shop owner
hires street vendors and sells his product.
Construct E-R Diagram for above case.
0 comments:
Pen down your valuable important comments below