Shared Flashcard Set

Details

Concepts of Database Management, 7th Edition
Chapter 01 - Introduction to Database Management - Key Terms
20
Software
Not Applicable
07/08/2014

Additional Software Flashcards

 


 

Cards

Term

 

 

 

A characteristic or property of an entity; also called a field or column.

 

Definition

1)                Attribute –

Term

 

 

 

A characteristic or property of an entity; also called an attribute or a field.

 

Definition

2)                Column –

Term

 

 

 

A file used to store data about a single entity. It’s the computer counterpart to an ordinary paper file you might keep in a file cabinet, an accounting ledger, and so on. Such a file can be thought of as a table.

 

Definition

3)                data file –

Term

 

 

 

The property that lets you change the structure of a database without requiring you to change the programs that access the database; examples of these programs are the forms you use to interact with the database and the reports that provide information from the database.

 

Definition

4)                data independence –

Term

 

 

 

A structure that can store information about multiple types of entities, the attributes of these entities, and the relationships among the entities.

 

Definition

5)                Database –

Term

 

 

 

The individual or group that is responsible for a database.

 

Definition

6)                database administration (DBA) –

Term

 

 

 

Database administrator (DBA) The individual who is responsible for a database, or the head of database administration.

 

Definition

7)                database administrator –

Term

 

 

 

The process of determining the content and structure of data in a database in order to support some activity on behalf of a user or group of users.

 

Definition

8)                database design –

Term

 

 

 

A program, or a collection of programs, through which users interact with a database. DBMSs let you create forms and reports quickly and easily, as well as obtain answers to questions about the data stored in a database.

 

Definition

9)                database management system (DBMS) –

Term

 

 

 

A person, place, object, event, or idea for which you want to store and process data.

 

Definition

10)                Entity –

Term

 

 

 

A graphic model for database design in which entities are represented as rectangles and relationships are represented as either arrows or diamonds connected to the entities they relate.

 

Definition

11)                entity-relationship (E-R) diagram –

Term

 

 

 

A characteristic or property of an entity; also called an attribute or a column.

 

Definition

12)                Field –

Term

 

 

 

A screen object you use to maintain, view, and print data from a database.

 

Definition

13)                Form –

Term

 

 

 

A database has integrity if the data in it satisfies all established integrity constraints.

 

Definition

14)                Integrity –

Term

 

 

 

A rule that must be followed by data in a database.

 

Definition

15)                integrity constraint –

Term

 

 

 

A relationship between two entities in which each occurrence of the first entity is related to many occurrences of the second entity, and each occurrence of the second entity is related to at most one occurrence of the first entity.

 

Definition

16)                one-to-many relationship –

Term

 

 

 

Duplication of data, or the storing of the same data in more than one place.

 

Definition

17)                Redundancy –

Term

 

 

 

An association between entities.

 

Definition

18)                Relationship –

Term

 

 

 

The prevention of unauthorized access to a database.

 

Definition

19)                Security –

Term

For more study material on this topic

click here and go to

my Database Study Help page

http://www.share-connect.com

Thanks, mikeypzy

Definition

For more study material on this topic

click here and go to

my Database Study Help page

http://www.share-connect.com

Thanks, mikeypzy

Supporting users have an ad free experience!