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

    Entity types - VIDEO STORE Unnormalised Customer (Customer_ID, Customer_surname, Customer_firstname, customer_street, customer_town, customer_postocde, customer_phone (Video_name, category, cert, rental_price, date_out, date_returned, video_copies)) 1NF Remove repeating groups Customer (Customer_ID, Customer_surname, Customer_firstname, customer_street, customer_town, customer_postocde, customer_phone, Video_ID) Video (Video_ID, Video_name, Video_category, Video_cert, Video_rental_price, date_out, date_returned video_copies)

  2. Financial Model to help organise the year eleven prom

    Changing one firm of a cost each time. This is of course assuming there is going to be 200 people coming. An expensive way of solving the problem would be to use a specialist program that would work out the sums automatically. However the program would have to be designed which costs a lot of money.

  1. Database Design Guideline

    For example 'Doctors ID' witch will be common in both tables in my database. Then on one of the two tables I will have to click on the 'Doctor's ID' and drag it to the other table where it says Doctor's ID and, then I can find any other relationship if so between the two tables.

  2. Database design for a farmers herd book.

    Database entities appear in a data model as a box with a title. The title is the name of the entity. . Entities are limited to the following five types: 1 - Person - Person entities are limited to humans. A person may be a single individual or a group.

  1. Theatre Model

    The people who will use this model would be me (the manager) and any other employee who I ask to enter some data or check a figure. This means that even though some of my employees will have knowledge of computers some won't have a lot of experience in using computers so it must be easy to use.

  2. System design

    Questionnaire 1. What do you feel you would like from the database? Keep my marking more organised and record information quicker and clearly. To gain more out of the information that I obtain from the marking. 2. What inputs do you require to be put on the database?

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