Deck 12: Database Design

ملء الشاشة (f)
exit full mode
سؤال
The attributes of an entity become the _____ in the table.

A) records
B) columns
C) rows
D) tuples
استخدم زر المسافة أو
up arrow
down arrow
لقلب البطاقة.
سؤال
If a client can be offered many courses and each course is offered to many clients, there is a(n) _____ relationship between clients and courses.

A) many-to-one
B) many-to-many
C) all-to-all
D) one-to-many
سؤال
A(n) _____ is a collection of relations.

A) entity
B) relational database
C) tuple
D) normal form
سؤال
A(n) _____ is an association between entities.

A) relationship
B) normalization
C) configuration
D) union
سؤال
If one employee is assigned to a project and each project has only one employee working on it, there is a(n) _____ relationship between employees and projects.

A) uni-to-uni
B) only-to-one
C) one-to-one
D) one-to-many
سؤال
There is a _____ relationship between business analysts and clients because one business analyst is associated with many clients but each client is associated with only one business analyst.

A) one-to-one
B) one-to-all
C) many-to-one
D) one-to-many
سؤال
A(n) _____ is a collection of tables.

A) entity
B) relational database
C) tuple
D) normal form
سؤال
A(n) _____ is like a noun: It is a person, place, thing, or event.

A) record
B) tuple
C) entity
D) attribute
سؤال
When creating a database, a(n) _____ is represented as a table.

A) entity
B) attribute
C) determinant
D) tuple
سؤال
Many-to-many relationships are implemented through an additional table that contains _____ fields for both of the related tables.

A) matching
B) dependent
C) descendent
D) nonkey
سؤال
<strong>  The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, each row should be _____.</strong> A) updated B) unique C) normalized D) non-descript <div style=padding-top: 35px> The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, each row should be _____.

A) updated
B) unique
C) normalized
D) non-descript
سؤال
A(n) _____ is a property of an entity.

A) record
B) tuple
C) entity
D) attribute
سؤال
The process of determining the particular tables and fields that will make up a database is known as _____.

A) visualization
B) diagramming
C) normalization
D) database design
سؤال
The determination of database requirements is part of a process known as _____.

A) visualization
B) systems analysis
C) normalization
D) outlining
سؤال
A(n) _____ interviews users, examines existing and proposed documents, investigates current procedures, and reviews organizational policies to determine exactly the type of data needs the database must support.

A) network analyst
B) SQL specialist
C) infrastructure analyst
D) systems analyst
سؤال
<strong>  The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, the order of the rows and the order of the columns are _____.</strong> A) predetermined B) critical C) immaterial D) distinct <div style=padding-top: 35px> The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, the order of the rows and the order of the columns are _____.

A) predetermined
B) critical
C) immaterial
D) distinct
سؤال
<strong>  The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, you should restrict each position in the table to a single entry, that is, you do not permit multiple entries, often called _____ in the table.</strong> A) anomalies B) tuples C) redundancy D) repeating groups <div style=padding-top: 35px> The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, you should restrict each position in the table to a single entry, that is, you do not permit multiple entries, often called _____ in the table.

A) anomalies
B) tuples
C) redundancy
D) repeating groups
سؤال
<strong>  The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, each column in a table should have a _____ name and entries in each column should match this column name.</strong> A) unique B) pre-defined C) computer-generated D) duplicate <div style=padding-top: 35px> The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, each column in a table should have a _____ name and entries in each column should match this column name.

A) unique
B) pre-defined
C) computer-generated
D) duplicate
سؤال
When you combine a field name with a table name, you say that you _____ the field names.

A) concatenate
B) combine
C) normalize
D) qualify
سؤال
The formal term for a table is _____.

A) tuple
B) relation
C) two-dimensional record
D) object
سؤال
The _____ key of a table is the field or minimum collection of fields that uniquely identifies a given row in that table.

A) alternate
B) index
C) secondary
D) primary
سؤال
Columns in a table often are called fields or _____.

