MIS Ch 5

In a data model, a(n) ________ is something that a user wants to track.

Entity

A logical representation of database data, called the data model, is constructed by developers after building a database. T/F

False

Changing a relationship from one-to-many to many-to-many in a functional database is simply a matter of changing the N:N notation to N:M. T/F

False

In an entity-relationship (E-R) diagram, an entity is represented by a triangle, and the relationships between entities are represented by dotted lines. T/F

False

Most organizations develop their own database management system (DBMS) in order to obtain control over data. T/F

False

Most traditional databases use the Internet to transmit traffic back and forth between the users' computers and the DBMS server. T/F

False

Constraints on the minimum number of entities in a relationship are called ________ cardinalities.

Minimum

Which of the following is an international standard language for processing a database? SQL Cassandra MS Access DB2

SQL

Which of the following is true of N:M relationships? They are the same as N:N relationships. They can have more than one entity on each side of the relationship. They are also called one-to-many relationships. They represent minimum cardinalities in a relationship.

They can have more than one entity on each side of the relationship.

A data model describes data and relationships that will be stored in the database. T/F

True

A database management system (DBMS) is a program used to create, process, and administer a database. T/F

True

A foreign key is essential in relational databases to represent the relationship between two tables. T/F

True

A many-to-many (N:M) relationship means that more than one entity is allowed on each side of the relationship and that the number of entities on each side can be different. T/F

True

A user does not need user account credentials to access and process a database. T/F

True

Minimum cardinalities represent the lower limit on the number of entities required in a relationship. T/F

True

Reports refer to the structured presentation of data using sorting, grouping, filtering, and other operations. T/F

True

To modify an existing table, a developer can open the metadata form for that table and add a new row of metadata. T/F

True

________ are the final judges as to what data the database should contain and how the records in that database should be related to one another.

Users

Entities in a data model have ________ that describe the characteristics of the entity.

attributes

An administrator should create a ________ before developing the database design.

data model

A(n) ________ is a request for data from a database.

query

Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. She should use a ________ to obtain the information that she wants from the database.

query

Identify the first step in transforming a data model into a relational database design. creating a table for each entity representing the entity relationships normalizing the data and files creating foreign keys

representing the entity relationships

Browser database application forms, reports, and queries are displayed and processed using html5, css3, and JavaScript. T/F

true

One of the functions of a DBMS is to provide tools to assist in the administration of a database. T/F

true