BI 330 Test 1 Review
In crow's foot style E-R diagrams, a hash mark across the relationship line near an entity indicates:
Both a minimum cardinality of one and a maximum cardinality of one
An ID-dependent entity is:
Both a special type of weak entity and an entity in which the identifier of the entity includes the identifier of another entity
Which of the following is not a function of the database application in a database system?
Control concurrency
Which of the following is a function of the database application in a database system?
Create and transmit queries
The creation of a database and its tables is a function of which component of the database system?
DBMS
Which of the following functional dependency diagrams accurately represents the following situation:
(BuildingName, RoomNumber) → (Capacity, Department)
Given only the following excerpt of an E-R model:
+<-Entity B
Microsoft Access 2013 database files are stored using the file extension:
.accdb.
Which of the following would not be contained in a use case?
A prototype of the system performing a given task
Which of the following is not true about a relation?
A relation may have duplicate column names.
Given only the following excerpt of an E-R model: Which of the following is known to be true?
A single instance of ENTITY B may be related to many instances of ENTITY A.
The default file format for Microsoft Access 2013 database files is the:
Access 2007 format.
Microsoft Access is a good tool for creating mock-ups of forms and reports because:
Access wizards make it easy to create the forms and reports.
Given the relations: STUDENT (SID, StudentName, Major, AdvisorID) ADVISOR (AdvisorID, AdvisorName, Office, Phone) such that each student is assigned to one advisor, which of the following is true?
AdvisorID is a foreign key.
Which of the following is true about a relation?
All entries in any column must be of the same kind.
A candidate key is:
All of these
A database may be used to help people:
All of these
A primary key is:
All of these
Although Microsoft Access is a personal database, it is still subject to the following modification problem(s):
All of these
Given the below functional dependency, MedicineCode → (MedicineName, ShelfLife, Manufacturer, Dosage)
All of these
In the normalization process, if you find a candidate key that is not a determinant then you should:
All of these
Which of the following is true about a key?
All of these
Which of the following problems associated with storing data in a list is avoided by storing data in a relational database?
All of these
Microsoft Access can be used to prototype databases for which of the following DBMS products?
All of these Answers: Microsoft Access SQL Server MySQL Oracle Database
Which of the following is not a source for user requirements during the requirements analysis stage of developing a database system?
All of these are sources for user requirements.
Which of the following is not a basic component of a database system?
ERD
Given only the following excerpt of an E-R model:
Many instances of ENTITY A may be related to one instance of ENTITY B.
Given the below functional dependency, MedicineCode → (MedicineName, ShelfLife, Manufacturer, Dosage) which of the following statements is not known to be true?
MedicineName is a determinant.
In the normalization process, if you find a candidate key that is not a primary key then you should:
None of these
Which of the following is not true about null values?
Null values cannot be avoided.
Which of the following is a function of the DBMS in a database system?
Perform backup and recover
Which of the following would not be an example of database metadata?
Queries against records in the database tables
Which of the following terms is synonymous with "tuple"?
Row
The statement SELECT STUDENT StudentNumber FROM Student WHERE Student is an example of:
SQL
SQL stands for:
Structured Query Language.
Which of the following terms is synonymous with "relation"?
Table
Which of the following is true about identifiers of entities?
The value of an identifier may identify a set of entity instances.
Which of the following activities is not performed during the implementation phase of developing a database system?
Transforming the data model into a database design
Which of the following is not a basic element of the E-R Model?
Use cases
A use case can be used to perform which of the following tasks?
Validate the data model
Which of the following is not a stage in the development of a database system?
Validation
In crow's foot style E-R diagrams, a crow's foot mark on the relationship line near an entity indicates:
a maximum cardinality of many.
In crow's foot style E-R diagrams, a circle across the relationship line near an entity indicates:
a minimum cardinality of zero.
A dashed line between entities indicates:
a nonidentifying relationship.
A rule that requires that the values in a foreign key must have a matching value in the primary key to which the foreign key corresponds is called:
a referential integrity constraint
A relational database is:
a self-describing collection of related tables.
In crow's foot style E-R diagrams, a single entity together with a related set of entities that each contain specific sets of attributes related to the single entity represent:
a supertype / subtype relationship.
The Microsoft Access 2013 form editor is a(n):
banded form editor.
The Microsoft Access 2013 report editor is a(n):
banded report editor.
During the normalization process, the remedy for a relation that is not well formed is to:
break it into two or more relations that are well formed.
In Microsoft Access, a relationship between two tables is created:
by dragging the primary key column of one table onto the foreign key column of the other table in the Relationships window.
A key that contains more than one attribute is called a(n
composite key.
A key that contains more than one attribute is called a(n):
composite key.
The Microsoft Access application generator is not responsible for:
creating tables.
The representation of the content, relationships, and constraints of the data needed to support the system requirements is the:
data model.
Microsoft SQL Server is an example of a:
database management system.
The number of entity classes involved in a relationship is known as the relationship's:
degree
In the Entity-Relationship data model, all instances of an entity of a given type are grouped into:
entity classes.
One important relational design principle is that:
every determinant must be a candidate key.
When the primary key of one relation is placed into a second relation, it is called a:
foreign key
The first step of the normalization process is to:
identify all the candidate keys of a relation.
In the normalization process, it is not necessary to:
identify all the foreign keys of a relation.
In Microsoft Access, relationships between tables are created:
in the Relationships window.
The component of a database that makes it self-describing is the:
metadata.
Whether or not an instance of one entity class must participate in a relationship with another entity class is indicated by the:
minimum cardinality.
The Microsoft Access 2013 data type of AutoNumber is used when there is a specific need for a:
surrogate key.
A relational database stores data in the form of:
tables
In Microsoft Access, the relationship between two tables is not actually created until:
the Create button in the Edit Relationships dialog box is clicked.
Microsoft Access is a personal database system, and a personal database system is characterized by:
the DBMS product taking the role of the DBMS and the database application generator.
In the normalization process, if you find that every determinant in a relation is a candidate key then you have determined that:
the relation is well formed.
Today almost every commercial database is based on:
the relational model.
Microsoft Access can be used to build a prototype database, which allows users:
to validate the data model by demonstrating the consequences of data modeling decisions.
