TEST 2:

PLEASE MATCHINGWITH OPTION (F, G, H, I, J)

____ the practice of examining large databases in order to generate new information

____ The format of a data record, which includes the name, type and size of each field in the record.

____ tells the users, in their term, what is in the database. So while there can be numerous

____ the way data are physically stored and processed in a database, there can only be one physical view of a database because physical view deals with the physical storage of information on a storage device

____ a way to logically group objects such as tables, views, stored procedures etc.

F.Physical View

G.Logical View

H.Record Layout

I.Data Mining.

J.Schema

TEST 3: MATCHING WITH OPTION K, L, M, N, O

____ahigh-leveldescriptionofabusiness'sinformationalneeds.It typically includes only the main concepts and the main relationships among

them.

____ It is tailored to the needs of a particular category of users. Portions of Level Schema stored data should not be seen by some users and begins to implement a level of security and simplifies the view for these users I

____ the logical description of thatsection of the database which is. Level relevant and available to an application.

__ is a key in a relational database that is unique for each record. It is a uniqueidentifier,such asadriverlicensenumber,telephonenumber (including area code), or vehicle identification number (VIN)

____ a column (or columns) that references a column (most often the primary key) of another table. The purpose of the foreign key is to ensure

referential integrity of the data.

K.Subschema

L. External Level Schema

M. Conceptual Level Schema

N.Foreign Key

O.Primary Key

TEST 4: MATCHING WITH OPTION P,Q,R,S,T

___ a data inconsistency that results from data redundancy and a partial update

____ occurs when certain attributes cannot be inserted into the database without the presence of other attributes.- we can't add a new course unless we have at least one student enrolled on the course.

____ exists when certain attributes are lost because of the deletion of other attributes.

____structuredtorecognizerelationsamongstoreditemsof information.

____ a basic constraint of database relational model (abbreviated RM) that refers to the morphology of the primary key but after words, the same format is applied to the foreign key and, also to any of simple components of any of two.

P.Insert Anomaly

Q.Update Anomaly.

R.Entity Integrity Rule

S.Relational Database

T.Delete Anomaly

TEST 5: MATCHING WITH OPTION U,V

____Process of organizing the columns (attributes) and tables (relations) of a relational database to minimize data redundancy.

____ a software engineering model based on relationships between stored symbols and the real world. The data is organized in such a waythatitcanbeinterpretedmeaningfullywithouthuman intervention.

U.Normalization

V.Semantic Data Modeling