omis 452 EXAM final

In Microsoft Access, the relationship between two tables is not actually created until ________. A) the OK button in the Create Relationships dialog box is clicked. B) the Create button in the Create Relationships dialog box is clicked. C) the OK button in the Edit Relationships dialog box is clicked. D) the Create button in the Edit Relationships dialog box is clicked. E) the Join button in the Edit Relationships dialog box is clicked.

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 being limited to a maximum of ten tables in any given database the database being stored inside the DBMS the DBMS not supporting indexes the DBMS removing the metadata from the database the DBMS product taking the role of the DBMS and the database application generator

the DBMS product taking the role of the DBMS and the database application generator

A surrogate key may be appropriate under which of the following circumstances? The primary key is not unique. The relation only has one attribute. The available candidate keys would be prone to typographical errors. The primary key is numeric. The available candidate keys have little meaning to the users.

the available candidate keys would be prone to typographical errors

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

which of the following is NOT true of surrogate keys? They are usually hidden on forms and reports. They are usually generated by the DBMS. They are unique. They are numeric. They are meaningful to the users.

they are meaningful to the users

Every cell in a relation can hold only a single value. (t/f)

true

In crow's foot E-R notation, the hash mark indicates both a minimum cardinality of one and a maximum cardinality of one. (t/f)

true

Microsoft Access database files can be easily copied to create multiple copies of a database.

true

Which of the following is not a basic element of the E-R Model?

use cases

START OF CHAPTER 4

!!!!!!!!!

START OF CHAPTER 2!!!!!

----

A candidate key is ________.

A Candidate to be the Primary

In crow's foot style E-R diagrams, a crow's foot mark on the relationship line near an entity indicates ________.

A MAX cardinality of many

SQL stands for ________. Structural Question Language Standard Query Language Structured Question Language Structured Query Language Standard Question Language

Structured Query Language

A relational database stores data in the form of ________. columns spreadsheets tables forms lists

TABLES

A double arrow notation, A →→ B, is used to indicate a multivalued dependency. (t/f)

TRUE

A relational database can be defined as a self-describing collection of related tables. (T/F)

TRUE

An entity cannot be both weak and strong. (T/F)

TRUE

An entity class is described by the structure of the entities in that class.

TRUE

Ensuring that every value of a foreign key matches a value of the corresponding primary key is an example of a referential integrity constraint. (t/f)

TRUE

In the general division of labor between database applications and the DBMS, the application program determines which tables need to be modified. (T/F)

TRUE

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. (t/f)

TRUE

It is possible for an entity to have a relationship to itself. (t/f)

TRUE

Microsoft Access 2016 is a personal database that combines a DBMS with an application generator. (T/F)

TRUE

Microsoft Access 2016 uses the AutoNumber data type to create surrogate keys. (T/F)

TRUE

One problem with storing duplicated data is the potential for inconsistent values. (T/F)

TRUE

Relational database tables are commonly combined, queried, and processed using Structured Query Language (SQL). (T/F)

TRUE

Surrogate key values have no meaning to the users. (T/F)

TRUE

The DBMS is used to create the database itself. (T/F)

TRUE

The DBMS receives data update requests from the application program. (T/F)

TRUE

The primary key is used both to identify unique rows in a relation and to represent rows in relationships. (T/F)

TRUE

Theoretically, databases could store instances in columns and characteristics in rows, instead of the other way around. (T/F)

TRUE

To create a well-formed relation through normalization, every determinant must be a candidate key. (T/F)

TRUE

Microsoft Access is a good tool for creating mock-ups of forms and reports because ________. the form and report generators do not exist within Access itself Access has a version of Microsoft PowerPoint built into it to allow easy creation of PowerPoint slide shows. Access has a version of Microsoft Excel built into it to allow easy exporting of data to spreadsheets. Access wizards make it easy to create the forms and reports. Access forms and reports are very simplistic.

access wizards make it easy to create the forms and reports.

The Microsoft Access report editor is a(n) ________.

banded report editor

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 enitity

In Microsoft Access, a relationship between two tables is created ________. by dragging the foreign key column of one table onto the primary key column of the other table in the Relationships window by dragging the primary key column of one table onto the primary key column of the other table in the Relationships window by entering the name of the foreign key in the appropriate table in Design View by entering the name of the primary key in the appropriate table in Design View by dragging the primary key column of one table onto the foreign key column of the other table in the Relationships window

by dragging the primary key column of one table onto the foreign key column of the other table in the Relationships window

Which of the following is NOT a function of the database application in a database system? Control concurrency Create and process forms Create and transmit queries Create and process reports Execute application logic

control concurrency

The Microsoft Access application generator is not responsible for ________.

creating tables

The Microsoft Access application generator is not responsible for ________. A) creating forms B) creating reports C) creating queries D) creating tables E) storing queries

creating tables

Microsoft SQL Server is an example of a ________.

database management system

A database may be used to help people with all of the following except ________.

debug existing program code

The number of entity classes involved in a relationship is known as the relationship's ________.

degree

A key must be unique. (t/f)

false

During the implementation phase of developing a database system, the data model is transformed into a database design. (t/f)

false

In Microsoft Access, foreign keys are designated by using the Foreign Key button in the toolbar. (t/f)

false

In crow's foot E-R notation, the crow's foot indicates a maximum cardinality of one. (T/F)

false

In the relational model, each row of a table contains data that represents an attribute of the entity. (t/f)

false

Maximum cardinality indicates whether or not an instance of one entity class must be related to at least one instance of another entity class. (t/f)

false

Since surrogate keys are used to uniquely identify rows, their values are normally displayed prominently on all forms and reports for the users to see. (t/f)

