IS07
Database
Management
(For
CNM Cases)
Assignment – I
Assignment
Code: 2016IS07A1 Last Date of Submission: 30th April 2016
Maximum Marks: 100
Attempt all the questions. All the questions are compulsory and
carry equal marks.
Section-A
1. Discuss the role and significance of
Database Management System in today’s business environment.
2. What do you understand from “Database Transaction”? How it can be managed?
3. Write notes on:
a. ERD Model
b. Relational Algebra
4. What do you mean by Database Model? Differentiate between different data models.
Section-B
Case Study
Consider a mission critical transaction
database maintained by a reputed nationalized bank. The data includes customer
name, account number, phone number, branch code, bank balance among others.
With the advent of new technologies and the growth of internet, the bank too
has moved from the traditional ways of banking to introduce new features such
as ATMs, Net Banking, Wire transfer, Credit Card, Electronic Clearing System
which has helped the bank not only retain its old and loyal customers but also
expand its horizon in including the younger generation to its customer base.
The ICT infrastructure of the bank includes various servers, printers, ATMs, network
switches and also other peripheral devices. Assuming you have been recruited as
Manager (IT) who will be the database administrator of the bank holding charge
of database security, answer the following questions:
5. Case
Questions:
- List
the security guidelines that a conscientious database designer should
follow?
- What
are the types of authorization which can be implemented in this case?
No comments:
Post a Comment