Advantages And Disadvantages Of File Based System Approach

Table of Content

a. Profile 2

b. Describe fundamentals of database Management systems

i. Evolution of database management systems 3 ii. Advantages and disadvantage of the DMS

Approach vs. file based System approach

1. Advantages of Database Approach 4

2. Disadvantages of Database Management Approach 6

3. File Based Disadvantages 7

4. File Based System 8

c. Describe the following job roles RDBMS

i. Data Administrator 10 ii. Database Administrator 11 iii. Database Designer 12 iv. Application Developer 13

v. End User

file based System approach

• Advantages of Database Approach

i. Control of data redundancy: The database approach attempts to eliminate the redundancy by integrating the file. Although the database approach does not eliminate redundancy entirely, it controls the amount of redundancy inherent in the database. ii. Data consistency: By eliminating or controlling redundancy, the database approach reduces the risk of inconsistencies occurring. It ensures all copies of the data are kept consistent. iii. More information from the same amount of data: With the integration of the operated data in the database approach, it may be possible to derive additional information for the same data. iv. Sharing of data: Database belongs to the entire organization and can be shared by all authorized users.

v. Improved data integrity: Database integrity provides the validity and consistency of stored data. Integrity is usually expressed in terms of constraints, which are consistency rules that the database is not permitted to

Describe the following job roles related Database management system

a. Data Administrator

Data administrators ensure that large amounts of information are efficiently and effectively managed stored in computer databases. Data administrators ensure that information is easy to access and can be managed effectively in order to save time and money for the company.

For example, an organisation may have an electronic record of all of their customer data such as name, address, phone number, credit card number, and buying history. This information needs to be managed for a variety of purposes, for example, to send out invoices or catalogues, or log purchases and incentive program points. Such processes require special software (database management systems). Data administrators are responsible for the day-to-day operation of database management systems and for long range planning regarding system design and operation.

Specific duties and responsibilities vary depending on the size and type of employer. In very large organizations, data administrators may have specialized responsibilities and work in teams. In other organizations, one data administrator may be responsible for all aspects of data