A) attributes
B) lines
C) relations
D) tuples
سؤال
<strong>  The accompanying figure shows the shorthand representation for a Course Offerings table containing a repeating group. In general, when converting a non-1NF table to 1NF, the primary key typically will include the original primary key _____ with the key of the repeating group.</strong> A) concatenated B) unionized C) cross-joined D) equi-joined <div style=padding-top: 35px> The accompanying figure shows the shorthand representation for a Course Offerings table containing a repeating group. In general, when converting a non-1NF table to 1NF, the primary key typically will include the original primary key _____ with the key of the repeating group.

A) concatenated
B) unionized
C) cross-joined
D) equi-joined
سؤال
To depict the structure of a relational database, you can use a commonly accepted shorthand representation. You write the name of the table and then within _____ list all of the fields in the table.

A) square brackets [ ]
B) curly braces { }
C) slashes / /
D) parentheses ( )
سؤال
Rows in a table often are called records or _____.

A) attributes
B) lines
C) relations
D) tuples
سؤال
A(n) _____ key is a field in one table whose values are required to match the primary key of another table.

A) alternate
B) foreign
C) candidate
D) relational
سؤال
<strong>  The accompanying figure shows the shorthand representation for a Course Offerings table containing a repeating group. This table is called a(n) _____ table.</strong> A) redundant B) duplicate C) 1NF D) unnormalized <div style=padding-top: 35px> The accompanying figure shows the shorthand representation for a Course Offerings table containing a repeating group. This table is called a(n) _____ table.

A) redundant
B) duplicate
C) 1NF
D) unnormalized
سؤال
Any field or collection of fields that determines another field is called a(n) _____.

A) attribute
B) antipode
C) determinant
D) descendent
سؤال
A table is in third normal form (3NF) if it is in second normal form and if the only determinants it contains are _____ keys.

A) alternate
B) indexed
C) primary
D) candidate
سؤال
_____ is the process of making sure that a database design is free of potential update, redundancy, and consistency problems.

A) Redaction
B) Synchronization
C) Replication
D) Normalization
سؤال
A field is a(n) _____ field if it is not part of the primary key.

A) attribute
B) nonkey
C) non-normal
D) alpha
سؤال
The normalization process involves converting tables into various types of _____.

A) tuples
B) relations
C) normal forms
D) diagrams
سؤال
A table that contains a repeating group, or multiple entries for a single row, is called a(n) _____ table.

A) 1NF
B) unnormalized
C) redundant
D) duplicate
سؤال
<strong>  The accompanying figure shows the shorthand representation for a Course Offerings table containing a repeating group. To convert the table to _____, remove the parentheses enclosing the repeating group and expand the primary key to include the key to the repeating group.</strong> A) 1NF B) 2NF C) 3NF D) Boyce-Codd NF <div style=padding-top: 35px> The accompanying figure shows the shorthand representation for a Course Offerings table containing a repeating group. To convert the table to _____, remove the parentheses enclosing the repeating group and expand the primary key to include the key to the repeating group.

A) 1NF
B) 2NF
C) 3NF
D) Boyce-Codd NF
سؤال
Social Security Number and Employee ID are candidate keys for a table. An organization chooses Employee ID as the primary key. Social Security Number is considered a(n) _____ key.

A) primary
B) candidate
C) alternate
D) index
سؤال
An organization can use either Social Security Number or Employee ID as the primary key for a table. These two fields are considered _____ keys.

A) primary
B) candidate
C) alternate
D) index
سؤال
A table is in second normal form (2NF) if it is in first normal form and no _____ field is dependent on only a portion of the primary key.

A) attribute
B) alpha
C) non-normal
D) nonkey
سؤال
If you have already created a database and relationships in Access, the _____ window and corresponding report provide a helpful diagram of the design.

A) Referential Integrity
B) Database Tools
C) Relationships
D) ERD
سؤال
If Client Number _____ Client Name, then Client Name is functionally dependent on Client Number.

