NEW
Font size
Worksheets6INFOMAN (Recitation)
Total questions: 20
Worksheet time: 10mins
It is the process of organizing data to minimize redundancy in the design of a relational database management system (RDBMS).
Database Normalization
Database Subquery
Relational Database Model
DBMS Keys
it states that the domain of an attribute must include only atomic values and that the value of any attribute in a tuple must be a single value from the domain of that attribute.
Boyce - Codd Normal Form
1NF
2NF
3NF
it is a specific type of field in a relational database that can identify each unique record independently of any other data
Composite Key
Surrogate Key
Candidate Key
Superkey
it expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.
Determination
Relationship
Dependency
Cardinality
All superkeys are candidate keys.
True
False
Maybe
No Answer
it means that the value of one or more attributes determines the value of one or more other attributes
Relational Database
Composite Key
Functional Dependence
Tuple
is a key that is composed of more than one attribute.
Compound Key
Composite Key
Superkey
Surrogate Key
it provides a detailed description of all tables in the database created by the user and designer.
Data Dictionary
Logical Data Model
Relational Data Model
Attribute
The real test of redundancy is not how many copies of a given attribute are stored, but whether the elimination of an attribute will eliminate information.
True
False
Maybe
No Answer
it sometimes called an inner query or nested query is a query within another SQL query.
SQL View
Inner Join
SQL Subquery
Join Clause
it consists of one or more attributes that determine other attributes.
Entity
Data Model
Attribute
DBMS Keys
is an attribute whose value is calculated from other attributes.
Derived Attribute
Required Attribute
Optional Attribute
Calculated Attribute
is the state in which knowing the value of one attribute makes it possible to determine the value of another.
Dependency
Relationship
Cardinality
Determination
it refers to the way data are physically stored and processed in a database
Entity Integrity
Physical View
Logical View
Referential Integrity
TRUE or FALSE: The following image is the right syntax for SQL Inner Join.
TRUE
FALSE
Maybe
No Answer
He is considered to be the Father of Relational Databases
Edgar Codd
Edgar Boyce
Ray Boyce
Ray Codd
TRUE or FALSE: The following image will copy or duplicate a table in a database.
TRUE
FALSE
Maybe
No Answer
is a thing, person, place, unit, object or any item about which the data should be captured and stored in the form of properties, workflow and tables. Usually it is the database table.
Process
Relationship
Attribute
Entity
is the condition in which each row (entity instance) in the table has its own unique identity.
Referential Integrity
Dependency
Entity Integrity
Determinant
To avoid nulls, some designers use special codes, known as ______.
Required
Flags
Keys
Normalization
