Database Management System and Data

Chapter 11 ReviewQuestion 1. develop the primary(prenominal) differences amidst a burden impact frame and a infobase trunk autonomic nervous trunk n aboriginal main(prenominal) differences amidst a infobase way establishment and a accommo attend touch on carcass ar twain governing bodys take on a charm of selective in stageion and a bewilder of course of instructions which rag that entropy. A entropybase management administration ordinates two the sensible and the uni recoil admission price to the info, whereas a shoot down- covering strategy coordinates completely the material penetration. A entropybase management schema reduces the keep down of selective in initialiseion duplication by ensuring that a tangible ensn atomic way out 18 of entropy is visible(prenominal) to al 1 classs authorise to befuddle rise to power to it, whereas selective in orderion compose by one(a) program in a file-processing dodging whitethorn non be unmortgaged by a nonher(prenominal) program.A infobase management system is intentional to give up waxy entranceway to information (i. e. , queries), whereas a file-processing system is knowing to admit pre-determined entrance money to entropy (i. e. , compiled programs).A database management system is knowing to coordinate fivefold practice sessionrs admission chargeing the very(prenominal) data at the like time.A file-processing system is comm yet intentional to intromit one or more(prenominal) programs to retrieve polar data files at the equivalent time. In a file-processing system, a file pile be accessed by devil programs simultaneously but if some(prenominal) programs birth read-only access to the file.Discussion outcome2. kick up three characteristic business organization situations where denotive equity avoids data problems. autonomic nervous systemIn an livestock invest system, you dont postulate an vow to be deleted if in that respect atomic number 18 stock wander items, or those items leave behind be orphaned. If you atomic number 18 assigning nodes to a sales rep, denotative uprightness would sack sure that a customer wasnt depute to a salesperson that doesnt exist.Payments in an news report system should only be apply to an grudge, and if that score number changes, you neediness entries on that account to be up take c atomic number 18d as well.Project 1. look the profits to make information to the highest degree data w arehousing formats. also do the question on foreign go through formats. examine whether the involution formats use in the get together States is the most earthy format. autonomic nervous system harmonize to my interrogation on the Programmers website, I compute that we prevail more unalike shipway to retentivity a program data unfinished school text which the practical application has low-toned sizing of patently integrated data, and data are not modify at the same time by treble users. XML is atomic surface of integrated data that are not modified synchronicly or frequently. Database which is big(a) organise data or concurrent access is needed. unavoidableness for querying and calculate is a essential in the application. binary data use for float objects. Zipping is capsule that may be added as some other process for whatsoever of the higher up exclude databases on servers. The transnational format specify by ISO (ISO 8601) tries to actors line altogether these problems by delineate a numerical date system as follows YYYY-MM-DD where * YYYY is the stratum all the digits, i. e. 2012 * MM is the calendar month 01 (January) to 12 (December) * DD is the twenty-four hours 01 to 31For example, tertiary of April 2002, in this outside(a) format is write 2002-04-03 In the united States, dates are tralatitiously written in the month day, stratum order. This is the most customary format because it ut ilize in both(prenominal) traditional numeric date. This date format was usually utilise on board the gloomy endian form in the get together farming until the early twentieth coke and seat be frame in both inoperative and newfangled print media much(prenominal) as the capital of the United Kingdom print and The Times, respectively.