Note
Additional Commands
Create Table Creates a table within a database. Reference You can include a primary key reference by doing: Example
computer-sciencedatabasessql
Tag view
databases
8 related notes
Note
Commands
info This only contains required commands by OCR. Useful commands beyond the OCR specification can be found in Additional Commands. Select Fetches data from a given set. Order By S...
computer-sciencedatabasessql
Note
CRUD (Create, Read, Update, Delete)
CRUD is the acronym for: C reate R ead U pdate D elete All relational databases support these operations and can be directly mapped to SQL statements. | Word | Commands | Wikilinks...
computer-sciencedatabases
Note
Data Integrity
Data integrity: the process of maintaining the consistency of the database. Being able to guarantee data integrity is vital to the database. Tutor Definition: Data integrity is the...
computer-sciencedatabases
Note
Keys
A primary key is a key that is uniquely identifiable to each row within a database. It cannot be null and may be composed of multiple foreign keys. A foreign key is a key that refe...
computer-sciencedatabases
Note
Normalisation (Normal Factor)
WARNING This document has AI generated images. Normalisation is a process used to produce the most optimal design for a database. It requires that tables should be organised as so...
computer-sciencedatabases
Note
Transaction Processing
Transaction processing is any form of information processing, divided into individual and indivisible operations labelled transactions. Each transaction must either succeed or fail...
computer-sciencedatabases
Note
Wildcards
| Sign | Summary | Description | Notes | | | | | | | | All | Represents all. | | | % | Any | Represents zero or more characters. | Analogous with asterisk. | | | One | Represents a...
computer-sciencedatabasessql