SEM 3- MI0034 – DATABASE MANAGEMENT SYSTEM WINTER 2014-15
SMU MBA WINTER 2014-2015 solved Assignments
Dear Students,
SMU MBA WINTER 2014 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 ”
DRIVE WINTER 2014
MI0034 – DATABASE MANAGEMENT SYSTEM
Q1. 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. (Listing at least 4 different database users, Explaining them) 2, 8
Q2. Computer storage is divided into primary memory and secondary memory. Discuss with an example, the different types of primary memory and secondary memory. (Listing the types of primary memory, Listing the types of secondary memory, Describing the types of primary memory, Describing the types of secondary memory) 1, 1, 2, 6
Q3. 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. (Listing the types and its subtypes, Explaining with an example) 3, 7
Q4. Describe the different normal forms with one example throughout. (Listing the 5 important normal forms, Definitions for each of them, Explanation for each of them using one example throughout) 2, 3, 5
Q5. Write Short Notes on: 2, 2, 2, 2, 2
- Transaction Commit
- Atomicity
- Deferred update
- Security
- System log
Q6. With an example explain the working of ODBMS. (Explaining with an example) 10
SMU MBA WINTER 2014-2015 solved Assignments
Dear Students,
SMU MBA WINTER 2014 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 ”