Data Management - Applications - D427
Study online at https://quizlet.com/_d8akgc
1. Database Model is a conceptual framework for database systems, with three parts
2. 3 Parts of the Data structures, operations, rules
Database Model
3. Data structures prescribe how data is organized
4. Operations manipulate data structures
5. Rules govern valid data
6. Big Data characterized by unprecedented data volumes and rapidly changing data struc-
tures.
7. Set is an unordered collection of elements enclosed in braces.
Ex: {a, b, c} and {c, b, a} are the same, since sets are not ordered.
8. Tuple is an ordered collection of elements enclosed in parentheses.
Ex: (a, b, c) and (c, b, a) are different, since tuples are ordered.
9. Database Termi- Table
nology Column
Row
Data Type
10. Math Terminolo- Relation
gy Attribute
Tuple
Domain
11. File Terminology File
Field
, Data Management - Applications - D427
Study online at https://quizlet.com/_d8akgc
Record
Data Type
12. Select (Relation- selects a subset of rows of a table
al)
13. Project (Relation- eliminates one or more columns of a table
al)
14. Product (Rela- lists all combinations of rows of 2 tables
tional)
15. Join (Relational) combines 2 tables by comparing related columns
16. Union (Relation- selects all rows of 2 tables
al)
17. Intersect (Rela- selects rows common to 2 tables
tional)
18. Difference (Rela- selects rows that appear in one table but not another
tional)
19. Rename (Rela- changes table name
tional)
20. Aggregate (Rela- computes functions over multiple table rows, such as sum and count
tional)
21. relational alge- Theoretical way of manipulating table contents using relational operators
bra
ex. select, project, product, join...
22. Relational Rules logical constraints that ensure data is valid
, Data Management - Applications - D427
Study online at https://quizlet.com/_d8akgc
23. Examples of Unique Primary Key - all tables have a primary key column, or group of columns,
Rules in which the values may not repeat
Unique Column Names - different columns of the same table have different
names
No Duplicate Rows - no 2 rows of the same table have identical values in all
columns
24. Business Rule based on business policy and specific to a particular database
25. Example of a all rows of the Employee table must have a valid entry in the DepartCode column
Business Rule
-or-
PassportNumber values may not repeat in different Employee rows
26. SQL Constraints relational rules that are implemented and enforced by the database system.
Business rules are discovered during database design and often implemented as
SQL Constraints
27. Structured Query is a high-level computer language for storing, manipulating and retrieving data
Language (SQL)
28. SQL Statement is a complete command composed of one or more clauses
29. Clause groups SQL keywords like SELECT, FROM, and WHERE
ex. with tables names like City, column names like Name, and conditions like
Population > 100,000
30. SQL Language's Data Definition Language (DDL)
5 Sublanguage Data Query Language (DQL)
Data Manipulation Language (DML)
Study online at https://quizlet.com/_d8akgc
1. Database Model is a conceptual framework for database systems, with three parts
2. 3 Parts of the Data structures, operations, rules
Database Model
3. Data structures prescribe how data is organized
4. Operations manipulate data structures
5. Rules govern valid data
6. Big Data characterized by unprecedented data volumes and rapidly changing data struc-
tures.
7. Set is an unordered collection of elements enclosed in braces.
Ex: {a, b, c} and {c, b, a} are the same, since sets are not ordered.
8. Tuple is an ordered collection of elements enclosed in parentheses.
Ex: (a, b, c) and (c, b, a) are different, since tuples are ordered.
9. Database Termi- Table
nology Column
Row
Data Type
10. Math Terminolo- Relation
gy Attribute
Tuple
Domain
11. File Terminology File
Field
, Data Management - Applications - D427
Study online at https://quizlet.com/_d8akgc
Record
Data Type
12. Select (Relation- selects a subset of rows of a table
al)
13. Project (Relation- eliminates one or more columns of a table
al)
14. Product (Rela- lists all combinations of rows of 2 tables
tional)
15. Join (Relational) combines 2 tables by comparing related columns
16. Union (Relation- selects all rows of 2 tables
al)
17. Intersect (Rela- selects rows common to 2 tables
tional)
18. Difference (Rela- selects rows that appear in one table but not another
tional)
19. Rename (Rela- changes table name
tional)
20. Aggregate (Rela- computes functions over multiple table rows, such as sum and count
tional)
21. relational alge- Theoretical way of manipulating table contents using relational operators
bra
ex. select, project, product, join...
22. Relational Rules logical constraints that ensure data is valid
, Data Management - Applications - D427
Study online at https://quizlet.com/_d8akgc
23. Examples of Unique Primary Key - all tables have a primary key column, or group of columns,
Rules in which the values may not repeat
Unique Column Names - different columns of the same table have different
names
No Duplicate Rows - no 2 rows of the same table have identical values in all
columns
24. Business Rule based on business policy and specific to a particular database
25. Example of a all rows of the Employee table must have a valid entry in the DepartCode column
Business Rule
-or-
PassportNumber values may not repeat in different Employee rows
26. SQL Constraints relational rules that are implemented and enforced by the database system.
Business rules are discovered during database design and often implemented as
SQL Constraints
27. Structured Query is a high-level computer language for storing, manipulating and retrieving data
Language (SQL)
28. SQL Statement is a complete command composed of one or more clauses
29. Clause groups SQL keywords like SELECT, FROM, and WHERE
ex. with tables names like City, column names like Name, and conditions like
Population > 100,000
30. SQL Language's Data Definition Language (DDL)
5 Sublanguage Data Query Language (DQL)
Data Manipulation Language (DML)
