Database Systems Assignment Example | Topics and Well Written Essays - 250 words

Database Systems - Assignment ExampleA distributed request refers info from several different info processor sites. Each request can access data from some sites where a transaction access several data sites. Similar to requests, transactions can also be categorised as outback(a) and distributed. A remote transaction is composed with several requests but accesses data in a single data processor site. A distributed transaction allows referring several local and remote data processor sites where an individual request can refer data in single muddle but the entire transaction will refer several sites to complete the transaction. Question 2 close of these problems occur due to data transformation incompatibilities and conventions used. With in the different divisions of an organization, operational data may shift in terms of how they are recorded or on the data type and structures used. For an example if we administer a sales company the Customer service division may use pending, vigorous, inactive and cancelled but Audit division may use number tags such as 1, 2, 3, and 4. For same two divisions they may use different conventions for entering customer phone number to the database. For an pillowcase where the phone number can be entered as 091-3453489 by Audit division and the Customer serve division enters it as 0913453489.