Exam 4: Relational Databases

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

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

Identify one potential outcome of the insert anomaly.

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

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?

Using the database depicted above,in the Sales table,"Customer #" 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.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

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

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

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 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?

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

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

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

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?

What is the difference in logical view and physical view?

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

________ in a well-structured relational database.

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

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