1. One of the main functions of a database system is to provide timely answers to end users. True 2. Which of the following is a general guideline for creating and using indices. Do not use indices in small tables…
1. The developer used ____________SQL statements in the creation of the transaction database. One 2. A transaction is a logical unit of work that must be entirely completed or removed. True 3. The DBMS guarantees that the semantic meaning of…
1. Systems analysis establishes the need for an information system and its extent. True 2. The term “database development” is used to describe the process of database design and implementation. True 3. The Systems Development Life Cycle (SDLC) traces the…
1.A view is a virtual table based on a SELECT query. True 2. Authentication is the process the DBMS uses to verify that only registered users access the database. True 3. SQL supports the conditional execution of procedures (IF-THEN-ELSE statements)…
True 2. A(n) asterisk character is a symbol that can be used as a general substitute for other characters or commands. False 3. The COUNT function is designed to tally the number of non-null “values” of an attribute and is…
1.Normalization works through a series of stages called normal forms. True 2. Normalization is a process that is used for changing attributes to entities. False 3. In order to meet performance requirements, portions of the database design may need to…
True 2. The ____ constraint specifies whether each entity supertype occurrence must also be a member of at least one subtype. completeness 3. The relationships depicted within the specialization hierarchy are sometimes described in terms of “is-a” relationships. True 4.…
Week-2 Exam 1). __________ is generally given credit as the “father” of the field of organizational communication as we understand it today. Charles Redding 2). According to the Huffington Post, the number of __________ in the workforce has increased dramatically over…
Chapter 03 Use It 1). The following three tables make up a simple reservation system for a small campground. The database should allow for a camper to make multiple reservations for future dates and for a camping spot to have…
Week-2 Quiz 1). What step can be taken to evaluate the effectiveness of the security measures in place at an organization? Perform a vulnerability assessment. 2). Which term describes a legal agreement between partners establishing the terms, conditions, and expectations of the…
