Exam 4: Relational Databases

The document that shows the items stored in a file,including the order and length of the data fields and the type of data stored is called

List the four DBMS "languages" and describe who uses each and for what purpose.

Inability to add new data to a database without violating the basic integrity of the database is referred to as the

Which statement below concerning the database management system (DBMS)is false?

The technique of using queries to investigate hypothesized relationships among data is called

Describe the reason why it is acceptable to have null foreign key,but it is unacceptable to have a null primary key.Use the concept of entity integrity rule and referential integrity rule in your answer.

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?

Identify the aspect of a well-structured database that is incorrect.

________ is a feature in many database systems that simplifies the creation of reports by allowing users to specify the data elements desired and the format of the output.

Identify one potential drawback in the design and implementation of database systems for accounting.

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

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

Describe the differences between the data definition language (DDL),data manipulation language (DML),and the data query language (DQL).

Mary Lamb is an insurance sales representative.Her company has provided her with a laptop computer that uses wireless connectivity to access the accounting information system from virtually anywhere in the country.She has access to view customer and insurance product information.She also has access that allows her to enter and cancel customer orders.The permissions for Mary (and other sales reps)define a ________ in the company's database management system.

In the Customer table above,"Customer #" is best described as

In the database design approach known as normalization,the first assumption made about data is

Which of the statements below is incorrect?

Creating an empty table in a relational database requires use of the ________,and populating that table requires the use of ________.

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

The problem of changes being incorrectly recorded in a database is known as