A) precedes
B) qualifies
C) determines
D) follows
سؤال
When duplicate field names exist in a database, you need to indicate the field to which you are referring. You do so by writing both the table name and the field name separated by a _____.

A) comma
B) period
C) semicolon
D) colon
سؤال
Modified Multiple Choice The most common normal forms are _____.

A) 1NF
B) 2NF
C) 3NF
D) 4NF
سؤال
Modified Multiple Choice ____ are update anomalies.

A) Update
B) Inconsistent data
C) Additions
D) Deletions
سؤال
In a relation, the order of rows is fixed; rows must be in ascending order by primary key.
سؤال
Modified Multiple Choice _____ is(are) used in the shorthand representation of table.

A) Underlining ____
B) Slashes / /
C) Parentheses ( )
D) Arrow ®
سؤال
Rows in a table often are called records.
سؤال
Standardization is a process used to make sure a database design is free of potential update, redundancy, and consistency problems.
سؤال
In designing a database, you must first identify the fields in the database and then the tables.
سؤال
A dependent key is a field or combination of fields on which all fields in the table are functionally dependent.
سؤال
Many-to-many relationships are implemented through an additional table that contains matching fields for both of the related tables.
سؤال
If you use the word, Order, for the name of a table, you cannot use SQL to query that table.
سؤال
A foreign key is a field in one table whose values are required to match the primary key of another table.
سؤال
In a relation, the order of columns is immaterial.
سؤال
The formal term for a table is tuple.
سؤال
The relationship between business analysts and clients is an example of a one-to-one relationship because one business analyst is associated with many clients, but each client has only one business analyst.
سؤال
The primary key of a table is the field or minimum collection of fields that uniquely identifies a given row in that table.
سؤال
In Access, the terms record and field are used to describe rows and columns in a relation.
سؤال
If a client can be offered many courses and each course is offered to many clients, there is a many-to-many relationship between clients and courses.
سؤال
You always must qualify field names, even if there is no possibility of confusion.
سؤال
Modified Multiple Choice Rows in a table often are called _____.

A) records
B) attributes
C) fields
D) tuples
سؤال
Modified Multiple Choice Columns in a table often are called _____.

A) records
B) attributes
C) fields
D) tuples
سؤال
A tuple is a property of an entity.
سؤال
A field is a dependent field if it is not part of the primary key.
سؤال
If the primary key of a table contains only a single field, the table is automatically in second normal form (2NF).
سؤال
Social Security Number and Employee ID are candidate keys for a table. An organization chooses Employee ID as the primary key. Social Security Number is considered an alternate key.
سؤال
The process of determining the particular tables and fields that will make up a database is known as ____________________.
سؤال
Any field or collection of fields that determines another field is called a descendent.
سؤال
A table that contains a repeating group, or multiple entries for a single row, is called a non-standard table.
سؤال
A(n) ____________________ is an association between entities.
سؤال
If a client can be offered many courses and each course is offered to many clients, there is a(n) ____________________ relationship between clients and courses.
سؤال
If you know that whenever you are given a value for one field, you will be able to determine a single value for a second field, the first field is said to define the second field.
سؤال
The goal of normalization is to take a table or collection of tables and produce a new collection of tables that represents the same information but is free of problems.
سؤال
A table is in first normal form (1NF) if it does not contain repeating groups.
سؤال
The determination of database requirements is part of a process known as systems analysis .
سؤال
You can use an entity-relationship diagram (ERD) to diagram a database design.
سؤال
A(n) ____________________ is like a noun: It is a person, place, thing, or event.
سؤال
When you merge entities in a database design, the merged entities automatically will be in third normal form (3NF).
سؤال
Relationships are implemented through matching fields.
سؤال
Existing documents, such as purchase orders and procedural manuals, can often furnish helpful information concerning the database design.
سؤال
A table is in third normal form (3NF) if it is second normal form and if the only determinants it contains are candidate keys.
سؤال
The determination of database requirements is part of a process known as ____________________.
فتح الحزمة
قم بالتسجيل لفتح البطاقات في هذه المجموعة!
Unlock Deck
Unlock Deck
1/112
auto play flashcards
العب
simple tutorial
ملء الشاشة (f)
exit full mode
Deck 12: Database Design
1
The attributes of an entity become the _____ in the table.

