For creating a student information management system of a University a database management system is better than that of file management system.” Justify the statement given above. Now, assume that you are assigned the role of database administrator for the University database. What are the key responsibilities you have to handle?

Consider the database schema of Question3, suggest at least two different types of users for the system. You may use my_account view for one of the users. Create an authorization matrix for the relations. Make suitable assumptions, if any.

Compare and contrast the two tier model to that of 3 tier model client server architecture. Can you implement the database given in question 3 as a 3 tier model? Explain your answer.

What is a deadlock? How can you detect deadlock? Explain with the help of a wait for graph. What are the possibilities that the deposit and withdrawal transactions as created in part (iii) will result into deadlock? Explain your answer.

Consider the following employee record in an organization

Employee (ID, name, date of joining, age, address, department, manager, ID’s of projects working on, role in the project, project name, project team leader, duration of project, dependent names)

An employee works in one department. Each department is managed by one manager. An employee can work on many projects. A projects has team leader. An employee can have many departments, however, one department can be related to only one employee.

Identify the functional dependencies in the relation given above. Normalize the relational up to BCNF. Make suitable assumptions, if any

Compare and contrast the features of sequential, indexed and hashed file organizations. Consider the problem(ii) in this question; propose a suitable file organization for each of the relation created. Justify your selection of file organization.

Now, assume that the bank schema as given in Question 3 is being implemented using distributed database. Suggest suitable data fragmentation needed for this distributed database.