• 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. Financial Model to help organise the year eleven prom

    These are shown below I then needed to think of what I wanted as my validation rules for "Raw data" so for each column I made a rule. This was easy to achieve and is all seen below. Other Validation rules that I used were mainly for the names of the halls, catering, decorations etc.

  2. Database Design Guideline

    document: Field: Doctor ID Forename Surname Patient ID Forename Surname Tables: doctors doctors doctors patient patient patient Sort: Show: ? ? ? ? ? ? Criteria: "SN6789WC" Or: o Query 7 Table Used Patient Query Criteria All the patients in a green ward with Alzheimer illness.

  1. Database design.

    Rent (Customer_ID, Video_ID, date_out, date_returned) Video (Video_ID, Video_name, Video_category, Video_cert, Video_rental_price, video_copies) Task 4 User Documentation Step one In order to load up the spreadsheet you have to click on the Microsoft access icon on the desktop when this has been done then you will have the following appear; You enter blank database by clicking on the and then clicking on the OK button.

  2. System design

    4. How would you sum up your IT skills? Fairly Poor 5. In your view what do you feel are wrong with how you keep the data at the moment? Difficult to keep up with the current scheme, not organised. Time consuming. 6. Do you need any data protection against certain people seeing what is on the database?

  1. Database design for a farmers herd book.

    I also have to define the not only the relationships between tables but also the relationship between products and suppliers and patients will be defined. All of these table can then be linked together to form the relational database. How a database will aid this system The system that is

  2. Theatre Model

    All these advantages also contribute to saving time. So before lots of time was being wasted (time is money) which could have been used to help the theatre in other aspects and therefore produce more money by having more time.

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