1. What is the result of redundant data in the database? Data anomalies that lead to data inconsistencies 2. Which of the following is not a function of a DBMS? User management 3. Why is identifying and documenting business rules…
Think about some of the pieces, are they just data? Or are they put into a meaningful context? Are they something that are known? Listed, are some of the things that you may do when you register/travel for a conference.…
1. Business intelligence is a framework that allows a business to transform data into information, information into Remember, and Remember into wisdom. True 2. Analyzing the company data can provide insightful information about short term tactical evaluations. True 3. The…
1. A distributed database management system (DDBMS) governs the storage and processing of logically related data over interconnected computer systems. True 2. Vertical fragmentation refers to the division of a relation into attribute (column) subsets. True 3. A distributed data…
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…
