Accounting Information Systems

10th Edition
Hall + 1 other
Publisher: Cengage Learning,
ISBN: 9781337619202



Accounting Information Systems

10th Edition
Hall + 1 other
Publisher: Cengage Learning,
ISBN: 9781337619202
Chapter 9, Problem 6RQ
Textbook Problem

Explain the relationship between the three levels of the data definition language. As a user, which level would you be most interested in?

To determine

Describe the relationship between the three levels of the data definition language. Also, identify the level in which users are interested in.

Explanation of Solution

Database Management:

Database management refers to management of databases held within an organization. Database management includes ensuring integrity, completeness, accessibility, and accuracy of data.

Data definition language (DDL) provides the description of the physical database to the database management system. Names of data elements, records, and files and their relationships are contained in the DDL.

The relationship between the three levels of views provided by DDL, are listed as follows:

  • Internal view: In this view, physical data is arranged and relationships and sequence of the data is provided. This view is one step away from physical database. There can only be a single internal view of the database...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Chapter 9 Solutions

Accounting Information Systems
Show all chapter solutions
Ch. 9 - What is an entity?Ch. 9 - Give an application for a replicated database.Ch. 9 - Discuss and give an example of the following types...Ch. 9 - Distinguish between association and cardinality.Ch. 9 - Explain how a separate linking table works in a...Ch. 9 - What are the four characteristics of properly...Ch. 9 - What do the relational features restrict, project,...Ch. 9 - What are the conditions for third normal form...Ch. 9 - Explain how the SELECT and WHERE commands help a...Ch. 9 - What is a data model?Ch. 9 - How can a poorly designed database result...Ch. 9 - What is a user view?Ch. 9 - Does a user view always require multiple tables to...Ch. 9 - What three conditions must valid entities meet?Ch. 9 - Can two different entities have the same defining...Ch. 9 - In the flat-file data management environment,...Ch. 9 - Discuss the potential aggravations you might face...Ch. 9 - Discuss why control procedures over access to the...Ch. 9 - What is the relationship between a database table...Ch. 9 - Explain how linkages between relational tables are...Ch. 9 - Explain the purpose of an ER diagram in database...Ch. 9 - SQL has been said to place power in the hands of...Ch. 9 - Discuss the importance of the role of the database...Ch. 9 - As users determine new computer application needs,...Ch. 9 - Why is a separate link table required when an M:M...Ch. 9 - As an accountant, why would you need to be...Ch. 9 - How does a database lockout contribute to...Ch. 9 - How does concurrency control contribute to...Ch. 9 - In a relational database environment, certain...Ch. 9 - Explain how to link tables in a 1:1 cardinality....Ch. 9 - Discuss the accounting implications of the update,...Ch. 9 - Give three examples that illustrate how...Ch. 9 - Discuss the key factors to consider in determining...Ch. 9 - Distinguish between a database lockout and a...Ch. 9 - Replicated databases create considerable data...Ch. 9 - Of the following, select the attribute that would...Ch. 9 - The advantages to using a partitioned database...Ch. 9 - A partial dependency a. is the result of...Ch. 9 - Repeating group data a. cannot exist in tables...Ch. 9 - What term describes the following data items: part...Ch. 9 - One of the first steps in the creation of a...Ch. 9 - Entities in a data model a. may contain zero or...Ch. 9 - Which of the following is least likely to be an...Ch. 9 - Partitioned databases are most effective when a....Ch. 9 - Which of the following is true about a transitive...Ch. 9 - The installation of a database management system...Ch. 9 - Which of the following describe best the functions...Ch. 9 - Database currency is achieved by a. implementing...Ch. 9 - Which of the following is true? a. Each view...Ch. 9 - Which of the following is true? a. Linking I:M...Ch. 9 - Which of the following is true? a. User views...Ch. 9 - Which of the following statements is not true? a....Ch. 9 - The data attributes that a particular user has...Ch. 9 - The Mega Supply Corporation has three divisions:...Ch. 9 - DBMS VERSUS FLAT-FILE PROCESSING Werner...Ch. 9 - Lesters Rentals is located in Cincinnati, Ohio....Ch. 9 - Using the view for a veterinarian practice...Ch. 9 - How is a lockout different from a deadlock? Give...Ch. 9 - Premium Garden Products (PGP) supplies gardening...Ch. 9 - DISTRIBUTED DATABASESREAD ONLY The XYZ Company is...Ch. 9 - DISTRIBUTED DATABASESTRANSACTION PROCESSING The...Ch. 9 - A book checkout report for a library is shown in...Ch. 9 - A college bookstore maintains all of its records...Ch. 9 - Prepare the base tables, in third normal form,...Ch. 9 - Prepare the base tables, in third normal form,...Ch. 9 - Prepare the 3NF base tables needed to produce the...Ch. 9 - Acme Plywood Company uses the purchase order shown...Ch. 9 - Solve this problem per the text in the diagram for...Ch. 9 - The diagram labeled problem 16 presents a partial...Ch. 9 - Refer to the entity relationship diagram in...Ch. 9 - Prepare an entity relationship diagram for the...Ch. 9 - Employees at the Harvest Equipment Company record...Ch. 9 - DATA MODELINGFIXED ASSET Procedures Classic...Ch. 9 - DATA MODELINGGENERAL LEDGER UPDATE Required...Ch. 9 - Given the following business rules, construct an...

Additional Business Textbook Solutions

Find more solutions based on key concepts
Show solutions add
What are the four common types of publicity?

Foundations of Business (MindTap Course List)

What is a partial dependency?

Accounting Information Systems

Why is a declining margin of safety over a period of time an issue of concern to managers?

Managerial Accounting: The Cornerstone of Business Decision-Making

What is an opportunity cost? How is this concept used in TVM analysis, and where is it shown on a time line? Is...

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)

How often must an employer file Form 941?


Identify eight forms and sources of waste.

Cornerstones of Cost Management (Cornerstones Series)