INF2603 – Semester 1 – 2014 – Glossary of terms used in exam papers from 2012 to 2013
Attribute
A characteristic of an entity or object.
Column Constraint
In this type the constraint is checked when the value of the column changed.
Composite key
A multiple-attribute key.
Database
A shared, integrated computer structure that houses a collection of related data.
Data Definition Language (DDL)
The language that allows a database administrator to define the database structure,
schema, and
subschema.
Data dictionary
A DBMS component that stores metadata—data about data.
Data Manipulation Language (DML)
m
er as
The set of commands that allows an end user to manipulate the data in the database. The
co
commands include SELECT, INSERT, UPDATE, DELETE, COMMIT, and ROLLBACK.
eH w
Derived attribute
o.
An attribute that does not physically exist within the entity and is derived via an algorithm.
rs e
ou urc
Entity subtype
In a generalization/specialization hierarchy, a subset of an entity supertype.
o
Entity supertype
aC s
In a generalization/specialization hierarchy, a generic entity type that contains the common
v i y re
characteristics of entity subtypes.
Existence-dependent
A property of an entity whose existence depends on one or more other entities.
ed d
Existence-independent
ar stu
A property of an entity that can exist apart from one or more related entities.
External model
sh is
The application programmer's view of the data environment.
Th
Fan trap
A design trap that occurs when one entity is in two 1:M relationships with other entities,
thus
producing an association among the other entities that is not expressed in the model.
First Normal Form (1NF)
The first stage in the normalization process. It describes a relation depicted in tabular
format, with no repeating groups and a primary key identified. All nonkey attributes in the
relation are dependent on the primary key.
Functional dependence
Within a relation R, an attribute B is functionally dependent on an attribute A if and only if a
given
value of attribute A determines exactly one value of attribute B. The relationship “B is
dependent
This study source was downloaded by 100000828872084 from CourseHero.com on 09-02-2021 11:47:36 GMT -05:00
Page 1 of 4
https://www.coursehero.com/file/9840337/INF2603-Terms-Summary-from-Past-Exam-Papers/
Attribute
A characteristic of an entity or object.
Column Constraint
In this type the constraint is checked when the value of the column changed.
Composite key
A multiple-attribute key.
Database
A shared, integrated computer structure that houses a collection of related data.
Data Definition Language (DDL)
The language that allows a database administrator to define the database structure,
schema, and
subschema.
Data dictionary
A DBMS component that stores metadata—data about data.
Data Manipulation Language (DML)
m
er as
The set of commands that allows an end user to manipulate the data in the database. The
co
commands include SELECT, INSERT, UPDATE, DELETE, COMMIT, and ROLLBACK.
eH w
Derived attribute
o.
An attribute that does not physically exist within the entity and is derived via an algorithm.
rs e
ou urc
Entity subtype
In a generalization/specialization hierarchy, a subset of an entity supertype.
o
Entity supertype
aC s
In a generalization/specialization hierarchy, a generic entity type that contains the common
v i y re
characteristics of entity subtypes.
Existence-dependent
A property of an entity whose existence depends on one or more other entities.
ed d
Existence-independent
ar stu
A property of an entity that can exist apart from one or more related entities.
External model
sh is
The application programmer's view of the data environment.
Th
Fan trap
A design trap that occurs when one entity is in two 1:M relationships with other entities,
thus
producing an association among the other entities that is not expressed in the model.
First Normal Form (1NF)
The first stage in the normalization process. It describes a relation depicted in tabular
format, with no repeating groups and a primary key identified. All nonkey attributes in the
relation are dependent on the primary key.
Functional dependence
Within a relation R, an attribute B is functionally dependent on an attribute A if and only if a
given
value of attribute A determines exactly one value of attribute B. The relationship “B is
dependent
This study source was downloaded by 100000828872084 from CourseHero.com on 09-02-2021 11:47:36 GMT -05:00
Page 1 of 4
https://www.coursehero.com/file/9840337/INF2603-Terms-Summary-from-Past-Exam-Papers/
