Showing posts with the label DatabasesShow all

What is the advantages and disadvantages associated with the use of triggers and procedures.

Advantages • Centralization, standardization and reuse of application logic. The advan…

Definition of the trigger.

A trigger is a unit of logic embedded in a database. Event driven and triggered …

What types of integrity may be displayed in an object-oriented data model.

Class-class integrity – A super class should not be deleted until all associated s…

What is the terms of Object and Abstraction Mechanisms.

An Object Oriented (OO) database is made up of objects and object classes linked via …

Compare the relational data model to the network data model.

Relational data model:   There is one data structure, the relation, which is define…

Entity relationship diagram example scenario for bus company.

Entity relationship diagram example scenario for bus company.

Please read the following scenario; A country bus company owns a number of buses. Each…

Define entity integrity in terms of a relational database.

Every table must have a primary key. The primary key must be unique and not null…