SMU MBA 3 SEMESTER MI0034 – DATABASE MANAGEMENT SYSTEM FALL 2015-2016
SMU MBA FALL 2015 -2016
Dear Students,
SMU MBA FALL 2015-2016 Assignments are available. For Booking ,Kindly mail us on kvsude@gmail.com OR call us to +91 9995105420 or S M S your “ Email ID ” us in the following Format “ On +91 9995105420 we will reach back you with in 24H ”
ASSIGNMENT
DRIVE | Fall 2015 |
PROGRAM | MBADS (SEM 3/SEM 5) MBAFLEX/ MBA (SEM 3) PGDISMN (SEM 1) |
SUBJECT CODE & NAME | MI0034 – DATABASE MANAGEMENT SYSTEM |
BK ID | B1966 |
CREDIT | 4 |
MARKS | 60 |
Note: Answer all questions. Kindly note that answers for 10 marks questions should be approximately of 400 words. Each question is followed by evaluation scheme.
Q.No | Questions | Marks | Total Marks |
1 | The data is stored in the form of tables which can be retrieved efficiently by any program as per the request. Since the database users are vast in number, the database provides authentication. Explain the different types of database users. | ||
A | Listing alteast 4 different database users | 2 |
10 |
Explaining them | 8 | ||
2 | Computer storage is divided into primary memory and secondary memory. Discuss with an example, the different types of primary memory and secondary memory. | ||
A | Listing the types of primary memory | 1 |
10 |
Listing the types of secondary memory | 1 | ||
Describing the types of primary memory | 2 | ||
Describing the types of secondary memory | 6 | ||
3 | Consider any one example of a relational database and show how the different operations of relational algebra can be performed on the table showing the output. | ||
A | Listing the types and its subtypes | 3 |
10 |
Explaining with an example | 7 | ||
4 | Describe the different normal forms with one example throughout. | ||
A | Listing the 5 important normal forms | 2 |
10 |
Definitions for each of them | 3 | ||
Explanation for each of them using one example throughout | 5 | ||
5 | Write Short Notes on
a. Transaction Commit b. Atomicity c. Deferred update d. Security e. System log |
||
a. Transaction Commit | 2 |
10 |
|
b. Atomicity | 2 | ||
c. Deferred update | 2 | ||
d. Security | 2 | ||
e. System log | 2 | ||
6 | With an example explain the working of ODBMS. | ||
Explaining with an example | 10 | 10 |
SMU MBA FALL 2015 -2016
Dear Students,
SMU MBA FALL 2015-2016 Assignments are available. For Booking ,Kindly mail us on kvsude@gmail.com OR call us to +91 9995105420 or S M S your “ Email ID ” us in the following Format “ On +91 9995105420 we will reach back you with in 24H ”