AIS 141 Ch 6 relational data

Dr. Franklin runs a small medical clinic specializing in family practice. She has many patients. When the patients visit the clinic, she may perform several tests to diagnose their conditions. She bills the patient one amount for the visit plus additional amounts for each test. How many classes did you include in your diagram?

3

Paige runs a small frozen yogurt shop. She buys several flavors of frozen yogurt mix from her yogurt supplier. She buys plastic cups in several sizes from another supplier. She buys cones from a third supplier. She counts yogurt and cones as inventory, but she treats the cups as an operating expense and doesn't track any cup inventory. how many classes

3

Choose the best description about a relational database. Multiple choice question. A relational database often has redundant data. A relational database is simple for the users to understand the design. A relational database is centralized and does not have flexibility.

A relational database is simple for the users to understand the design.

Dr. Franklin runs a small medical clinic specializing in family practice. She has many patients. When the patients visit the clinic, she may perform several tests to diagnose their conditions. She bills the patient one amount for the visit plus additional amounts for each test. Which of the following best explains the reason why your diagram does not need a class to identify Dr. Franklin?

All patient visits are performed by Dr. Franklin

If you see SELECT * in the first line of a SQL statement, what does the * mean? Multiple choice question. All the tables in a database All the attributes in a table All the non-key attributes in a table

All the attributes in a table

Paige runs a small frozen yogurt shop. She buys several flavors of frozen yogurt mix from her yogurt supplier. She buys plastic cups in several sizes from another supplier. She buys cones from a third supplier. She counts yogurt and cones as inventory, but she treats the cups as an operating expense and doesn't track any cup inventory. Assume that Paige's yogurt business expanded and Paige hired several employees to purchase inventory from suppliers. What class(es) and association(s) would you add to the diagram to track this information?

An EMPLOYEES class and an association between EMPLOYEES and PURCHASES.

Dr. Franklin runs a small medical clinic specializing in family practice. She has many patients. When the patients visit the clinic, she may perform several tests to diagnose their conditions. She bills the patient one amount for the visit plus additional amounts for each test. Now consider the possibility that each patient may have one insurance provider. So, your model includes an INSURANCE class. Which of the following best describes the association between that class and other classes on your diagram?

Associated with PATIENTS

In a Cash Receipt Table, which of the following attributes is a possible foreign key? Multiple choice question. Purchase order number Vendor ID Inventory ID Bank account number

Bank account number

Cash receipt: Cash receipt: Cash receipt date Cash receipt amount Cash receipt# Sales# Account detail Customer#

Cash receipt date Cash receipt amount Cash receipt# Sales# Customer#

The Cash Receipt table below contains seven attributes. Which of those could possibly be foreign keys? Remittance Advice Amount Cashier Invoice Customer Date Check #

Cashier Invoice Customer

Select a possible attribute for a class called CUSTOMER. Multiple choice question. Product unit price Invoice number Customer Address Sales dollar amount

Customer Address

Customer table: Customer email address Customer name Customer phone# Customer zip Customer# Salary basic

Customer email address Customer name Customer phone# Customer zip Customer#

In a Sales Table, which of the following attributes is a possible foreign key? Multiple choice question. Sales dollar amount Sales date Customer number Invoice number

Customer number

Who is responsible for the design, implementation, repair, and security of a company's database? Multiple choice question. Controller Database administrator IT Staff Chief Information Security Officer

Database administrator

Which of the following statements correctly describes the basic requirements of tables in a database? Multiple choice question. Each attribute in a table must have a unique name and the values of a specific attribute must be of the same type. Each column of a row may contain multiple data values. For example, a sales order may include different types of inventory. The data value for a foreign key in a table cannot be null. For data entry, we do not have to have a data value entered in the primary key field.

Each attribute in a table must have a unique name and the values of a specific attribute must be of the same type.

Choose the advantage(s) of using a relational database. Multiple select question. Flexibility Reduced redundancy Complexity Scalability

Flexibility Reduced redundancy Scalability

Paige runs a small frozen yogurt shop. She buys several flavors of frozen yogurt mix from her yogurt supplier. She buys plastic cups in several sizes from another supplier. She buys cones from a third supplier. She counts yogurt and cones as inventory, but she treats the cups as an operating expense and doesn't track any cup inventory. Which of the following best describes the names of the classes that you selected for your diagram?

