relational database model
SETS
Candidate Key
Closure
Composite Entity
Composite Key
A minimal superkey; that is, a key that does not contain a sub…
A property of relational operators that permits the use of rel…
An entity designed to transform an M:N relationship into two 1…
A multiple-attribute key.
Candidate Key
A minimal superkey; that is, a key that does not contain a sub…
Closure
A property of relational operators that permits the use of rel…
Relational Database
Database Tables
Record
Field
A database consisting of more than two related tables. The rel…
Database tables stores in rows and records in an organised. It…
A row is made up of fields and contain full details of particu…
A column in a table, also known as attribute
Relational Database
A database consisting of more than two related tables. The rel…
Database Tables
Database tables stores in rows and records in an organised. It…
Domain
primary key (PK)
Primary Key
Logical data
In data modeling, the construct used to organize and describe…
In the relational model, an identifier composed of one or more…
Each table must have a
can only have true or false (yes or no) values.
Domain
In data modeling, the construct used to organize and describe…
primary key (PK)
In the relational model, an identifier composed of one or more…
21. _____ logic, used extensively in ma…
22. Each table _____ represents an attr…
23. Date attributes contain calendar da…
24. In the relational model, _____ are…
a. Predicate
a. column
c. Julian
b. keys
21. _____ logic, used extensively in ma…
a. Predicate
22. Each table _____ represents an attr…
a. column
Logical view
Relational model
Table
Table
Emphasize designer to focus on the logical representation of t…
Enables to view data logically rather than physically
Plays such a prominent role in designing relational model
Perceived as a two-dimensional structure composed of rows and…
Logical view
Emphasize designer to focus on the logical representation of t…
Relational model
Enables to view data logically rather than physically
What is a relation?
What is an attribute ?
What is a domain?
What is a tuple ?
- a table ith columns and rows
-named column of a relation
- the set of allowable values for one or more attributes
- a row of a relation
What is a relation?
- a table ith columns and rows
What is an attribute ?
-named column of a relation
The practical significance of taking th…
You can think of a table as a persisten…
The order of the rows and columns is im…
Character data type also known as strin…
True
True
False
True
The practical significance of taking th…
True
You can think of a table as a persisten…
True
The practical significance of taking th…
You can think of a table as a persisten…
The order of the rows and columns is im…
Character data type also known as strin…
True
True
False
True
The practical significance of taking th…
True
You can think of a table as a persisten…
True
tuple
attribute
relation
domain
Another name for a row or record
Another name for a column or field
Another name for table
In data modeling, the construct used to organize and describe…
tuple
Another name for a row or record
attribute
Another name for a column or field
The entity supertype contains common ch…
Entity supertypes and subtypes are orga…
The relationships depicted within the s…
Within a specialization hierarchy, a su…
True
True
True
False
The entity supertype contains common ch…
True
Entity supertypes and subtypes are orga…
True
Keys
Primary key
Functional dependence
Determinant attribute
used to establish and identify relationships between tables an…
a special relational database table column designated to uniqu…
value of one or more attributes determines the value of one or…
an attribute whose value DETERMINES another
Keys
used to establish and identify relationships between tables an…
Primary key
a special relational database table column designated to uniqu…
Relational database
SQL
SQL
Types of RDMS
The collection of data items with predefined relationships bet…
Structured Query Language is the primary interface used to com…
the standard language for Relational Database Management Syste…
PostgreSQL, SQL Server Database, Oracle Database, MySQL Databa…
Relational database
The collection of data items with predefined relationships bet…
SQL
Structured Query Language is the primary interface used to com…
Provides a framework in which an assert…
A mathematical science that deals with…
Which model has three well-defined comp…
What are the three well-defined compone…
Predicate logic
Set theory
Relational model
1. A logic data structure represented by relations (Sec. 3.1,…
Provides a framework in which an assert…
Predicate logic
A mathematical science that deals with…
Set theory
When a table field contains a null valu…
A conceptual, high-level description of…
Amanda is designing a relation. As she…
When like-named columns appear in multi…
unknown
an entity-relationship (ER) model.
Amanda should redesign the relation so that each attribute wil…
The name of the table, followed by a period as a separator
When a table field contains a null valu…
unknown
A conceptual, high-level description of…
an entity-relationship (ER) model.
database
how is data stored in relational databa…
types of databases
relational database
any collection of data that is structured to facilitate the st…
data stored in table structure where each column/row can be ac…
flat-file, relational database, and NoSQL database
store business operations data and replace legacy systems... -all…
database
any collection of data that is structured to facilitate the st…
how is data stored in relational databa…
data stored in table structure where each column/row can be ac…
The practical significance of taking th…
You can think of a table as a persisten…
The order of the rows and columns is im…
Character data can contain any characte…
ANSWER: True
ANSWER: True
ANSWER: False
ANSWER: False
The practical significance of taking th…
ANSWER: True
You can think of a table as a persisten…
ANSWER: True
The entity relationship model (ERM) is…
The Crow's Foot notation is less implem…
An entity in the entity-relationship mo…
In the entity relationship model, a tab…
False
False
True
True
The entity relationship model (ERM) is…
False
The Crow's Foot notation is less implem…
False
Instance
Schema
Table
Tuple
A data table with rows and columns.
The organization and structure of a database.
An arrangement of data made up of horizontal rows and vertical…
A row in a table that contains data about a specific item in a…
Instance
A data table with rows and columns.
Schema
The organization and structure of a database.
database
database management system (DBMS)
database system
database administrator (DBA)
comprised of numerous entities about which the company wants t…
program that manages and controls the data and the interfaces…
database, DBMS, and the application programs that access the d…
person responsible for coordinating, controlling, and managing…
database
comprised of numerous entities about which the company wants t…
database management system (DBMS)
program that manages and controls the data and the interfaces…
Tuple
Domain
Primary Key (PK)
Key
In the relational model, a table row
In data modeling, the construct used to organize and describe…
In the relational model, an identifier composed of one or more…
One or more attributes that determine other attributes
Tuple
In the relational model, a table row
Domain
In data modeling, the construct used to organize and describe…
associative entity
attribute domain
bridge entity
candidate key
...
...
...
...
associative entity
...
attribute domain
...
Which of the following is true of virtu…
In a data model, what does integrity in…
For which of the following activities w…
A language that allows a user to tell t…
Virtual tables are used in views.
Details about how the data will be kept accurate
To create databases and tables
A nonprocedural data manipulation language
Which of the following is true of virtu…
Virtual tables are used in views.
In a data model, what does integrity in…
Details about how the data will be kept accurate
1. The practical significance of taking…
2. You can think of a table as a persis…
3. The order of the rows and columns is…
4. Character data can contain any chara…
True... POINTS: 1... DIFFICULTY: Difficulty: Moderate... REFERENCES: p.…
True... POINTS: 1... DIFFICULTY: Difficulty: Easy... REFERENCES: p.74... L…
False... POINTS: 1... DIFFICULTY: Difficulty: Easy... REFERENCES: p.74…
False... POINTS: 1... DIFFICULTY: Difficulty: Easy... REFERENCES: p.75…
1. The practical significance of taking…
True... POINTS: 1... DIFFICULTY: Difficulty: Moderate... REFERENCES: p.…
2. You can think of a table as a persis…
True... POINTS: 1... DIFFICULTY: Difficulty: Easy... REFERENCES: p.74... L…
Data
Information
Knowledge
Issues with Managing Data
Raw Data - Some Structured Representation (Encoding)
- Data + Context: the Meaning ... - Processed Meaningfully
The True Belief
- Quantity: lots of data?... - Many Users: concurrent access...... -…
Data
Raw Data - Some Structured Representation (Encoding)
Information
- Data + Context: the Meaning ... - Processed Meaningfully
relational model
predicate logic
set theory
tuple
based on predicate logic and set theory
- used in math... - provides framework for assertions (statements…
- mathematical science deals with sets... - basis for data manipu…
- table row... - a single entity occurrence w/in entity set
relational model
based on predicate logic and set theory
predicate logic
- used in math... - provides framework for assertions (statements…