Scribd
Upload
12 views2 pages

Advantages of Database Systems

A database is a computerized collection of records organized to minimize redundancy and maximize access. The main advantages of databases are reduced data redundancy, increased consistency, improved data integrity and independence from applications, improved data access through languages, and reduced costs. Potential disadvantages include complexity, high start-up costs, damage affecting all programs, high conversion costs, and initial training needs. Database design is a major software development phase and a well-designed database can be vital for success by reflecting real-world structures, representing all expected data over time, avoiding redundancy while ensuring consistency, providing efficient access, and maintaining integrity over time.

Uploaded by

Belllaa Edward
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
12 views2 pages

Advantages of Database Systems

A database is a computerized collection of records organized to minimize redundancy and maximize access. The main advantages of databases are reduced data redundancy, increased consistency, improved data integrity and independence from applications, improved data access through languages, and reduced costs. Potential disadvantages include complexity, high start-up costs, damage affecting all programs, high conversion costs, and initial training needs. Database design is a major software development phase and a well-designed database can be vital for success by reflecting real-world structures, representing all expected data over time, avoiding redundancy while ensuring consistency, providing efficient access, and maintaining integrity over time.

Uploaded by

Belllaa Edward
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

4.

1 Database
A database is a computerizes collection of records which is organized in such a
way that minimizes redundancy and maximizes access.
4.1.1 Advantages of Databases
1. The most important advantages of databases
are as follows:
2. Reduced data redundancy
3. Reduced updating errors and increased consistency
4. Greater data integrity and
independence from
applications programs
5. Improved data access to users through use
of host and query languages
6. Improved data security
7. Reduced data entry, storage, and retrieval costs
8. Facilitated development of new applications program
4.1.2 Disadvantages of Databases
1. Database systems are complex, difficult, and time-consuming to design
2. Substantial hardware and software start-up costs
3. Damage to database affects virtually all applications programs
4. Extensive conversion costs in moving form a file-based system
to a database system
5. Initial training required for all programmers and users
4.2 Database Design
Database design is one of the major phases in software development. Database
acts as the backbone of any software. A well designed database can play a vital
role in the success of a system so this phase must be carried out with great
responsibility.
4.2.1 Qualities of Good Database Design
1. Reflects real-world structure of the problem.
2. Can represent all expected data over time
3. Avoids redundancy and ensures Consistency
4. Provides efficient access to data
5. Supports the maintenance of data integrity over time

You might also like