Term
|
Definition
| A set of interrelated, correlated files |
|
|
Term
| What are some differences between excel and access |
|
Definition
-Excel is more for number-crunching, while access works well with non-numerical data
-Relationships in access, but not excel
-Access is more expensive/time consuming |
|
|
Term
| Database management system |
|
Definition
| Specialized computer program that manages and controls data and interfaces between the data and the application programs |
|
|
Term
|
Definition
| application programs that access the database through the DBMS |
|
|
Term
|
Definition
| Process of analyzing data for new knowledge |
|
|
Term
| What are the 3 views of data |
|
Definition
1)Record layout
2)Logical
3)Physical |
|
|
Term
|
Definition
| how and where the data are physically arranged/stored in the computer system |
|
|
Term
| Record layout view of data |
|
Definition
| -shows physical location and layout of the records used in an application program |
|
|
Term
|
Definition
| logical structure of a database |
|
|
Term
| What are the 3 levels of schema |
|
Definition
1) Conceptual: organization-wide view of entire database
2) External: set of user views of parts of the database
3) Internal:provides low level view of database |
|
|
Term
|
Definition
| Contains info about the structure of the database (usually maintained by DBMS) |
|
|
Term
| What are 3 different types of database languages |
|
Definition
1) Data definition language (DDL)
2) Data query language (DQL)
3) Data manipulation language (DML) |
|
|
Term
| Data definition language (DDL) |
|
Definition
| -used to build the data dictionary, create the database, specify security limitations/constraints on data |
|
|
Term
| Data manipulation language (DML) |
|
Definition
| Database language used for data maintenance (ie. updating, deleting, inserting database parts) |
|
|
Term
| Database query language (DQL) |
|
Definition
Database language used to interrogate the database
-retrieves, sorts, orders, and presents subsets of the database to the user |
|
|
Term
| What are some benefits of a database |
|
Definition
-data integration: combining master files into larger pools of data that many programs can access
-data sharing among users
-minimal data redundancy
-central management of data |
|
|
Term
| What are some problems with storing all of your data into 1 table |
|
Definition
-Data redundancy
-Insertion anomaly
-Delete anomaly
-Update anomaly |
|
|
Term
|
Definition
| when you have multiple lines in a table |
|
|
Term
|
Definition
-goal is to minimize null values in a table
-ie. you want to be able to store info about a customer before they make a purchase |
|
|
Term
|
Definition
| unintended results occur when you delete a row in a table |
|
|
Term
| What are the 4 basic requirements (rules) of a relational database |
|
Definition
1) Primary key cannot be null (entity integrity rule)
2) Foreign key must either be null or refer to primary key of another table
3) Every item in a row must be single-valued (one 1 value for each cell)
4) All non-key attributes in a table should describe a characteristic of the primary key |
|
|
Term
|
Definition
| -designing a database so that it is free of delete, update, and insert anomalies (3NF) |
|
|
Term
| What are the 2 ways of designing a database |
|
Definition
1) Normalization
2) Semantic data modeling |
|
|
