DAD 220 Module Two
exam questions and
answers
Database Model
Conceptual framework for database systems with three parts: Data
structures, Operations, and Rules.
Data Structures
Prescribe how data is organized
Operations
Manipulate data structures.
Rules
Govern valid data.
Relational Model
A database model based on a tabular data structure. The data
structure, operations, and rules are standardized in SQL, the
universal query language of relational databases.
Tuple
An ordered collection of elements enclosed in parentheses.
Table
Has a name, a fixed tuple of columns, and a varying set of rows.
Column
has a name and a data type
Row
An unnamed tuple of values. Each value corresponds to a column
and belongs to the column's data type.
exam questions and
answers
Database Model
Conceptual framework for database systems with three parts: Data
structures, Operations, and Rules.
Data Structures
Prescribe how data is organized
Operations
Manipulate data structures.
Rules
Govern valid data.
Relational Model
A database model based on a tabular data structure. The data
structure, operations, and rules are standardized in SQL, the
universal query language of relational databases.
Tuple
An ordered collection of elements enclosed in parentheses.
Table
Has a name, a fixed tuple of columns, and a varying set of rows.
Column
has a name and a data type
Row
An unnamed tuple of values. Each value corresponds to a column
and belongs to the column's data type.
