Data Organization in Databases
2.1 Overview of Data in a Database
Refer to Fig 2.1 on P.28
2.2 Organization of Data in Database
Database - Table - Record - Field
Character
Bit
2.3 Common Data Type
- Text / Char(N)
- Memo
- Number / numeric / decimal / Currency / integer
- Date/time
- Boolean (True / False)
OLE object: common in Database used in Web. can store Multimedia information
2.4 Data Management
Data Definition Language (Create Database / Create table / alter table)
Data Manipulation Language (Select / Insert / update)
Data Control Language (For security, access control etc) - Not mentioned in Curriculum Guide
2.5 Data Dictionary (Meta-Data: Data describing Data)
Class work: P.47-48
Short questions: Q1, 5
Long questions: Q2