Inventory, Purchases, Suppliers

Select the best description of a relational data model. Multiple choice question. It is widely used in the mainframe database management systems. It stores information in the form of related two-by-two tables. It allows users to identify relationships at the database creation or later whenever new information or requirements are desired. It requires relationships to be formed at the database creation and the relationships should not be changed later.

It allows users to identify relationships at the database creation or later whenever new information or requirements are desired.

Choose the best answer to explain a hierarchical data model. Multiple choice question. It is most commonly used to manage many-to-many relationships so it is the best model to represent the structure of today's network. It stores data in the form of two-by-two tables. It organizes data into a tree-like structure that allows repeating information using defined parent/child relationships.

It organizes data into a tree-like structure that allows repeating information using defined parent/child relationships.

Sales table: check all that apply Item# Sales# Customer# Employee# Purchase Sales date

Item# Sales# Customer# Employee# Sales date

Dr. Franklin runs a small medical clinic specializing in family practice. She has many patients. When the patients visit the clinic, she may perform several tests to diagnose their conditions. She bills the patient one amount for the visit plus additional amounts for each test. Assume that the clinic tracks each patient visit separately along with all the tests performed during that visit. Consider an association between the TESTS class and a PATIENT VISIT class. Which of the following best describes multiplicities that would appear next to the PATIENT VISIT class?

Minimum 0, Maximum *

Dr. Franklin runs a small medical clinic specializing in family practice. She has many patients. When the patients visit the clinic, she may perform several tests to diagnose their conditions. She bills the patient one amount for the visit plus additional amounts for each test. Assume that the clinic maintains a lists of tests that it can provide to patients. That list might specify the nature of each test as well as the price to be charged for the test. The list is established before any patient visit. Which of the following best describes multiplicities that would appear next to the TESTS class in an association with a class for patient visits?

Minimum 0, Maximum *

Paige runs a small frozen yogurt shop. She buys several flavors of frozen yogurt mix from her yogurt supplier. She buys plastic cups in several sizes from another supplier. She buys cones from a third supplier. She counts yogurt and cones as inventory, but she treats the cups as an operating expense and doesn't track any cup inventory. If there is an association between a SUPPLIERS class and a PURCHASES class, which of the following best describes the multiplicities next to the PURCHASES class? Assume that SUPPLIERS are added to the database before the first purchase.

Minimum 0, Maximum *

Paige runs a small frozen yogurt shop. She buys several flavors of frozen yogurt mix from her yogurt supplier. She buys plastic cups in several sizes from another supplier. She buys cones from a third supplier. She counts yogurt and cones as inventory, but she treats the cups as an operating expense and doesn't track any cup inventory. If there is an association between an INVENTORY class and a PURCHASES class, which of the following best describes the multiplicities next to the INVENTORY class? Assume that INVENTORY records are added to the database before the first purchase.

Minimum 0, Maximum *

Paige runs a small frozen yogurt shop. She buys several flavors of frozen yogurt mix from her yogurt supplier. She buys plastic cups in several sizes from another supplier. She buys cones from a third supplier. She counts yogurt and cones as inventory, but she treats the cups as an operating expense and doesn't track any cup inventory. If there is an association between an INVENTORY class and a PURCHASES class, which of the following best describes the multiplicities next to the PURCHASES class? Assume that INVENTORY records are added to the database before the first purchase.

Minimum 0, Maximum *

Dr. Franklin runs a small medical clinic specializing in family practice. She has many patients. When the patients visit the clinic, she may perform several tests to diagnose their conditions. She bills the patient one amount for the visit plus additional amounts for each test. Assume that Dr. Franklin records information on her patients during the first patient visit. Consider an association between the PATIENTS class and the PATIENT VISITS class. Which of the following best describes multiplicities next to the PATIENT VISIT class?

Minimum 1, Maximum *

Dr. Franklin runs a small medical clinic specializing in family practice. She has many patients. When the patients visit the clinic, she may perform several tests to diagnose their conditions. She bills the patient one amount for the visit plus additional amounts for each test. Consider an association between the PATIENTS class and the PATIENT VISITS class. Which of the following best describes multiplicities next to the PATIENT class?

Minimum 1, Maximum 1