A) records
B) columns
C) rows
D) tuples
B
2
If a client can be offered many courses and each course is offered to many clients, there is a(n) _____ relationship between clients and courses.

A) many-to-one
B) many-to-many
C) all-to-all
D) one-to-many
B
3
A(n) _____ is a collection of relations.

A) entity
B) relational database
C) tuple
D) normal form
B
4
A(n) _____ is an association between entities.

A) relationship
B) normalization
C) configuration
D) union
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
5
If one employee is assigned to a project and each project has only one employee working on it, there is a(n) _____ relationship between employees and projects.

A) uni-to-uni
B) only-to-one
C) one-to-one
D) one-to-many
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
6
There is a _____ relationship between business analysts and clients because one business analyst is associated with many clients but each client is associated with only one business analyst.

A) one-to-one
B) one-to-all
C) many-to-one
D) one-to-many
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
7
A(n) _____ is a collection of tables.

A) entity
B) relational database
C) tuple
D) normal form
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
8
A(n) _____ is like a noun: It is a person, place, thing, or event.

A) record
B) tuple
C) entity
D) attribute
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
9
When creating a database, a(n) _____ is represented as a table.

A) entity
B) attribute
C) determinant
D) tuple
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
10
Many-to-many relationships are implemented through an additional table that contains _____ fields for both of the related tables.

A) matching
B) dependent
C) descendent
D) nonkey
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
11
<strong>  The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, each row should be _____.</strong> A) updated B) unique C) normalized D) non-descript The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, each row should be _____.

A) updated
B) unique
C) normalized
D) non-descript
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
12
A(n) _____ is a property of an entity.

A) record
B) tuple
C) entity
D) attribute
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
13
The process of determining the particular tables and fields that will make up a database is known as _____.

A) visualization
B) diagramming
C) normalization
D) database design
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
14
The determination of database requirements is part of a process known as _____.

A) visualization
B) systems analysis
C) normalization
D) outlining
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
15
A(n) _____ interviews users, examines existing and proposed documents, investigates current procedures, and reviews organizational policies to determine exactly the type of data needs the database must support.

A) network analyst
B) SQL specialist
C) infrastructure analyst
D) systems analyst
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
16
<strong>  The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, the order of the rows and the order of the columns are _____.</strong> A) predetermined B) critical C) immaterial D) distinct The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, the order of the rows and the order of the columns are _____.

A) predetermined
B) critical
C) immaterial
D) distinct
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
17
<strong>  The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, you should restrict each position in the table to a single entry, that is, you do not permit multiple entries, often called _____ in the table.</strong> A) anomalies B) tuples C) redundancy D) repeating groups The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, you should restrict each position in the table to a single entry, that is, you do not permit multiple entries, often called _____ in the table.

A) anomalies
B) tuples
C) redundancy
D) repeating groups
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
18
<strong>  The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, each column in a table should have a _____ name and entries in each column should match this column name.</strong> A) unique B) pre-defined C) computer-generated D) duplicate The accompanying figure shows the Course table in the Camashaly Design database. In a relational database, each column in a table should have a _____ name and entries in each column should match this column name.

A) unique
B) pre-defined
C) computer-generated
D) duplicate
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
19
When you combine a field name with a table name, you say that you _____ the field names.

A) concatenate
B) combine
C) normalize
D) qualify
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
20
The formal term for a table is _____.

A) tuple
B) relation
C) two-dimensional record
D) object
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
21
The _____ key of a table is the field or minimum collection of fields that uniquely identifies a given row in that table.

