Scribd Logo
Upload

Welcome to Scribd!

  • 4 views

    Activity 2 B

    Uploaded by

    oneinamillionnamedluna

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Activity 2 B

    Uploaded by

    oneinamillionnamedluna
    4 views2 pages

    Original Title

    Activity2b

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    4 views2 pages

    Activity 2 B

    Uploaded by

    oneinamillionnamedluna

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 2

    Unit 4

    Activity 2b

    Category table Treatment table

    Client table

    Appointment table Appointment details table


    Unit 4
    Activity 2b

    1 Complete the table by adding the relevant data type for each field.

    The data type for MobileTelephone has been added for you.

    Table name Field name Data type


    (a) Category table CateogryID Auto number
    Cateogry Short text

    (b) Client table ClientID Auto Number


    Firstname Short Text
    Lastname Short Text
    Street Short Text
    Postcode Short Text
    MobileTelephon Short text
    e

    (c) Treatment table TreatmentID Auto Number


    CategoryID Number
    Treatment Text
    DurationMins Number
    Price Currency

    (d) Appointment table AppointmentID Auto Number


    ClientID Number
    Date Date & Time
    StartTime Number
    EndTime Number

    (e) Appointment details table AppointmentID Auto Number


    TreatmentID Number

    2 Explain why telephone numbers should not use a number data type.

    You might also like