Paige runs a small frozen yogurt shop. She buys several flavors of frozen yogurt mix from her yogurt supplier. She buys plastic cups in several sizes from another supplier. She buys cones from a third supplier. She counts yogurt and cones as inventory, but she treats the cups as an operating expense and doesn't track any cup inventory. If there is an association between a SUPPLIERS class and a PURCHASES class, which of the following best describes the multiplicities next to the SUPPLIERS class? Assume that SUPPLIERS are added to the database before the first purchase.

Minimum 1, Maximum 1

Identify three tables that would contain customer or subscription data. Employee code Sales table Customer table Payment detail Cash receipt table

Sales table Customer table Cash receipt table

A sales invoice typically includes the date of sale, salesperson, customer data, items included in the sale, and amount. Which foreign keys should be added to the following table to link all of these data elements?

Salesperson #, Customer #, Inventory # (often is NOT if the relationship is many-to-many), Remittance Advice # (only if requires customers to pay at once)

A sales invoice typically includes the date of sale, salesperson,customer data, items included in the sale, and amount. Which foreign keys should be added to the following table to link all of these data elements? (You may select more than one answer)

Salesperson #, Customer #, Inventory #, Sales #

What is SQL? Multiple choice question. Structured Query Language Synchronized Query Language Simple Query Language Sample Query Language

Structured Query Language

Dr. Franklin runs a small medical clinic specializing in family practice. She has many patients. When the patients visit the clinic, she may perform several tests to diagnose their conditions. She bills the patient one amount for the visit plus additional amounts for each test. Which of the following best describes the names of the classes that you selected for your diagram?

Tests, Patient visits, Patients

Paige runs a small frozen yogurt shop. She buys several flavors of frozen yogurt mix from her yogurt supplier. She buys plastic cups in several sizes from another supplier. She buys cones from a third supplier. She counts yogurt and cones as inventory, but she treats the cups as an operating expense and doesn't track any cup inventory. If there is an association between a PAIGE class and a SUPPLIERS class, which of the following best describes the multiplicities next to the PAIGE class? Assume that SUPPLIERS records are added to the database before the first purchase.

There is no association between PAIGE and SUPPLIERS in the model

What is a data dictionary? Multiple choice question. A data dictionary describes the data fields in a database such as field type and field length. A data dictionary is the design, implementation, repair, and security of a firm's database. A data dictionary contains many most useful words in a database. It is very useful for spelling checks.

a data dictionary describes the data fields in a database such as field type and field length.

A describes the data fields in each database record such as field description, field length, and field type (e.g., alphanumeric, numeric).

data dictionary

_______ is a collection of related data used by businesses to maintain information about various types of objects, events, people and places.

database

A computer program that creates, modifies and queries the database is called a _____ _____ _______ , or DBMS.

database management system

True or false: A primary key is a unique identifier of tables.

false

True or false: In a hierarchical data model, data elements always have a one-to-one relationship. In a network data model, data elements always have many-to-many relationships.

false

True or false: The SELECT statement in SQL is used to create a table.

false

True or false: The entity integrity rule requires using foreign keys to link tables.

false

Hierarchical data models organize data into a tree-like structure and are widely used in _______database management systems.

mainframe

A database management system is a computer program that: Multiple select question. modifies the database uses the database networks the database queries the database creates the database

modifies the database queries the database creates the database

A data model is a flexible model representing objects and their relationships and allows M:N mapping.

network

The structure of a _______data model connecting records in a database looks like a mesh.

network

A database administrator is responsible for all of the following except: Multiple choice question. repair of the database security of the database implementation of the database networking of the database design of the database

networking of the database

When using SQL, we use the command _______ _________ to sort the query result.

order, by

The______ data model stores data in the form of related two-dimensional tables.

relational

Among the different types of data models, _____data models are the dominant one in use today, because they offer advantages over other data models, including: flexibility and scalability, simplicity, and reduced information_____

relational redundancy

All of the following are types of data models used in databases today: Multiple select question. relational model network model flexibility model hierarchical model data model

relational model network model hierarchical model

In an REA data model, R means _______, E means _____, and A means_____ .

resources, events, agents

True or false: A foreign key is another table's primary key.

true

True or false: A primary key is a unique identifier of a specific row in a table.

true

True or false: The FROM command in SQL is to indicate which tables to be used in a query.

true