• 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...

Introduction

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.

Middle

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.

Conclusion

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.

    This can be found at the left-hand side of the screen. This is my customers data entry form to fill it in you must use the next customer ID which is 3 digits long then fill in the customers surname it will automatically start with a capital letter because there is an input mask in.

  2. Database Design Guideline

    It is a common link between the two tables. It gives your database a good overall structure. I will be creating a relationship between the doctors and patients table; in Microsoft Access for my database. The relationship will be showing what the two tables have in common as I will identify and explain below.

  1. Database design for a farmers herd book.

    Each of the rows in a table is called a record and the items in the columns are called fields. In these relational databases there will be an assortment of tables - one for each entity type; i.e. there could be a table for patients, suppliers and one for products.

  2. Financial Model to help organise the year eleven prom

    So it helps them out a little. Furthermore it will give them a little more money so they can continue their research for more venues, catering firms, music and decorations etc. They can try and get previous problems sorted as well.

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