FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Relational Databases

Show Answer

Share

---

All types

Filters

Study Flashcards

Question 1

Multiple Choice

Review LaterAdd Note

Review Later

The combination of the database,the DBMS,and the application programs that access the database through the DBMS is referred to as the

A) data warehouse.
B) database administrator.
C) database system.
D) database management system.

E) B) and D)
F) C) and D)

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

Which would not generally be considered a data dictionary output report?

A) a list of cash balances in the organization's bank accounts
B) a list of all programs in which a data element is used
C) a list of all synonyms for the data elements in a particular file
D) a list of all data elements used by a particular user

E) A) and C)
F) A) and B)

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

Tom Wilson is chairman of the Rare Car Club,where he maintains a database of registered rare cars and their history.One table will store the model,make,vehicle identification number,and other characteristics of all of the registered rare cars.Each rare car is uniquely identified by a registration number.A second table will contain data that link each rare car to its most recent estimated fair market value by means of their registration numbers.The primary key in the first table is

Using the database depicted above,in the Sales table,"Customer #" is best described as

Suppose a relational database contained two linked tables.Assuming the organization wants the database to be normalized,which of the following items represents a problem to normalization?

The schema that provides an organization-wide view of the entire database is known as the

________ in a well-structured relational database.

Which of the following would not be one of the well-structured tables in a well-designed relational database used to generate this sales invoice?

Which of the following elements link rows in one table to rows in another table?

A relational database in which vendor data is not maintained independently of purchase order data will most likely result in

Discuss the ways in which a well-designed DBMS will facilitate the three basic functions of creating,changing,and querying data.

Abby Burke has created custom statues made out of scrap metal for over ten years.Abby has kept detailed records of every statue she has ever created.For every sale,she obtains the customer's name and address,a description of the statue,and a picture of the statue sold to the customer.Her unique style has recently attracted the attention of several celebrities.Ready to take her business to the next level,Abby has hired you to construct an accounting information system,which she wants modeled after her paper records.You begin development of the relational database that will form the core of the AIS by envisioning the record stored in a single table with a column that represents each attribute.You then begin to break this table down into smaller tables.This process is called

Record layouts,definitions,addresses,and indexes will be stored at the ________ level schema.

Identify one potential outcome of the insert anomaly.

Describe what you think will be the main impact of database technology in your career.

In the Inventory table above,"Item number" is best described as

Abby Burke has created custom statues made out of scrap metal for over ten years.Abby has kept detailed records of every statue she has ever created.For every sale,she obtains the customer's name and address,a description of the statue,and a picture of the statue sold to the customer.Her unique style has recently attracted the attention of several celebrities.Ready to take her business to the next level,Abby has hired you to construct an accounting information system,which she wants modeled after her paper records.As you look over her records,you realize that some customers bought multiple statues at the same time.For example,Yasmeen Ghuari bought a Tin Man Status,a flying horseman statue,and a terrier statue.You realize that in these cases,a single written record will have to be translated into multiple sales records.This is an example of what type of problem in the existing records?

What is the difference in logical view and physical view?

A ________ is an abstract representation of a database's contents.

Abby Burke has created custom statues made out of scrap metal for over ten years.Abby has kept detailed records of every statue she has ever created.For every sale,she obtains the customer's name and address,a description of the statue,and a picture of the statue sold to the customer.Her unique style has recently attracted the attention of several celebrities.Ready to take her business to the next level,Abby has hired you to construct an accounting information system,which she wants modeled after her paper records.As you look over her records,you notice that some customer last names have different first names in different records.For example,R.Framington Farnsworth,Bob Farnsworth,and Sam Farnsworth all seem to be the same person.You explain to Abby that every customer must be identified by a unique customer number in the AIS.You are referring to the