A) alternate
B) index
C) secondary
D) primary
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
22
Columns in a table often are called fields or _____.

A) attributes
B) lines
C) relations
D) tuples
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
23
<strong>  The accompanying figure shows the shorthand representation for a Course Offerings table containing a repeating group. In general, when converting a non-1NF table to 1NF, the primary key typically will include the original primary key _____ with the key of the repeating group.</strong> A) concatenated B) unionized C) cross-joined D) equi-joined The accompanying figure shows the shorthand representation for a Course Offerings table containing a repeating group. In general, when converting a non-1NF table to 1NF, the primary key typically will include the original primary key _____ with the key of the repeating group.

A) concatenated
B) unionized
C) cross-joined
D) equi-joined
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
24
To depict the structure of a relational database, you can use a commonly accepted shorthand representation. You write the name of the table and then within _____ list all of the fields in the table.

A) square brackets [ ]
B) curly braces { }
C) slashes / /
D) parentheses ( )
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
25
Rows in a table often are called records or _____.

A) attributes
B) lines
C) relations
D) tuples
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
26
A(n) _____ key is a field in one table whose values are required to match the primary key of another table.

A) alternate
B) foreign
C) candidate
D) relational
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
27
<strong>  The accompanying figure shows the shorthand representation for a Course Offerings table containing a repeating group. This table is called a(n) _____ table.</strong> A) redundant B) duplicate C) 1NF D) unnormalized The accompanying figure shows the shorthand representation for a Course Offerings table containing a repeating group. This table is called a(n) _____ table.

A) redundant
B) duplicate
C) 1NF
D) unnormalized
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
28
Any field or collection of fields that determines another field is called a(n) _____.

A) attribute
B) antipode
C) determinant
D) descendent
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
29
A table is in third normal form (3NF) if it is in second normal form and if the only determinants it contains are _____ keys.

A) alternate
B) indexed
C) primary
D) candidate
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
30
_____ is the process of making sure that a database design is free of potential update, redundancy, and consistency problems.

A) Redaction
B) Synchronization
C) Replication
D) Normalization
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
31
A field is a(n) _____ field if it is not part of the primary key.

A) attribute
B) nonkey
C) non-normal
D) alpha
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
32
The normalization process involves converting tables into various types of _____.

A) tuples
B) relations
C) normal forms
D) diagrams
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
33
A table that contains a repeating group, or multiple entries for a single row, is called a(n) _____ table.

A) 1NF
B) unnormalized
C) redundant
D) duplicate
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
34
<strong>  The accompanying figure shows the shorthand representation for a Course Offerings table containing a repeating group. To convert the table to _____, remove the parentheses enclosing the repeating group and expand the primary key to include the key to the repeating group.</strong> A) 1NF B) 2NF C) 3NF D) Boyce-Codd NF The accompanying figure shows the shorthand representation for a Course Offerings table containing a repeating group. To convert the table to _____, remove the parentheses enclosing the repeating group and expand the primary key to include the key to the repeating group.

A) 1NF
B) 2NF
C) 3NF
D) Boyce-Codd NF
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
35
Social Security Number and Employee ID are candidate keys for a table. An organization chooses Employee ID as the primary key. Social Security Number is considered a(n) _____ key.

A) primary
B) candidate
C) alternate
D) index
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
36
An organization can use either Social Security Number or Employee ID as the primary key for a table. These two fields are considered _____ keys.

A) primary
B) candidate
C) alternate
D) index
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
37
A table is in second normal form (2NF) if it is in first normal form and no _____ field is dependent on only a portion of the primary key.

A) attribute
B) alpha
C) non-normal
D) nonkey
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
38
If you have already created a database and relationships in Access, the _____ window and corresponding report provide a helpful diagram of the design.

A) Referential Integrity
B) Database Tools
C) Relationships
D) ERD
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
39
If Client Number _____ Client Name, then Client Name is functionally dependent on Client Number.

