Fundamentals of Database System

ITE6100B - Fundamentals of Database System

Note: Updated on 11/04/21

A single entity instance of one entity class is related to a single entity instance of another entity class.	One-to-One
The participation of an entity in the relationship is mandatory.	Mandatory
A single entity instance of one entity class is related to a multiple entity instance of another entity class	One-to-Many
Each entity instance of one entity class is related to a multiple entity instance of another entity class; and vice versa.	Many-to-Many
Relational Model is a table with columns and rows.	True
The relational model (RM) was first described by Edgar F. Codd	True
Its is one or more columns of a relation or table that is used to identify a record.	Key
Entities can be related indirectly by two (2) relationships.	Transitive Relationship
This relationship exists if they are independent or different to each other.	Multiple Relationship
It is the number of attributes in a relation.	Degree of Relation
Relationships can't have attributes.	False
Maximum Cardinality describes the maximum number of entity instances in the relationship.	True
Minimum Cardinality describes the minimum number of entity instances that must participate in a relationship	True
It is the number of tuples in a relation.	Cardinality of relation
All possible column values	Domain
Table definition	Schema of relation
Row	Tuples
Table	Relation
Column header / field A	Attributes
No primary key can be null.	True
Null means zero	False
Matching Type Common Data Types
Boolean	true/false
Date	Time
Character	Text
Numeric	Integer
The table is in a 1NF if It satisfies the definition of a relation.	True
Indirect relationship causes functional dependency.	transitive dependency
The table is in a 2NF if there's NO Partial Dependency.	True
NO “repeating groups” (columns)	1st Normal Form (1NF)
It is a stricter form of 2 nd and 3 rd normal form	Boyce Codd Normal Form (BC/NF)
Multi-value dependency	4th Normal Form (4NF)
NO Partial Dependency	2nd Normal Form (2NF)
NO Transitive Dependency	3rd Normal Form (3NF)
Matching Type Relational database schema commonly defines:
Tables	name, primary key
Columns	name, data type, size, value range
Constraints	all kinds of keys
A process of producing a set of tables (relations) with a proper attribute.	Normalization
Null means a value is unknown.	True
Facts that can be recorded and that have implicit meaning.	data
A computerized system that permits users to create and maintain a database.	database management system
Database System automatically takes care of backup and recovery.	True
Internal Level describes the physical storage structure of the database.	True
Controlling Redundancy is used to improve the performance of queries.	True
Data Manipulation Language is use for manipulating data in a database.	True
Describes how entities are related.	relationships
People whose jobs require access to the database for querying, updating, and generating reports	end users
We call the database and DBMS software together as a	database system
Who is responsible in administering the primary and secondary resource in the database?	database administrator
It is a question or an inquiry, sometimes loosely used for all types of interactions with databases	query
Attribute is a name for a set of similar things that you can list. Like objects, events, people.	False
Data abstraction is the data type, relationships and constraints that apply to the data.	False
It is between high-level and low-level data models.	implementation data models
Physical data models is a concept that shows how the data is stored on the computer.	True
Data model is a collection of concepts that is used to describe the structure of a database.	True
There’s no difference between the description of database and the database itself.	False
It is a collection of related data.	database
A displayed schema is called Schema figure.	False
They are liable for identifying the data to be stored within the database and for selecting appropriate structures to represent and store this data	database designers
The participation of an entity in the relationship is optional.	Optional