Wednesday, August 27, 2008

queation #3

For those who are not working, research one company in the net who is using computerized database systems. Describe the use and/or nature of these systems and describe too the benefits/disadvantages from these systems. Include your reference.

The WESTERN UNION use database in hiring the employee and giving their salary . One table contains the fields EMPLOYEE-ID, LAST-NAME, FIRST NAME, and HIRE-DATE, and another table contains the fields DEPT, EMPLOYEE-ID, and SALARY, a relational database can match the EMPLOYEE-ID fields in the two tables to find such information as the names of all employees earning. a certain salary or the departments of all employees hired after a certain date.

The benefits are as fallow..
1.Is able to change the structure of the logical record (by adding or moving data fields).
2.It reduces the application programming effort.
3.It could easily look the files of an employee
4.It manages more efficiently the creation and modification of, and access to, data
The disadvantages are as fallow..
1.Because the details are stored and processed independently, details that are supposed to be the same (for example, a customer's name and address), might be inconsistent in the various applications.
2.When common data has to be changed, it must be changed in several places, causing a high workload.
3.If any copies of the data are missed, it results in the problems detailed in the previous point.

No comments: