Normalization
What is normalization?
The process of reducing data redundancy
What is a Join?
What is cardinality?
The numerical relationship between one entity and another.
What do data files do?
Contain all the data of the database
What is First Normal Form(1NF)?
All attributes must be single valued.
What is an equijoin?
What is optionality?
A measure of whether a relationship or attribute is Mandatory or not.
How are Flat file databases organized?
Rows and columns !!
Where do columns only exist?
tables
What is Second Normal Form(2NF)?
All attributes must be dependent on the full UID.
What is an inner join?
Keyword that selects matching records from both tables.
What is the optionality if the relationship line is dashed?
What is a Database management system?
A software program used to administer the database, controls the contents of the database files.
What is a segment?
A set of extents allocated for a user object (a table/index)
What is Third Normal Form(3NF)?
Attributes must not be dependent on any Non-UID attributes.
What is a Left outer join?
Join that selects all the records from the left table, and all the matching records from the right table
What is the Cardinality if the relationship line has a crow's foot?
One or more
When did grid computing become practical?
Early 2000's
What do control files contain?
Information specifying the physical structure of a database.
What is Fifth Normal Form(5NF)?
Tables must be simplified as much as possible in order to reduce data redundancy.
What is a Full Outer Join?
Keyword that returns all matching records from both tables
What symbol represents a Non-transferable relationship?
Diamond
What is the database design lifecycle?
Requirements analysis, Logical design, Physical Design, Implementation, Monitoring, modification & maintenance.
What are Extents?
A specific number of logically contiguous data blocks, used to store a specific type of information.