Note
Flat-File Database
A flat file database is a database in which everything is held within the same one table, i.e., names, addresses, classes, etc. It is only ever in 1NF and is poor to scale. NOTE Im...
computer-sciencedatabasestypes
Tag view
databases
10 related notes
Note
Entity Relational Diagrams
No preview text yet.
computer-sciencedatabases
Note
Additional Commands
Create Table Creates a table within a database. Primary Key Reference You can include a primary key reference by doing: Example
computer-sciencedatabasessql
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