false

A table that meets the requirements of a relation is said to be in which normal form? Domain/key normal form Relational normal form (RNF) Boyce-Codd normal form First normal form Second normal form

first normal form

In the normalization process, it is not necessary to ________. A) identify all the candidate keys of a relation. B) identify all the foreign keys of a relation. C) identify all the functional dependencies of a relation. D) identify all the determinants of a relation. E) determine if every determinant is a candidate key.

identify all the foreign keys of a relation

In SQL Server, the starting value of a surrogate key is called the ________. identity property identity identity increment identity Seed identity Start

identity seed

In the normalization process, if you find a candidate key that is not a determinant then you should not ________. -make the determinant of the functional dependency the primary key of the new relation create a referential integrity constraint between the original relation and the new relation rename the determinant to another attribute description place the columns of the functional dependency in a new relation leave a copy of the determinant as a foreign key in the original relation

rename the determinant to another attribute description

In Microsoft Access, relationships between tables are created ________.

In the relationships window

The component of a database that makes it self-describing is the ________. related tables data set metadata applications library

METADATA

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 cant be avoided

Which of the following would not be an example of database metadata?

Queries against records in the database tables

the statement SELECT STUDENT.StudentNumber, STUDENT.StudentName, FROM STUDENT WHERE STUDENT.StudentNumber = S12345678; is an example of ________.

SQL

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

Which of the following is true about a key? It may be unique. It may be non-unique. It can only identify one row. Both It may be unique and It may be non-unique None of these

Both it may be Unique and non-unique

During the normalization process, the remedy for a relation that is not well formed is to ________. create a functional dependency combine it with another relation that is well formed break it into two or more relations that are well formed create a surrogate key convert it into a list

Break it into two or more relations that are well formed

The default file format for Microsoft Access 2016 database files is the ________. SQL Server format Access XP format Access 2003 format Access 2007 format XBD format

Access 2007 format

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? Major is a candidate key. Phone is a candidate key. AdvisorID is a foreign key. SID is both a primary key and a foreign key. AdvisorName is a determinant.

AdvisorID is a foreign key.

The Microsoft Access 2013 data type of AutoNumber is used when there is a specific need for a ________. spare key primary key surrogate key foreign key secondary key

SURROGATE KEY

While the relational model for databases appears to hold much promise, few commercial databases have implemented it. (t/f)

FALSE

Which of the following is a function of the database application in a database system? Maintain database structures Backup and restore data Create tables Create and transmit queries Update database data

Create and Transmit Queries

The first step of the normalization process is to ________.

Identify all the candidate keys of a relation

The creation of a database and its tables is a function of which component of the database system? A) Users B) Application C) DBMS D) Database E) Web server

DBMS

Which of the following problems associated with storing data in a list is avoided by storing data in a relational database? A) CPU processing inefficiencies B) Lack of necessary bandwidth C) Running out of memory storage D) Duplication of data items E) Incorrect data typing

DUPLICATE OF DATA ITEMS

In the Entity-Relationship data model, all instances of an entity of a given type are grouped into ________.

ENTITY CLASSES

A PRODUCT entity instance is the collection of all PRODUCT entity classes. (T/F)

FALSE

A database is a set of one or more computer programs that serves as an intermediary between the users and the database management system (DBMS). (T/F)

FALSE

Although users use database systems, they are not considered part of a database system. (T/F)

FALSE

An advantage of keeping data in lists is that if you add a new row of data to the list, you will never have null values occurring for any data item in the row. (T/F)

FALSE

An advantage of keeping data in lists is that if you update a data value in one row of data in a list, other occurrences of the same data item in other rows will be automatically updated as well. (T/F)

FALSE

Any table that meets the definition of a relation is said to be in second normal form. (T/F)

FALSE

Every table is a relation, but not every relation is a table. (t/f)

FALSE

In the normalization process, it is not necessary to identify all the functional dependencies in a relation. (t/f)

FALSE

Metadata is the user data stored in the database. (T/F)

FALSE

Microsoft Access forms can only contain data from one table. (t/f)

FALSE

Normalization is the process of removing all functional dependencies from a relation. (t/f)

FALSE

SQL stands for Structural Question Language. (T/F)

FALSE

System requirements as documented by use cases, business rules, forms, reports, and queries are sufficient to design the database without using a formal data model. (T/F)

FALSE

The use of surrogate keys usually complicates application programming since most DBMS products require the application program to generate surrogate key values. (t/f)

FALSE

There is no reason for serious database developers to learn many aspects of database processing technology because DBMS products like Microsoft Access hide these aspects. (T/F)

FALSE

Unified Modeling Language (UML) has quickly replaced the E-R Model as the most popular technique for creating data models. (T/F)

FALSE

Web 2.0 web sites were popular due to their static, unchanging content. (T/F)

FALSE

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

Which of the following activities is NOT performed during the implementation phase of developing a database system? Writing application programs Creating reports Filling the database with data Creating forms Transforming the data model into a database design

Transforming the data model into a database design

A primary key is ________. used to represent columns in relationships not required to be unique comprised of exactly one attribute always automatically generated by the DBMS a candidate key

a candidate key

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 non-identifying relationship

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

A relational database is ________. a library of queries and data files for querying a self-describing collection of related tables a set of metadata a set of applications and the data sets for those applications a collection of forms and reports that support a given purpose

a self-describing collection of related tables

Which of the following is a function of the DBMS in a database system? Process Web page requests Create and process forms Perform backup and recovery Control applications Create and transmit queries

perform backup & recovery

Whether or not an instance of one entity class must participate in a relationship with another entity class is indicated by the ________.

minimum cardinality