Data+Types+definition

Introduction
Each attribute in a database can store specific data type. Common data types are outlined below:)

Text
A text data type can store characters of text (e.g. letters, numbers, symbols).

Integer
An integer data type can store whole numbers (e.g. 0, 1, 409, -257)

Real Numbers
A real number data type can store a decimal number (e.g. 10.2, 345.569, -101.2254)

Object
An object data type can store an object linked to the database (e.g. image, video, audio, word processed document)

Link
A link data type stores a hyperlink to a URL (e.g. www.bbc.co.uk)

Boolean
A boolean data type has only 2 states (e.g. yes/no, true/false, male/female)

Date
A date data type can store a specific date

Time
A time data type can store a specific time

Higher Extension
Higher candidates should read Higher Info System (Love, Charlie) pages 28-37. Higher candidates should understand what is meant by:


 * Domain constraints
 * Specific constraints (for each data type)
 * Linked and embedded data objects, and advantages and disadvantages of each

Scholar Link: [|Attributes and data types example]