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

Database Systems - Assignment Example A distributed request refers data from several different data processor sites. Each request can access data from many sites where a transaction access several data sites. Similar to requests, transactions can also be categorised as remote 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 location but the entire transaction will refer several sites to complete the transaction. Question 2 Most of these problems occur due to data transformation incompatibilities and conventions used. With in the different divisions of an organization, operational data may vary in terms of how they are recorded or on the data type and structures used. For an example if we take a sales company the Customer service division may use ‘pending’,’ active’, ‘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 instance where the phone number can be entered as 091-3453489 by Audit division and the Customer services division enters it as 0913453489.