Concepts of Database Management 7th Edition
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.