• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Design of the Data Model

Extracts from this document...


Design of the Data Model This is an ER diagram before any normalisation processes has been carried out. Above is a display of four of the entities of the AZ Cut n Stylez organisation, these are Appointment, Schedule, Client, and Provider. ...read more.


e.g. Provider ID in the Provider entity. Non Atomic Data: Data that has not been broken up into its smallest possible parts to create new fields. This type of data is not specific and can lead to confusion. ...read more.


And if possible middle name. Repetition of Data: Data in which can force the individual using the system to create another field and can even make unlimited fields e.g. Option A, Option B etc.... This can cause loss of time and problems such as define a specific search criteria. This can be resolved by giving these fields such as the option fields its own entity. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. Database design.

    From here I will click the NEW button shown below. Then the following screen will appear, I will then click design view which is highlighted below. After clicking on new the window below will appear. I went to design view and then typed in the name I want the table to be saved as.

  2. Theatre Model

    I will combat this problem in the analysis. Analysis Research Before beginning this project I did some research. I contacted the Milfield Theatre by e-mail address asking for information on different types of tickets and the ticket prices. They sent me back some useful information on ticket prices, which I

  1. Database Design Guideline

    A relationship between the two tables is needed in Whipps Cross Hospital as then doctors will be able to read it easily as well as they can take any information from both of the tables which they want directly. Relationships are important because it shows the relationship between the two

  2. Database design for a farmers herd book.

    All things aren't entities - only those about which information should be captured. Information about an entity is captured in the form of attributes and/or relationships. If something is a candidate for being an entity and it has no attributes or relationships, it isn't an entity.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work