provide at least an estimate if historical records are not available)? Provide i
ID: 640773 • Letter: P
Question
provide at least an estimate if historical records are not available)? Provide information for either one example of a personal database, or one example of a corporate database that you are familiar with. Even if you are not experienced with databases yourself, the idea is to go find out about the effort needed to maintain the database and upgrade the DBMS software periodically, and make sure you provide appropriate releasable citations for your references. This question in not concerned with the effort to initially build/develop and populate a database but instead the ongoing/long term effort to keep the data and DBMS functioning by DBAs.
Explanation / Answer
A database management system (DBMS) is a collection of programs that enables you to store, modify, and extract information from a database. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes. The following are examples of database applications:
Computerized library systems
Aautomated teller machines
Fflight reservation systems
Computerized parts inventory systems.
AN EXAMPLE OF DISTRIBUTED DATABASE : AIRLINE RESERVATION SYSTEM
The flight details
It includes the originating flight terminal and destination terminal, along with stops in between, number of seats booked/available seats between two destination etc.
Customer Description
It includes customer code, name, address and phone number. This information may be used for keeping the records of customer for any emergency or for any other kind of information
Reservation Description
It includes customer code number, flight number, date of booking, date of traveling.
A distributed database system consists of a collection of sites, each of which may participate in the execution of transactions which access data at one site, or several sites. The main difference between centralized and distributed database systems is that, in the former, the data resided in one single location, while in the latter, the data resided in several locations.
Each site is able to process local transactions, those transactions that access data only that single site. A site may participate in the executions of global transactions, those transactions that access data in several sites. The execution of global transactions require communication among the sites.
Each site is a database system site in its own right. In other words, each site has its own local
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.