Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
16 Cards in this Set
- Front
- Back
|
Database |
Collection of information that is organised and can be easily accessed managed n updated |
|
|
Relational database |
All data is stored in tables |
|
|
Query |
Selecting or manipulating data in one or more tables Types: select , update , delete , insert |
|
|
Table |
Collection of data organised in rows and columns .. |
|
|
Entity |
Person place or thing about which data can be collected |
|
|
Fields/ columns /attribute |
Stores a specific type of information .. Each column holds one attribute of each record |
|
|
Row /records /tuples |
Records can be inserted deleted updated or selected ...
Collection of all the attributes (field values) of a single entity , record or tuple |
|
|
Select query |
Tells DMBS to pick out and return some or all firlds from a table where a criterion is met |
|
|
Update query |
Tells dbms to change a table by getting some or all fields of records where criterion is met |
|
|
Delete query |
Tells DMBS to get rid of all records from a table where criterion is met |
|
|
Insert query |
Tells DMBS to add one or more records to a table |
|
|
Primary key |
Unique jet because it’s unique and can uniquely identify each row in a table |
|
|
Candidate key |
Any key that may be used as the primary key |
|
|
Composite key |
Made up of more than one column |
|
|
Foreign key |
Field in a table that refers to primary key in another table |
|
|
Indexing |
Technique for improving database performance |
