Dbms

motility 1: What is infobase? resolve: A entropybase is a logically coherent collection of data with any(prenominal) inherent meaning, re looking some aspect of real world and which is designed, built and populated with data for a specific purpose. interrogative mood 2: What is DBMS? occlusion: ? Redundancy is controlled. ? Unauthorised access is restricted. ? Providing multiple user interfaces. ? Enforcing reasonably play constraints. ? Providing backup and rec every targety. suspicion 4: What is a database agreement? practise: The database and DBMS softw are together is called as database system. QUESTION 5: Disadvantage in File Processing dodging? effect: ? Data redundancy & inconsistency. ? Difficult in accessing data. ? Data isolation. ? Data haleness. ? Concurrent access is not possible. ? Security Problems. . QUESTION 6: Describe the three take aims of data abstraction? repartee: The are three levels of abstraction: ? Physical level: The low le vel of abstraction describes how data are stored. ? Logical level: The near higher level of abstraction, describes what data are stored in database and what family relationship among those data. ? View level: The highest level of abstraction describes sole(prenominal) fibre of entire database. QUESTION 7: Define the integrity rules ANSWER: There are two law rules. ? Entity Integrity: States that ?

Primary let on cannot have unsatisfying place? ? Referential Integrity: States that ? inappropriate Key can be either a NULL value or should be Primary Key value of other relation. QUESTION 8: What is extension and intension? ANSWER: Extension -It is th! e number of tuples present in a card at any instance. This is age dependent. Intension - It is a unending value that gives the name, structure of plug-in and the constraints laid on it. QUESTION 9: What is System R? What are its two major subsystems? ANSWER: System R was designed and developed over a period of 1974-79 at IBM San Jose Research Center . It is a prototype and its purpose was to confront that it is possible to build a...If you demand to get a luxuriant essay, order it on our website: BestEssayCheap.com

If you want to get a full essay, visit our page: cheap essay