Info
Warning
Danger
/ Homework Answers / Accounting / 31.Many database systems include a feature that simplifies the creation

Question

31.Many database systems include a feature that simplifies the creation of reports by allowing users to specify the data elements desired and the format of the output. This feature is named the __________.

a)report writer

b)report generator

c)report creator

d)report printer

32.The abstract representation of the contents of a database is called the logical

a)data model.

b)data dictionary.

c)data relationship.

d)subschemas.

33.A database model that represents all data as stored in two-dimensional tables is the __________ model.

a)tuple

b)relational

c)hierarchy

d)object

34.Each row in a relational database's table is known as a 

a)data model

b)relation

c)schema

d)tuple

35.The attribute that can uniquely identify a specific row in a table is the

a)primary key

b)secondary key

c)foreign key

d)logical key

36.An attribute in a table that is a primary key in another table.

a)primary key

b)secondary key

c)foreign key

d)anomaly

37.Redundancy can be a major problem in the design and operation of relational databases.  If a database uses only one relation to store data, several problems may subsequently occur.  The problem of changes (or updates) to data values being incorrectly recorded is known as

a)an update anomaly.

b)an insert anomaly.

c)a delete anomaly.

d)a memory anomaly.

38.The potential inconsistency problem could arise when there are multiple occurrences of a data item in a database.  This is called the

a)update anomaly.

b)insert anomaly.

c)inconsistency anomaly.

d)integrity anomaly.

39.The problem of inability to add new data without violating the basic integrity of the database is referred to as the

a)update anomaly.

b)insert anomaly.

c)integrity anomaly.

d)add anomaly.

40.A relational database has been designed where the customer data is not maintained independently of sales invoice data.  This design weakness will most likely result in

a)an update anomaly.

b)an insert anomaly.

c)a delete anomaly.

d)no anomaly.

Solution
5 (1 Ratings )

Solved
Accounting 3 Months Ago 8 Views
This Question has Been Answered!
Premium Content -

Welcome Back!

ScholarOn has more then 20 Million answers, flashcards & more being added everyday!

or
Forgot?
Login
Don't have an account? Signup

Join ScholarOn

ScholarOn has more then 20 Million answers, flashcards & more being added everyday!

or
Signup
By registering, I agree to the Terms and Privacy Policies
Already have an account? Log in

Verify Your Email

Check your inbox & click on the link to activate your account.

Resend Email
Verification Mail Send Successfully. Please Check Your Email.

Forgot Password

Please enter your registered email to recieve the password reset link.

Send reset link
Already have an account? Log in
Did you know?

ScholarOn has more than 2 Million+ answers, textbook solutions & flashcards. Explore Now!

Let us boost your grade together!