Computer Science ch. 5 Section 4: Database basics

popular DBMS'

MySQL, Oracle Database, and Microsoft Access

database

a collection of data organized to enable efficient information retrieval

Data

a collection of facts and values

MySQL

a freely available database system that uses SQL. -popular database for web apps.

record (row)

a group of related fields

Primary key

a record's unique identifier

Query

a search in a database for data

Common database operations

adding new data, editing existing data, deleting data, querign the database for information

database management system (DBMS)

an app that creates, maintains, and accesses database systems

field (column)

basic unit of data stored

table

collection of related data

names and numbers are an example of ______

data -information provides meaning to data

Validation

ensures data is correctly entered as the data is added to the database

SQL (Structured Query Language)

popular language to run operations on databases. -became a standardized language in 1986. -used in only some DBMS's (such as Oracle Database and Microsoft Access).

information

processed data and gives meaning to the facts and values

A_____ searches the database for entires matching user defined criteria

query -a query is a search in the database. users can search for entries matching keywords, IDs, or other criteria

Integrity

refers to the accuracy of the data in the database

a _____ is an app that interacts with a database

DBMS -a DBMS provides an interface to create, maintain, and access the database. the DBMS can provide different interfaces to employees, customers, or other apps.

names are an example of _______

Data - data is a collection of facts and values, which can be in stored in various formulas such as names, characters, and numbers

object-oriented database

stores data as a collection of objects rather than tables

multidimensional database

stores data in more than two dimensions

relation database

stores information in tables composed of rows and columns -contains: field, record, primary key, table

data integrity refers to_______

the accuracy of data. -database must contain data that is correct and timely, otherwise the information is not useful.

a process called_______rejects the request to add the following entry to the database

validation -validation may check the type of data, acceptable ranges, or for completeness.