Deemed University 2010 M.B.A University: Lingayas University Term: III Title of the : Management Database System - Question Paper
Roll No. ..
Lingayas University, Faridabad
MBA (Term III )
Examination May, 2010
Management Database System (BA -112)
[Time: 3 Hours] [Max. Marks: 100]
Before answering the questions, candidate should ensure that they have been supplied the correct and complete question paper. No complaint in this regard will be entertained after examination.
Note: Attempt Five Questions in all. Question No. 1 (Section-A) is compulsory. Attempt any two questions form Section B and any two from Section C. All Questions carry equal marks.
Section A
Part-I
Q-1. Answer briefly to the point: (1x10=10)
(i) Differentiate Data and Information by giving suitable example.
(ii) What is domain in DBMS?
(iii) What do you mean by the term Self Describing in database?
(iv) Differentiate Entity and Entity occurrence.
(v) What is a foreign key in relational database?
(vi) Define strong entity type.
Choose the correct option in the below given questions.
(vii) Which of the following is not a DML command
(a) Select (b) Alter (c) Update (d) Insert
(viii) A record is a collection of
(a) Fields (b) Files
(ix) A WHERE clause in the SQL language
(a) makes restriction on row selection
(b) makes restriction on column/attribute selection
(x) A key in a table is
(a) Row(s) of the table (b) Column(s) of the table
Part-II
Given the following database tables.
Emp |
Ename |
Basic_sal |
City |
Dept_id |
Dept |
DNo |
Dnames |
||||
001 |
Smith |
2000 |
Delhi |
D02 |
|
D01 |
Production |
||||
002 |
Jones |
6000 |
Bombay |
D03 |
|
D02 |
Research |
||||
003 |
Blake |
8000 |
Delhi |
D03 |
|
D03 |
Finance |
||||
004 |
Adams |
7000 |
Patna |
D02 |
|
D04 |
Marketing |
||||
005 |
John |
6500 |
Dehradun |
D04 |
|
|
|
Dept_id of Emp table references the DNo of Dept
table, write the SQL querries for following (any 5) (2x5=10)
(a) Get complete details of employees whose basic salary is greater than 3000.
(b) Get names and basic_sal of employees who belong to Delhi
(c) Get Emp_id, Ename, Basic_Sal of employees whose city begins with the letter D
(d) Get complete details of employees who belong to department D03
(e) Get complete details of employees who belong to Finance department.
(f) Get names, Emp_id and department names of all employees.
Section B
Q-2. What is meant by Data modeling? Explain network, hierarchical, Relational models. Also compare the insertion, deletion and updation activities in these models using suitable examples. (20)
Q-3. Compare File processing and database processing. Discuss the advantages and disadvantages of using database processing. (20)
Q-4. Explain data warehousing concept. Define data warehouse describing all its features. How does it differ from a database? (20)
Section C
Q-5. Name and describe various tools for Data warehousing. (20)
Q-6. Justify the need of recovery mechanism of database.
Give two recovery techniques assuming concurrent execution of transaction.
(20)
Q-7. Write an elaborate note on Data-mining comparing it with KDD. Discuss the
various techniques of Data-mining. (20)
Q-8. Write short notes on any four: (5x4=20)
(i) Data warehouse Schemes.
(ii) OLAP operations on a multi-dimensional data model
(iii) Data Marts and its types (iv) Relationships in ER model
(v) Metadata is data warehouse
Roll No. ..
Lingayas University, Faridabad
MBA (Term III )
Examination May, 2010
Management Database System (BA -112)
[Time: 3 Hours] [Max. Marks: 100]
Before answering the questions, candidate should ensure that they have been supplied the correct and complete question paper. No complaint in this regard will be entertained after examination.
Note: Attempt Five Questions in all. Question No. 1 (Section-A) is compulsory. Attempt any two questions form Section B and any two from Section C. All Questions carry equal marks.
Section A
Part-I
Q-1. Answer briefly to the point: (1x10=10)
(i) Differentiate Data and Information by giving suitable example.
(ii) What is domain in DBMS?
(iii) What do you mean by the term Self Describing in database?
(iv) Differentiate Entity and Entity occurrence.
(v) What is a foreign key in relational database?
(vi) Define strong entity type.
Choose the correct option in the below given questions.
(vii) Which of the following is not a DML command
(a) Select (b) Alter (c) Update (d) Insert
(viii) A record is a collection of Fields
(a) Fields (b) Files
(ix) A WHERE clause in the SQL language
(a) makes restriction on row selection
(b) makes restriction on column/attribute selection
(x) A key in a table is
(a) Row(s) of the table (b) Column(s) of the table
Part-II
Given the following database tables.
Emp |
Ename |
Basic_sal |
City |
Dept_id |
Dept |
DNo |
Dnames |
||||
001 |
Smith |
2000 |
Delhi |
D02 |
|
D01 |
Production |
||||
002 |
Jones |
6000 |
Bombay |
D03 |
|
D02 |
Research |
||||
003 |
Blake |
8000 |
Delhi |
D03 |
|
D03 |
Finance |
||||
004 |
Adams |
7000 |
Patna |
D02 |
|
D04 |
Marketing |
||||
005 |
John |
6500 |
Dehradun |
D04 |
|
|
|
Dept_id of Emp table references the DNo of Dept
table, write the SQL querries for following (any 5) (2x5=10)
(a) Get complete details of employees whose basic salary is greater than 3000.
(b) Get names and basic_sal of employees who belong to Delhi
(c) Get Emp_id, Ename, Basic_Sal of employees whose city begins with the letter D
(d) Get complete details of employees who belong to department D03
(e) Get complete details of employees who belong to Finance department.
(f) Get names, Emp_id and department names of all employees.
Section B
Q-2. What is meant by Data modeling? Explain network, hierarchical, Relational models. Also compare the insertion, deletion and updation activities in these models using suitable examples. (20)
Q-3. Compare File processing and database processing. Discuss the advantages and disadvantages of using database processing. (20)
Q-4. Explain data warehousing concept. Define data warehouse describing all its features. How does it differ from a database? (20)
Section C
Q-5. Name and describe various tools for Data warehousing. (20)
Q-6. Justify the need of recovery mechanism of
database. Give two recovery techniques assuming concurrent execution of
transaction.
(20)
Q-7. Write an elaborate note on Data-mining comparing it with KDD. Discuss the
various techniques of Data-mining.
(20)
Q-8. Write short notes on any four: (5x4=20)
(i) Data warehouse Schemes.
(ii) OLAP operations on a multi-dimensional data model
(iii) Data Marts and its types (iv) Relationships in ER model
(v) Metadata is data warehouse
Earning: Approval pending. |