A) precedes
B) qualifies
C) determines
D) follows
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
40
When duplicate field names exist in a database, you need to indicate the field to which you are referring. You do so by writing both the table name and the field name separated by a _____.

A) comma
B) period
C) semicolon
D) colon
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
41
Modified Multiple Choice The most common normal forms are _____.

A) 1NF
B) 2NF
C) 3NF
D) 4NF
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
42
Modified Multiple Choice ____ are update anomalies.

A) Update
B) Inconsistent data
C) Additions
D) Deletions
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
43
In a relation, the order of rows is fixed; rows must be in ascending order by primary key.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
44
Modified Multiple Choice _____ is(are) used in the shorthand representation of table.

A) Underlining ____
B) Slashes / /
C) Parentheses ( )
D) Arrow ®
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
45
Rows in a table often are called records.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
46
Standardization is a process used to make sure a database design is free of potential update, redundancy, and consistency problems.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
47
In designing a database, you must first identify the fields in the database and then the tables.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
48
A dependent key is a field or combination of fields on which all fields in the table are functionally dependent.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
49
Many-to-many relationships are implemented through an additional table that contains matching fields for both of the related tables.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
50
If you use the word, Order, for the name of a table, you cannot use SQL to query that table.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
51
A foreign key is a field in one table whose values are required to match the primary key of another table.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
52
In a relation, the order of columns is immaterial.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
53
The formal term for a table is tuple.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
54
The relationship between business analysts and clients is an example of a one-to-one relationship because one business analyst is associated with many clients, but each client has only one business analyst.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
55
The primary key of a table is the field or minimum collection of fields that uniquely identifies a given row in that table.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
56
In Access, the terms record and field are used to describe rows and columns in a relation.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
57
If a client can be offered many courses and each course is offered to many clients, there is a many-to-many relationship between clients and courses.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
58
You always must qualify field names, even if there is no possibility of confusion.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
59
Modified Multiple Choice Rows in a table often are called _____.

A) records
B) attributes
C) fields
D) tuples
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
60
Modified Multiple Choice Columns in a table often are called _____.

A) records
B) attributes
C) fields
D) tuples
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
61
A tuple is a property of an entity.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
62
A field is a dependent field if it is not part of the primary key.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
63
If the primary key of a table contains only a single field, the table is automatically in second normal form (2NF).
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
64
Social Security Number and Employee ID are candidate keys for a table. An organization chooses Employee ID as the primary key. Social Security Number is considered an alternate key.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
65
The process of determining the particular tables and fields that will make up a database is known as ____________________.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
66
Any field or collection of fields that determines another field is called a descendent.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
67
A table that contains a repeating group, or multiple entries for a single row, is called a non-standard table.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
68
A(n) ____________________ is an association between entities.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
69
If a client can be offered many courses and each course is offered to many clients, there is a(n) ____________________ relationship between clients and courses.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
70
If you know that whenever you are given a value for one field, you will be able to determine a single value for a second field, the first field is said to define the second field.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
71
The goal of normalization is to take a table or collection of tables and produce a new collection of tables that represents the same information but is free of problems.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
72
A table is in first normal form (1NF) if it does not contain repeating groups.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
73
The determination of database requirements is part of a process known as systems analysis .
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
74
You can use an entity-relationship diagram (ERD) to diagram a database design.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
75
A(n) ____________________ is like a noun: It is a person, place, thing, or event.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
76
When you merge entities in a database design, the merged entities automatically will be in third normal form (3NF).
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
77
Relationships are implemented through matching fields.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
78
Existing documents, such as purchase orders and procedural manuals, can often furnish helpful information concerning the database design.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
79
A table is in third normal form (3NF) if it is second normal form and if the only determinants it contains are candidate keys.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
80
The determination of database requirements is part of a process known as ____________________.
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.
فتح الحزمة
k this deck
locked card icon
فتح الحزمة
افتح القفل للوصول البطاقات البالغ عددها 112 في هذه المجموعة.