Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 8, Problem 8.72PAE
Program Plan Intro
(a)
To categorize following issue about Sarbanes Oxley audit of a financial services company into the suitable area specifications:
The issue is five
Program Plan Intro
(b)
To categorize following issue about Sarbanes Oxley audit of a financial services company into the suitable area specifications:
The given issue is Changes to database structure may not have management approval.
Program Plan Intro
(c)
To categorize following issue about Sarbanes Oxley audit of a financial services company into the suitable area specifications:
The given issue is Users continued to have database access even after termination.
Program Plan Intro
(d)
To categorize following issue about Sarbanes Oxley audit of a financial services company into the suitable area specifications:
The given issue is Backing up database on a regular basis using automated system.
Program Plan Intro
(e)
To categorize following issue about Sarbanes Oxley audit of a financial services company into the suitable area specifications:
The given issue is No logging has been enabled in DBMS in order to save space.
Program Plan Intro
(f)
To categorize following issue about Sarbanes Oxley audit of a financial services company into the suitable area specifications:
The given issue is there are been increase in usage volume of the main transaction table by 100% during last year. And at the same time, it is suggested by basic accounting data that number of customer transactions has been doubled.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Normalization is a concept that is carefully considered by database experts. As a database analyst or administrator, you may use this tool to design, verify scenarios, and optimize performance. In your perspective, what factors should be prioritized before normalization is initiated?
Normalization is an important concept for database professionals. Whether you are the designer, database analyst or administrator, it is useful for designing, situation verification as well as performance tuning. What are the basic issues to be aware of before carrying out the normalization process?
What are the primary considerations when designing an audit trail within a database?
Chapter 8 Solutions
Modern Database Management
Ch. 8 - Prob. 8.1RQCh. 8 - Prob. 8.2RQCh. 8 - Prob. 8.3RQCh. 8 - Prob. 8.4RQCh. 8 - Prob. 8.5RQCh. 8 - Prob. 8.6RQCh. 8 - Prob. 8.7RQCh. 8 - Prob. 8.8RQCh. 8 - Explain why you sometimes have to reserve much...Ch. 8 - Why are field values sometimes coded?
Ch. 8 - Prob. 8.11RQCh. 8 - Prob. 8.12RQCh. 8 - Explain why normalized relations may not comprise...Ch. 8 - Prob. 8.14RQCh. 8 - List three common situations that suggest that...Ch. 8 - Explain the reasons why some experts are against...Ch. 8 - Prob. 8.17RQCh. 8 - Prob. 8.18RQCh. 8 - Prob. 8.19RQCh. 8 - Prob. 8.20RQCh. 8 - Prob. 8.21RQCh. 8 - Prob. 8.22RQCh. 8 - One of the strongest recommendations regarding...Ch. 8 - Explain why an index is useful only if there is...Ch. 8 - Indexing can clearly be very beneficial. Why...Ch. 8 - Prob. 8.26RQCh. 8 - Prob. 8.27RQCh. 8 - Describe the role of data dictionary in the...Ch. 8 - Prob. 8.29RQCh. 8 - Prob. 8.30RQCh. 8 - Explain how creating a view may increase data...Ch. 8 - Prob. 8.32RQCh. 8 - Prob. 8.33RQCh. 8 - Prob. 8.34RQCh. 8 - Prob. 8.35RQCh. 8 - Prob. 8.36RQCh. 8 - Prob. 8.37RQCh. 8 - Prob. 8.38RQCh. 8 - Prob. 8.39RQCh. 8 - How can views be used as part of data security?...Ch. 8 - Prob. 8.41RQCh. 8 - Prob. 8.42RQCh. 8 - Consider the following two relations for...Ch. 8 - Prob. 8.44PAECh. 8 - Prob. 8.45PAECh. 8 - Prob. 8.46PAECh. 8 - Prob. 8.47PAECh. 8 - Suppose you are designing a default value for the...Ch. 8 - When a student has not chosen a major at a...Ch. 8 - Prob. 8.50PAECh. 8 - Prob. 8.51PAECh. 8 - Consider the relations in Problem and Exercise...Ch. 8 - Prob. 8.53PAECh. 8 - Prob. 8.54PAECh. 8 - Prob. 8.55PAECh. 8 - Prob. 8.56PAECh. 8 - Prob. 8.57PAECh. 8 - Consider the relations specified in Problem and...Ch. 8 - Prob. 8.59PAECh. 8 - Prob. 8.60PAECh. 8 - Prob. 8.61PAECh. 8 - Prob. 8.62PAECh. 8 - Prob. 8.63PAECh. 8 - Prob. 8.64PAECh. 8 - Problems and Exercises 8-65 through 8-68 refer to...Ch. 8 - Prob. 8.66PAECh. 8 - Problems and Exercises 8-65i5 through 8-68 refer...Ch. 8 - Refer to Figure 4-5 0. For each of the following...Ch. 8 - Prob. 8.69PAECh. 8 - Prob. 8.70PAECh. 8 - Prob. 8.71PAECh. 8 - Prob. 8.72PAECh. 8 - Prob. 8.73PAECh. 8 - Prob. 8.74PAECh. 8 - Prob. 8.75PAECh. 8 - Prob. 8.76PAECh. 8 - Prob. 8.77PAE
Knowledge Booster
Similar questions
- Access path A database table is composed of records and fields hold data. Data is stored in records. A field is a part of a record and contains a single piece of data for the subject of the record. The access path for finding the list of books is AUTHOR: AuthorID, Lname BOOKAUTHOR: AuthorID, ISBN BOOKS: Pubdate, ISBNarrow_forwardWhat are the importance of data validation. What happens if you do not ensure your data is correct prior to entering it in the database? What are some methods for data validation?arrow_forwardSpecialists in databases often face the challenge of normalization. It's helpful whether you're a database manager, analyst, or both. What do you think are the most important considerations to make before the normalization procedure starts?arrow_forward
- Topic: Database Design It is known that can use the DBMS system to create a surrogate primary key when there is a natural key. What implications does this have on the DB performancewhen searching the table for a specific column (such as ROOM). Hint: When the table is created, the DBMS setups the table to be able to search on the primary key very quickly. What if this Event table was used by a Corporate Hotel chain to keep track of every they have hosted over the past 30 years in all of their hotels across all their chains (i.e. 8000 locations, 5 events a week avg, 30 years of data ~62.4 million events)?arrow_forwardsafeguarding confidential information What are a database's most crucial features, such as its integrity and privacy? What are the responsibilities of the DBA manager with regard to the enforcement of these duties?arrow_forwardWhat tests database triggers and procedures?arrow_forward
- Explain the concept of database normalization. What are the primary benefits of normalizing a database?arrow_forwardThe consequences of failing to guarantee the consistency of your database's references. In what ways are blunders of various sorts possible?arrow_forwardFor database professionals, normalization is a crucial problem. It's a useful tool for all three, whether you're a database administrator, database analyst, or all three at once. What are some of the most crucial considerations, in your opinion, prior to the start of the normalization process?arrow_forward
- 1 Assume that your company has assigned you the responsibility of selecting the corporate DBMS. Develop a checklist of the technical issues and other aspects involved in the selection process. 2 Describe the activities that are typically associated with the design and implementation services of the DBA’s technical function. What technical skills are desirable in a DBA? 3. Why are testing and evaluation of the database and applications not done by the same people who are responsible for design and implementation? What minimum standards must be met during testing and evaluation? 4. Discuss the importance and characteristics of database backup and recovery procedures. Then describe the actions that must be detailed in backup and recovery plans. 5. Protecting data security, privacy, and integrity are important database functions. What activities are required in the DBA’s managerial role of enforcing those functions? 6. Explain the DBA’s managerial role in the definition and enforcement of…arrow_forwardIn the process of selecting a database management system (DBMS), what considerations are to be given priority?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:9781305082168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning