answersLogoWhite

0


Best Answer

The advantages of a relational database are that they contribute to sound logical design, are easy to understand and program, and should be amenable to change as business requirements change. The main earlier systems include file-based systems and Codasyl databases. File-based systems were complex and tended to be inherently restrictive and quickly reached the point where a complete rewrite became necessary if business requirements changed. Codasyl databases were a vast improvement on the old file-based systems, but required a high level of expertise to design properly and, once again, tended to be unable to support changes to business requirements. Because a properly designed relational database reflects business entities and the relationships among those entities, they should be more logical and easier to understand. If the business structure or requirements change in any logical way, the database can be changed in a parallel way, to support those requirements. Relational databases are designed at two levels. First, there is a logical design, normalised at third normal form - where there should not be duplicate data values. Then, there is a physical design, where any necessary denormalisation is carried out.

User Avatar

Wiki User

7y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

13y ago

Some of the advantages of relational databases include the ability to link information about a particular person who is in several databases together by simple links. One disadvantage is that once the database is created it is not changed easily so any database forming as part of a relational database must be very carefully planed before anything else can be done

This answer is:
User Avatar

User Avatar

Wiki User

11y ago

Hi,

Relational database system is machine performance. If the number of tables between which relationships to be established are large and the tables themselves are voluminous, the performance in responding to queries is definitely degraded. It must be appreciated that the simplicity in the relational database approach arises in the logical view. With an interactive system, for example an operation like join would depend upon the physical storage also. It is, therefore common in relational databases to tune the databases and in such a case the physical data layout would be chosen so as to give good performance in the most frequently run operations. It therefore would naturally result in the fact that the lays frequently run operations would tend to become even more shared.

This answer is:
User Avatar

User Avatar

Wiki User

16y ago

data base approach advantages and disadvantages

This answer is:
User Avatar

User Avatar

Wiki User

9y ago

There are number of advantages of database. However there are some disadvantages too, like database system loses data integrity if it is not enforced also they come complex at times.

This answer is:
User Avatar

User Avatar

Wiki User

15y ago

nothing

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What are disadvantages of database approach?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Explain three disadvantages of centralized database and distributed database?

what are the disadvantages of centralized database system


Database approach VS traditional approach?

Database Approach vs. Traditional File ProcessingSelf contained nature of database systems (database contains both data and meta-data).Data Independence: application programs and queries are independent of how data is actually stored.Data sharing.Controlling redundancies and inconsistencies.Secure access to database; Restricting unauthorized access.Enforcing Integrity Constraints.Backup and Recovery from system crashes.Support for multiple-users and concurrent access.


What are the advantages of a database management approach to the file approach?

laleo


What is database approach?

•Database approach: approach whereby a pool of related data is shared by multiple application programs; offers significant advantages over traditional file-based approach


2.what are the advantages of database management approach to the file processing approach Give examples to illustrate your answer?

what are the advantages of database management approach to the file processing approach Give examples to illustrate your answer


Can data redundancy be completely eliminated when database approach is used?

Database is collection of some inter related records . And yes, data redundancy be completely eliminated when database approach is used.


When a company uses the approach many programs and users share the data in a database?

database


Disadvantages of a paper-based database?

Paper-based database is a collection of data on paper. There are many disadvantages when using paper-based database, some of the disadvantages are: Difficulty in sorting data, changes are done manually, no security, difficulties in sorting data.


Disadvantages of using database?

it is time consuming


Describe the main characteristics of the database approach and contrast it with the file-based approach?

The Database Approach has four common characteristics. These are: Self-describing nature, support multiple user view of data, share the data and multiple user transaction processing and insulation between data and data abstraction.


Disadvantages of Hierarchical database model?

Disadvantages of Hierarchical model are as follows: implementation complexity, database management problems, lack of structural independence and operational irregularity.


What are the advantages and disadvantages of humanistic approach?

What are the advantages and disadvatages of the humanistc approach?