1) Give an example of and describe an application that would require sequential
ID: 3918071 • Letter: 1
Question
1) Give an example of and describe an application that would require sequential access in:
a- The university environment, b-The insurance company environment, c-The furniture store environment
2) Give an example of and describe an application that would require direct access in:
a- The university environment, b- The insurance company environment, c-The furniture store environment
3 )What expectation should there be for a database management system with regard to handling data control issues such as data security, backup and recovery, and concurrency control? Why?
Explanation / Answer
1..Ans
The Example of sequential access in
a. Employee salary Record which all have to be processed each pay period to generate paychecks.
b. A history file of policy or claims. Note that these will also require direct access.
c. A sales history file.
2.ANS
The example of direct access
a. Finding a particular student's records when he/she comes in for course advising.finding the record for a particular course to get information about it.
b. Finding a particular claim when a customer phones in to ask a question about it.Finding information about a particular customer when the insurance agent needs to manage that customer's policies.
c.Finding information about a particular sale to see if payment has been made or to see if the warranty period of some furniture is still in effect.
3 ANS.
The Expectation is that a database management system should have facilities to handle all of thes issues because they are necessary for the proper management of data storage and retrieval system.the one database management system that all of the applications use as the interface to their data is the proper place for these issues to be handled in a single ,comman place,and way.It they were not designed to handle data control issue s such as the above each application program would be responsible for handling them on their own,which would be a waste of money.A data base management system must be able to handle all standard inds of multiple relationships without introducing data redundancy.it must be able to handle all thes relationships because they are necessary to properly perfect the real world environment.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.