Please enable JavaScript.
Coggle requires JavaScript to display documents.
Databases (Terms (Table: the object that contains the data, Record:…
Databases
Terms
-
-
-
Primary key: a field which uniquely identifies a record from another. Can be used to sort and quickly retrieve information from a database.
DBMS (Database Management System): application system that is used to create, maintain and provide controlled access to user databases.
Databases: a database is a collection of related data about a particular subject stored in a structured format.
Closed
Already contain data and just allow the user to obtain information from them (telephone directories)
-
Advantages
-
-
-
-
Format, arrange and present information in the way that the user wants.
-
Characteristic of a DBMS
Tables
Field type
-
Memo (<64,000 characters)
-
-
-
-
-
-
-
-
-
-
Indexing: used to make searching and sorting in a database faster and efficient; minimizes duplication of data
-
-
Querying vs Sorting: querying = searching for a particular subset/file; sorting = organising your database in a specific order/by a specific field