Concepts of Database Management 7th Edition

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

A table is in first normal form if:

1. There are no repeating groups 2. All data values are atomic 3. Each field has a unique name 4. It has a primary key

13.

A database cannot be password protected to prevent unauthorized users from accessing the data.

23.

Based on the statement below, which of the following is the primary key?

Data Independence

Can change the structure of a database without changing the programs that access it

Attribute

Characteristic or property of an entity. May also be referred to as a field or column.

10. What is a form

Screen objects used to view, maintain, and print data from a database.

Database

Structure that can store information about multiple types of entities, attributes of entities and relationships between entities

Database

Structure that can store information about multiple types of entities, attributes of entities and relationships between entities.

4.

The comparison operators are +, *, %, and /.

Redundancy

The duplication of data, or storing the same data in more than one location.

Database Administrator

The person or group in charge of a database.

20.

The secondary key provides an important way of distinguishing one row in a table from another.

Entity

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

Integrity Constraints

a rule that the data in a database must follow.

Column

a set of data values of a particular simple type, one for each row of the table. Provides structure according to which the rows are composed.

Relationship

an association between entities

E-R Diagram

diagrams created to represent entities, attributes, and relationships graphically. Typically implemented as a database. In the case of a relational database, which stores data in tables, every row of each table represents one instance of an entity.

Form

display object used to maintain, view and print data in a database

Integrity

exists when all data has satisfied all established constraints. A good DBMS should provide an opportunity for users to incorporate these constraints when the database is designed, and it should ensure that the constraints are not violated.

One-to-Many Relationships

exists when 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 only one occurrence of the first entity

Database Administration

group in charge of a database.

Field

is the basic unit of data entry in a record. To define a new field, you give it a name. Then you select options that determine how thefields interprets, enters, calculates, stores, and displays data. After defining a field, you can set validation, auto entry, and storage options.

DBMS

program, or a collection of programs, through which users interact with a database. The actual manipula- tion of the underlying database is handled by the DBMS. In some cases, users may interact with the DBMS directly

Column

set of data values of a particular simple type, one for each row of the table. Provides structure according to which the rows are composed.

Database Administrator

the person or group in charge of a database.

Security

the prevention of unauthorized access to the database

Database Design

the process of producing a detailed data model of a database. This logical data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a data definition language, which can then be used to create a database.

19.

Rows are also called ____.

7.what is an E-R Diagram

An entity-relationship diagram is a visual way to view a database. Rectangles represent entities. Lines represent relationships. Dot represents many relationship. Absence of dot represents one relationship.

12.

An unnormalized relation is a table that has more than one row.

2.

An attribute is a characteristic or property of an entity.

8.

A good ____ should provide an opportunity for users to incorporate integrity constraints when they design the database.

15.

A group of people in charge of a database within an organization is often called the _Database Administration._

14.

A program, or collection of programs, through which users interact with a database is known as a(n) _Database Management System__.

11.

A relational database handles entities, attributes, and relationships by storing each entity in its own table.

5.

A(n) ____ is a person, place, object, event, or idea for which you want to store and process data.

1. What is redundancy?

Duplication of data.

Data File

File used to store data, computer version of paper file.

1. ____ are screen objects used to maintain, view, and print data from a database.

Forms

6.

In Access, you can add all fields from a table to the design grid by double-clicking the ____________________ in the table's field list.

10.

In an E-R diagram, ___Lines__________ represent relationships between connected entities.

16.

In an E-R diagram, the ______∞_______ at the end of a line indicates the "many" part of the one-to-many relationship between two entities.

9.

In an OR criterion, the overall criterion is true if either of the individual criteria is true.

18.

In relational algebra, the ____________________ of two tables is table containing all rows that are common in both table A & table B.

3.

Popular ____ include Access, Oracle, DB2, MySQL, and SQL Server.


Ensembles d'études connexes

Financial Markets and Institutions Final

View Set

Neuroscience: Exploring the Brain: 2

View Set

accounting chapter 8-inventories and costs of goods sold

View Set

Health study packet 2 - Nutrition

View Set

NURS 3320 Lifespan (exam 11) diabetes

View Set

US history 2 midterm proctored test chapter 19, 20

View Set