Write definitions using your own words for the first 20 Key Terms on page 270 (C
ID: 3591146 • Letter: W
Question
Write definitions using your own words for the first 20 Key Terms on page 270 (Concepts of Database Management 8th Edition) at the end of Chapter 8. Don't just copy and paste the definition from the book! Please take your time and write it as you write your own assignment that you want 100 grades on it! The definition must be related to the same chapter in the book NOT GENERAL DEFINITION. Do it correctly or leave it to please! Hand writes/Picture is Not working, Please answer in a way that I can copy and paste it easily, and don't miss any key term. Thanks!
Key Terms
archive
context-sensitive help
data archive
denormalizing
Department of Defense (DOD) 5015.2 Standard
disaster recovery plan
exclusive lock
HIPAA
hot site
intranet
live system
local area network (LAN)
Patriot Act
Presidential Records Act
production system
RAID (redundant array of inexpensive/independent drives)
sandbox
Sarbanes-Oxley (SOX) Act
SEC Rule 17a-4
shared lock
Explanation / Answer
Archiving refers to the storage of historical records. It contains the data that has accumulated over the course of any organisation's lifetime and must be retained for use like legal complaince ,etc
Context-sensitive help means that if a user is having trouble and asks for help, the DBMS will provide assistance for that particular feature being used at the time the user asks for it.
Data archiving is the process of maoving the data that is no longer actively used into separate devices for long time retention. It refers to the data that is important to the organisation over the time like legal complaince and must be retained for future reference.
Denormalization converts a table which in 3rd normal form to either 1st or 2nd normal form. It increases data redundancy and data dependency issues, but also it can descrease the number of disk access for certain transactions which improves the performance.
In June 2002, the United States Department of Defense 5015.2-STD implemented the Design Criteria Standard for Electronic Records Management Software Applications. It is known as Department of Defense (DOD) 5015.2 Standard. This standard defines requirements for the management of records within the Department of Defense, which has become the accepted standard for many state, county, and local governments.
Disaster recovery plan specifies the emergency actions that are required to be followed to ensure that data is available all the time also in the event of any disaster. It ensures a plan to protect the storage devices of an organisation from failure or in case of any power loss , etc. At many places, a backup system is used when the primary system malfunctions.
Exclusive locks are a kind of locking system used in databae to lower concurrency in multi user system.When a statement modifies data, the transaction holds an exclusive lock on the data that prevents other transactions from accessing the same data. This lock is retained until the transaction holding the lock issues a commit or rollback.
HIPAA (Health Insurance Portability and Accountability Act of 1996) is United States legislation that provides data privacy and security provisions for safeguarding medical information.
A hot site is backup site of an organisation to which it can switch to in very less time.It contains hardware,software,data duplicated from the primary system so that it can be used in case of any emergencies.
Intranet is reffered to the internal network of any organisation which may consist of many local area networks and typically includes connections through one or more gateway computers to the outside internet.
Live system refers to operational system where the database runs. It has to me monitored continiously by the administrators and helps to upgrade or tune the system improving the performance.
Local area network (LAN) refers to the architecture of computers connected together to share hardware and software resources like database,etc. LAN architecture also suppports concurrent updates on the database.
The USA PATRIOT Act is an Act of Congress that was signed into law by President George W. Bush on October 26, 2001. With its ten-letter abbreviation (USA PATRIOT) expanded, the full title is "Uniting and Strengthening America by Providing Appropriate Tools Required to Intercept and Obstruct Terrorism Act of 2001".
The Presidential Records Act (PRA) of 1978, 44 U.S.C. 2201–2207, is an Act of Congress of the United States governing the official records of Presidents and Vice Presidents created or received after January 20, 1981, and mandating the preservation of all presidential records.
Production system refers to operational system where the database runs. It has to me monitored continiously by the administrators and helps to upgrade or tune the system improving the performance.
RAID (redundant array of inexpensive/independent drives) is used as part of disaster recovery management where data is replicated in multiple storage drives so that if any hard drive gets corrupted, the organisation will be able to continue with its normal operation.
Sandbox is a kind of development box where a developer can develop new program or modify existing program, on which DBA grants the access to that user, then tests the code.
Sarbanes–Oxley Act is an Act To protect investors by improving the accuracy and reliability of corporate disclosures made pursuant to the securities laws, and for other purposes.
SEC Rule 17a-4 is a regulation issued by the U.S. Securities and Exchange Commission pursuant to its regulatory authority under the US Securities Exchange Act of 1934 (Known simply as the "Exchange Act") which outlines requirements for data retention, indexing, and accessibility for companies which deal in the trade or brokering of financial securities such as stocks, bonds, and futures.
Shared lock in DBMS exist when two transactions are granted read access only on a database and no updating or deleting is allowed.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.