IS07
Database Management
Assignment – I
Assignment Code: 2015IS07A1 Last Date of Submission: 15th May 2015
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:
a. List the security guidelines that a conscientious database designer should follow?
b. What are the types of authorization which can be implemented in this case?
IS07
Database Management
Assignment – II
Assignment Code: 2015IS07A2 Last Date of Submission: 15th May 2015
Maximum Marks: 100
Attempt all the questions. All the questions are compulsory and carry equal marks.
Section-A
1. What is normalization? Explain the advantages of normalization. Explain the first normal Form (1NF), second normal form (2NF) and the third normal form (3NF) with an example.
2. What do you understand by Database Design? Differentiate between Physical and Logical Design.
3. Explain Database Management Life Cycle taking an example.
4. Write short note on:
a. Object Oriented Database
b. Data Warehousing
Section-B
Case Study
Assume you are given the following relations:
Take(StudentID, CourseID)
RequiredForGraduation(CourseID)
The Take relation lists IDs of students and IDs of courses taken by the students. The RequiredForGraduation relation lists the courses every student must take to graduate. The following division query finds the students who have satisfied all the requirements for graduation.
SELECT StudentID
FROM Take AS T, RequiredForGraduation AS R
WHERE T.CourseID = R.CourseID
GROUP BY T.StudentID
HAVING COUNT(T.CourseID) = (SELECT COUNT(CourseID) FROM RequiredForGraduation);
Case Questions:
5. You have an allergy to the HAVING clause. Rewrite this query without using the HAVING clause.
Database Management
Assignment – I
Assignment Code: 2015IS07A1 Last Date of Submission: 15th May 2015
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:
a. List the security guidelines that a conscientious database designer should follow?
b. What are the types of authorization which can be implemented in this case?
IS07
Database Management
Assignment – II
Assignment Code: 2015IS07A2 Last Date of Submission: 15th May 2015
Maximum Marks: 100
Attempt all the questions. All the questions are compulsory and carry equal marks.
Section-A
1. What is normalization? Explain the advantages of normalization. Explain the first normal Form (1NF), second normal form (2NF) and the third normal form (3NF) with an example.
2. What do you understand by Database Design? Differentiate between Physical and Logical Design.
3. Explain Database Management Life Cycle taking an example.
4. Write short note on:
a. Object Oriented Database
b. Data Warehousing
Section-B
Case Study
Assume you are given the following relations:
Take(StudentID, CourseID)
RequiredForGraduation(CourseID)
The Take relation lists IDs of students and IDs of courses taken by the students. The RequiredForGraduation relation lists the courses every student must take to graduate. The following division query finds the students who have satisfied all the requirements for graduation.
SELECT StudentID
FROM Take AS T, RequiredForGraduation AS R
WHERE T.CourseID = R.CourseID
GROUP BY T.StudentID
HAVING COUNT(T.CourseID) = (SELECT COUNT(CourseID) FROM RequiredForGraduation);
Case Questions:
5. You have an allergy to the HAVING clause. Rewrite this query without using the HAVING clause.
No comments:
Post a Comment