1.7 List four applications you have used that most likely employed a database. answer:

1500 WordsApr 23, 20196 Pages
1.7 List four applications you have used that most likely employed a database. answer: 1.Reservations: Reservations are mostly used for booking the tickets of airlines,and booking tickets of buses and to see the availability of seats and for schedule information. reservations are free from data redundancy and it provides exact information of the passenger details and also we can know seats availability all over the world. Reservations were among the first to use databases in a geographically distributed manner.each and every department needs to have at least one instructor in order for building the information to be included about the availability of seats in the table. Null values can be used when there…show more content…
Answer: Initially both database management system and file processing system are used to store the data in files but the main difference is 1.According to their accessing rights data base can be accessed all over the world but not in case of file processing system because file processing system is restricted to particular area. 2.Duplication of data which means duplicate the values and cannot enter null values in database management system but we can do both the things in file processing system 3.In my point of view database management system is user friendly when compared with file processing system. 4.data integrity is the major problem in file processing system but not in data base management system. 1.9 Explain the concept of physical data independence, and its importance in DBMS answer: Physical data independence: It refers to the immunity of the conceptual schema to changes in the internal schema, These are the changes can be done on the internal schema file organizations or storage structures and devices, editing indexes, should be possible without having to change the conceptual schemas.In my point of view, the only effect that may be noticed is a change in performance. *we can Switch from one access method to another. *system to store exact and accurate data. * Different type of data structures can be used. * Using different file organizations. *Using different storage structures. * Usage of new storage devices Physical data independence

More about 1.7 List four applications you have used that most likely employed a database. answer:

Open Document