(a)
To categorize following issue about Sarbanes Oxley audit of a financial services company into the suitable area specifications:
The issue is five
(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.
(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.
(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.
(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.
(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.
Want to see the full answer?
Check out a sample textbook solutionChapter 8 Solutions
Modern Database Management
- 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
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrPrinciples 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 LearningFundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningFundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning