24.
Which symbol would you use in an E-R diagram to show that a student can
enroll in more than one course?
25.
_____ is the process of assuring that a relational database structure can be
implemented as a series of two-dimensional relations or tables.
26.
Which of the following is not one of the rules of normalization?
27.
If you were looking at an E-R diagram, how would you be able to identify a
many-to-many relationship between two entities?
28.
An intersection relation is:
29.
An intersection relation is also known as a(n) _____ relation.
30.
A composite primary key is:
31.
An intersection relation consists of:
32.
A foreign key is a:
33.
If a student’s ID was also present in a relation that stored enrollment
information, this field in the enrollment relation would be called a(n) _____
key.
34.
The primary key fields from the two original relations become foreign keys
in the intersection relation. When combined, the two foreign keys make up
the _____ for the intersection relation.
35.
If you find a many-to-many relationship, which of the following is a
guideline to be followed when creating an intersection relation?
36.
When defining information (fields) for a relation, you should ensure that:
37.
A database management system is:
38.
A data dictionary contains:
True / False Questions
39.
A database is a collection of information that you organize and access
according to the logical structure of that information.
40.
A relational database uses a series of logically related two-dimensional
tables or files to store information in the form of a database.
41.
Once you’ve implemented your database, you can neither change nor add
information.
42.
When creating a database you don’t need to know the physical location of
the information you want to see or use.
43.
A relational database is the most popular of all database types.
44.
Before you begin the process of designing a database, it is important that
you first understand the business rules.
45.
Business rules help you define the correct structure of your database.
46.
The first step in designing a relational database involves defining
information for each relation.
47.
An entity class is a table which stores similar information and can be
identified with a common key.
48.
A primary key is a field (or group of fields in some cases) that uniquely
describes each record.
49.
A Social security number is an example of a primary key because it is
unique.
50.
An instance uniquely describes records.