Database Management System and Data

Chapter 11 ReviewQuestion 1. Explain the main differences amidst a file processing ashes and a entropybase system autonomic nervous system Some main differences between a entropybase management system and a file processing system beBoth systems contain a collection of data and a set of designs which recover that data. A database management system coordinates both the physical and the logical access to the data, whereas a file-processing system coordinates besides the physical access. A DBMS reduces the amount of data duplication by ensuring that a physical piece of data is available to on the whole programs definitive to have access to it, whereas data written by one program in a file-processing system whitethorn not be unclouded by another program.A DBMS is designed to allow flexible access to data (i. e. , queries), whereas a file-processing system is designed to allow pre-determined access to data (i. e. , compiled programs).A DBMS is designed to coordinate multiple us ers accessing the same data at the same time.A file-processing system is usually designed to allow one or more programs to access different data files at the same time. In a file-processing system, a file can be accessed by ii programs simultaneously only if both programs have read-only access to the file.Discussion Topic2. bespeak three typical business situations where referential integrity avoids data problems. autonomic nervous systemIn an inventory order system, you dont want an order to be deleted if in that respect are inventory order items, or those items will be orphaned. If you are assigning customers to a salesperson, referential integrity would make sure that a customer wasnt assigned to a salesperson that doesnt exist.Payments in an accounting system should only be applied to an account, and if that account number changes, you want entries on that account to be updated as well.Project 1. Search the Internet to find selective in setion about data storage sets. Also do the research on international date formats.Determine whether the date formats used in the fall in States is the most common format. ANS According to my research on the Programmers website, I think that we have many different ways to store a program data plain text which the application has small sizing of simply structured data, and data are not modified concurrently by multiple users. XML is small size of structured data that are not modified concurrently or frequently. Database which is large structured data or concurrent access is needed.Need for querying and search is a moldiness in the application. Binary data use for streaming objects. Zipping is compression that may be added as another process for any of the above turn out databases on servers. The international format defined by ISO (ISO 8601) tries to address all these problems by defining a numerical date system as follows YYYY-MM-DD where * YYYY is the year all the digits, i. e. 2012 * MM is the month 01 (January) to 12 (December) * DD is the day 01 to 31For example, 3rd of April 2002, in this international format is written 2002-04-03 In the joined States, dates are traditionally written in the month day, year order. This is the most common format because it used in both traditional numeric date. This date format was commonly used alongside the small endian form in the United Kingdom until the early 20th Century and can be set in motion in both defunct and modern print media such as the London Gazette and The Times, respectively.