Question

Consider the database schema of Question 3. Create sample transaction log for the transactions that you have defined in Q3 part (iii). Explain how this log may be used to recover from failure.

28 Oct 2017
Answer :
Word Count : 119

A schema is a logical database description & is drawn as a chart of the types of data that are used. It gives the names if entities

____ _______ _________ _______ ________ ___ _____ __________ ___ ____ ________ _______.
____ ______ _______ ______ ______ ________ ______ _______ _________ ___ ________.
_______ ___ ______ _________ ______.
________ _____ _______ _________ _______.
________ ____ ________ _________ _____.
________ _____ _________ _____ ____ ___.
_____ _________ _____ ____ ___ ________ _______ __________ __________ _________ ______ _______.
___ ________ ___ _____ ____ ______ _____ _________ _________ __________.
________ __________ ______ ___ ______ _________ ______ ______ _______ _______ _______ ____.
____ ______ _______ _____ _______ _________ ______ ______.
__________ ____ __________ _____ _____ __________.
IGNOU ACADEMY
Your IGNOU journey, made easier.
  • Solved Assignments
  • Study Notes
  • Guess Papers
  • Question Papers
Call Us WhatsApp
STUDY • PREPARE • SUCCEED
Skip in 10
Related Questions

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

 

 

Create the relations from the E-R diagram that you have drawn for part (ii). The relations must be at least in 2NF. You must do the following with the relations

 

  1. Enter about 5 sets of meaningful data in each of the relations
  2. Identify the domain of various attributes
  3. Identify the primary keys of all the relations
  4. Identify the foreign keys and referential integrity constraints integrity constraints in the relations.

 

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.

What are the problems associated with data Redundancy in a relation? How can you solve those problems? Can referential integrity constraints help in addressing those problem? Give reasons in support of your answer.

 

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.

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.

 

 

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?

 

IGNOU Solved Assignments Assignments Ignou Projects Project Previous Year Solved Exam Papers Notes Notes Sample Question Papers Sample Question Papers
Login
Top
📞
Call Support Instant phone assistance IGNOU MCS 23 2010 2011 - Consider the database schema of Question 3. Create sample transaction | IGNOU Academy
→
🟢
WhatsApp Chat Fast live messaging
→
Email Us Business enquiries & support
→