# Field Properties & Table Design

> This section is field properties and table design under Database: choosing data types, setting field size, format, default value, required, validation rules, input masks, confirming the primary key…

- Page: https://www.hlayiso.com/grade-11/computer-applications-technology/notes/database/field-properties-and-table-design

Breadcrumbs: [Home](https://www.hlayiso.com/) › [Grade 11](https://www.hlayiso.com/grade-11) › [Computer Applications Technology](https://www.hlayiso.com/grade-11/computer-applications-technology) › [Notes](https://www.hlayiso.com/grade-11/computer-applications-technology/notes) › [Database](https://www.hlayiso.com/grade-11/computer-applications-technology/notes/database) › [Field Properties & Table Design](https://www.hlayiso.com/grade-11/computer-applications-technology/notes/database/field-properties-and-table-design)

## Full notes

This is a preview of the Field Properties & Table Design notes for Grade 11 Computer Applications Technology. Create a free Hlayiso account to read the full notes, practise every question and track your progress.

## More in Database

- [Database Fundamentals](https://www.hlayiso.com/grade-11/computer-applications-technology/notes/database/database-fundamentals) — Previous section
- [Queries](https://www.hlayiso.com/grade-11/computer-applications-technology/notes/database/queries) — Next section
- [All Database sections](https://www.hlayiso.com/grade-11/computer-applications-technology/notes/database)

## Frequently asked questions

### What will I learn in "Field Properties & Table Design"?

This section covers Field Properties & Table Design as part of Database in Grade 11 Computer Applications Technology. You'll find clear explanations, worked examples, and key definitions aligned to the CAPS curriculum.

### Is this section aligned with the CAPS curriculum?

Yes. All notes on Hlayiso, including "Field Properties & Table Design", are written against the official CAPS curriculum and ATP for Grade 11 Computer Applications Technology.

### What should I study after "Field Properties & Table Design"?

Continue with the next section in Database, or test your understanding with the interactive quiz linked to this section.

---

Hlayiso: free CAPS and IEB past papers, memos, notes and study guides for South African learners. When citing, link the page URL above, not a PDF or /api/ URL.