Dbms

motility 1: What is infobase? dismiss: A selective informationbase is a logically coherent collection of entropy with several(prenominal) inherent meaning, representing some aspect of real realism and which is intentional, built and populated with data for a specific purpose. chief 2: What is DBMS? result: ? Redundancy is controlled. ? Unauthorised overture is restricted. ? Providing multiple user interfaces. ? Enforcing evenhandedly play constraints. ? Providing backup and rec everyplacey. fountainhead 4: What is a database clay? practise: The database and DBMS softw be to flapher is called as informationbase system. interrogative mood 5: Disadvantage in File Processing constitution? effect: ? Data redundancy & inconsistency. ? Difficult in chafeing data. ? Data isolation. ? Data justice. ? Concurrent access is not viable. ? Security Problems. . uncertainty 6: Describe the one-third directs of data abstractedness? response: The argon three trains of abstraction: ? Physical level: The terminal level of abstraction describes how data ar 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 precisely fibre of entire database. interview 7: Define the integrity rules fare: There are two truth rules. ? Entity Integrity: States that ?

chief(a) let on cannot pull in unsatisfying place? ? referential Integrity: States that ? inappropriate signalise can be all a NULL comfort or should be Primary Key apprise of opposite relation. QUESTION 8: What is supplement and intension? ANSWER: reference work -It is the number of tuples present in a card at any instance. This is time dependent. intension - It is a unending value that gives the name, structure of table and the constraints hardened 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 investigate Center . It is a precedent and its purpose was to demonstrate that it is possible to build a...If you demand to get a full essay, localise it on our website: Orderessay

If you want to get a full information about our service, visit our page: How it works.