Long Exam #2 Flashcards
it is the range of acceptable values than an attribute is capable of having.
Domain of Attributes
Those database system which executes on the same operating system and use the same application process and carry the same hardware devices.
Homogeneous Distributed Database system
It is used in high-end systems where performance is crucial.
In Memory Database System
A database system that accommodates multiple users although the database management system and the database itself are entirely housed on a single machine.
Centralized Database System
If we perform any operation over the data, its value before and after the operation should be preserved. This is called _________.
Consistency
It is also called relational data model.
Record-Based Data Model
It is the attribute which is unique for every entity instance.
Key attribute
It is also referred to as passive DBMS
Program-Driven System
An entity which doesn’t have any key attribute of its own.
Weak Entity
DBMS products can be sold in the form of ________.
Licenses
An attribute which can be calculated or derived based on other attributes.
Derived Attribute
A database model wherein each entity has only one parent but can have several children.
Hierarchical Databases
It supports a large number of transactions concurrently without any delay.
Online Transaction Processing
An attribute that can take more than one value for each entity instance.
Multi-Valued Attribute
A relationship which one entity can be related to more than one other entity.
One to Many Entity Relationship
A person, object or event of importance to the organization.
Entity
A type of database where data is stored in a virtual organization.
Cloud Databases
Typically become fields in the entity’s database table.
Attributes
A type of data repository system wherein DBA is allowed to describe and manage all data.
Stand Alone
A database system that supports only one user at a time and are mostly used with personal computers.
Single User Database System
It is also referred to as event driven systems
Active DBMS
A database system that can have the actual database and DBMS distributed over many sites.
Distributed Database System
It defines the physical and logical structure of a database.
Data Model
In this system, the size of the database is large which increases the response time for fetching the data.
Centralized Database System
In a hierarchical database model, it is the entity at the top of the hierarchy.
Parent
It is also called data repository system.
Data Dictionary
It is used to markup data so it can be processed by computers
Extensible Markup Language
A combination of object oriented data model and semistructured data model
Hybrid Database Model
In this model, all entities are regarded as objects
Object oriented database model
A database system that supports multi users concurrently.
Multi User Database Model
When multiple transactions occur at the same time, one transaction effects should not be visible to the other transactions in the database. this is called ______.
Isolation
It is the collection of attribute values.
Tuples
Those database system which executes on different operating systems under different application process and carries different hardware devices.
Heterogeneous Distributed Database System
A database model in which some entities can be accessed through several paths.
Network Database
This ensures the data operation will complete either with success or with failure.
Atomicity
