Describe the different schemas involved in a database structure. What is the role of accountants in development of schemas?
What will be an ideal response?
Answer: A schema describes the logical structure of a database. There are three levels of schemas. First, the conceptual-level schema is an organization-wide view of the entire database listing all data elements and relationships between them. Second, an external-level schema is a set of individual user views of portions of the database, each of which is referred to as a subschema. Finally, an internal-level schema provides a low-level view of the database which includes descriptions about pointers, indexes, record lengths, etc. Accountants are primarily involved in the development of conceptual- and external-level schemas; however, database knowledgeable accountants may participate in developing an internal -level schema.
You might also like to view...
Independent frames of reference and organizational politics are the two primary barriers to cross-functional team integration. Two methods to facilitate cross-functional integration are _________ and ___________.
a. autonomous strategic behavior; induced strategic behavior b. incremental innovations; radical innovations c. bottom-up integration; top-down integration d. shared values; effective leadership
What is generally TRUE about class C SKUs in ABC analysis? They represent about:
A) 20 percent of all SKUs. B) 50 percent of all SKUs. C) 15 percent of the dollar usage. D) 50 percent of the dollar usage.