Help shape GoConqr. What should we add next?

Flashcards

Disadvantages of normalisation

kiera.basi English 4 cards

Cards in this deck (4)

  1. 1Disadvantages- Reduced database performanceQueries have to be performed across many tables.
    This requires more processing and so it can use up CPU time which can slow you down
  2. 2Disadvantages- Coded dataTables store codes and ID's as foreign keys which is meaningless to the user.
    Take a long time for the user to find the related data if data is provided in tis raw table format.
  3. 3Disadvantages- Detailed analysis and designDesigned carefully to ensure to meet with the user.
    Complicated database structures require careful analysis of the real world organisations and need to be designed accurately.
    Consider the intended use of the database, such as recording data.
    Poorly designed relational database will not perform well
  4. 4Disadvantages- Complex queriesQueries that use data from several tables can be very complex and require a high level of skill and experience in order to design them well.

Information

Description
Flashcards on Disadvantages of normalisation, created by kiera.basi on 17/10/2014.
Created by
kiera.basi
Views
17
Rating

More on Database Normalization

Feedback

What is it about?

What should we add next?