Scribd
Upload
21 views2 pages

Activity 2 B

The document provides a structured table for various database fields, specifying the appropriate data types for each field in different tables related to a client management system. It includes tables for categories, clients, treatments, appointments, and appointment details, with examples of data types such as Auto Number, Short Text, Number, and Currency. Additionally, it poses a question regarding the rationale for not using a number data type for telephone numbers.

Uploaded by

oneinamillionnamedluna
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
21 views2 pages

Activity 2 B

The document provides a structured table for various database fields, specifying the appropriate data types for each field in different tables related to a client management system. It includes tables for categories, clients, treatments, appointments, and appointment details, with examples of data types such as Auto Number, Short Text, Number, and Currency. Additionally, it poses a question regarding the rationale for not using a number data type for telephone numbers.

Uploaded by

oneinamillionnamedluna
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

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