Data Modeling and Database Design Exam Bank
Course Introduction
This course provides an in-depth exploration of the principles and practices of data modeling and database design. Students will learn how to analyze information needs, develop conceptual, logical, and physical data models, and create efficient database structures using entity-relationship (ER) diagrams and normalization techniques. The course covers both relational and emerging database paradigms, addressing key topics such as data integrity, indexing, query optimization, and the use of SQL for implementation and management. Real-world case studies and hands-on projects enable students to apply theoretical concepts to design robust, scalable, and secure databases that support organizational objectives.
Recommended Textbook
Modern Database Management 10th Edition by Jeffrey A. Hoffer
Available Study Resources on Quizplus
14 Chapters
1571 Verified Questions
1571 Flashcards
Source URL: https://quizplus.com/study-set/528
2
Chapter 1: The Database Environment and Development Process
Available Study Resources on Quizplus for this Chatper
173 Verified Questions
173 Flashcards
Source URL: https://quizplus.com/quiz/9865
Sample Questions
Q1) Data redundancy is used to establish relationships between data but is never used to improve database performance.
A)True
B)False
Answer: False
Q2) The period that can be considered a "proof of concept" time was the: A) 1950s.
B) 1960s.
C) 1970s.
D) 1990s.
Answer: B
Q3) Development starts from scratch with the traditional file processing approach because new file formats,descriptions,and file access logic must be designed for each new program.
A)True
B)False
Answer: True
Q4) ________ increases the risk of inconsistency.
Answer: Redundancy
Page 3
To view all questions and flashcards with answers, click on the resource link above.
Chapter 2: Modeling Data in the Organization
Available Study Resources on Quizplus for this Chatper
121 Verified Questions
121 Flashcards
Source URL: https://quizplus.com/quiz/9866
Sample Questions
Q1) A logical representation of the data for an organization or for a business area is called a(n)________.
Answer: entity-relationship model
Q2) Some examples of attributes are: eye_color,weight,student_id,student.
A)True
B)False
Answer: False
Q3) An example of a term would be the following sentence: "A student registers for a course."
A)True
B)False
Answer: False
Q4) A fact is an association between two or more:
A) words.
B) terms.
C) facts.
D) nuggets.
Answer: B
Q5) A(n)________ entity type exists independently of other entity types.
Answer: strong
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: The Enhanced E-R Model and Business Rules
Available Study Resources on Quizplus for this Chatper
74 Verified Questions
74 Flashcards
Source URL: https://quizplus.com/quiz/9867
Sample Questions
Q1) Contrast the overlap rule to the disjoint rule.
Answer: The disjoint rule is used when you wish to specify that an entity instance can only be one type of subtype.For example,if a student could only be a graduate or undergraduate student,but not both.The overlap rule specifies that an entity instance could be one or more subtypes.For example,if an instance of a person supertype could be a faculty member as well as a student subtype,then we would use the overlap rule.
Q2) The overlap rule specifies that if an entity instance of the supertype is a member of one subtype,it can simultaneously be a member of two (or more)subtypes.
A)True
B)False
Answer: True
Q3) A(n)________ is a set of one or more entity types and associated relationships grouped into a single abstract entity type.
Answer: entity cluster
Q4) Describe how subtype discriminators are used when we have overlapping subtypes.
Answer: When we have overlapping subtypes,we need to create a composite subtype discriminator with boolean values.
To view all questions and flashcards with answers, click on the resource link above.
Chapter 4: Logical Database Design and the Relational Model
Available Study Resources on Quizplus for this Chatper
120 Verified Questions
120 Flashcards
Source URL: https://quizplus.com/quiz/9868
Sample Questions
Q1) A cascading delete removes all records in other tables associated with the record to be deleted.
A)True
B)False
Q2) The relational data model does at this time directly support subtype/supertype relationships.
A)True
B)False
Q3) A constraint between two attributes is called a(n):
A) functional relation.
B) attribute dependency.
C) functional dependency.
D) functional relation constraint.
Q4) An error or inconsistency resulting from redundancy in tables is called a(n)________.
Q5) List and explain all of the normal forms.
Q6) Discuss the various relational keys.
Q7) Associative entities are also called ________.
Q8) Sometimes,associative entities have ________ identifiers assigned to them. Page 6
Q9) A(n)________ is a set of values that may be assigned to an attribute.
To view all questions and flashcards with answers, click on the resource link above.
Page 7
Chapter 5: Physical Database Design and Performance
Available Study Resources on Quizplus for this Chatper
105 Verified Questions
105 Flashcards
Source URL: https://quizplus.com/quiz/9869
Sample Questions
Q1) One field or combination of fields for which more than one record may have the same combination of values is called a(n):
A) secondary key.
B) index.
C) composite key.
D) linked key.
Q2) While Oracle has responsibility for managing data inside a tablespace,the tablespace as a whole is managed by the: A) user.
B) database administrator.
C) application developer.
D) operating system.
Q3) One decision in the physical design process is selecting structures. A)True
B)False
Q4) Explain what primary,secondary and unique key indexes are.
Q5) A ________ is a named set of disk storage elements in which physical files for database tables may be stored.
Q6) Discuss the advantages and disadvantages of partitioning.
Page 8
To view all questions and flashcards with answers, click on the resource link above.
Chapter 6: Introduction to SQL
Available Study Resources on Quizplus for this Chatper
119 Verified Questions
119 Flashcards
Source URL: https://quizplus.com/quiz/9870
Sample Questions
Q1) The content of dynamic views is generated when they are referenced. A)True B)False
Q2) The ________ is a set of commands used to define a database.
Q3) The following two SQL statements will produce the same results. Select last_name,first_name from customer where credit_limit > 99 and credit_limit < 10001; Select last_name,first_name from customer where credit_limit between 100 and 10000; A)True
B)False
Q4) The SQL command used to populate tables is the INSERT command. A)True B)False
Q5) A database is maintained and queried using the data mapping language (DML). A)True B)False
Q6) Discuss when to use the group by clause.
Page 9
To view all questions and flashcards with answers, click on the resource link above.
Chapter 7: Advanced SQL
Available Study Resources on Quizplus for this Chatper
111 Verified Questions
111 Flashcards
Source URL: https://quizplus.com/quiz/9871
Sample Questions
Q1) SQL provides the ________ technique,which involves placing an inner query within the where or having clause of an outer query.
Q2) EXISTS takes a value of false if the subquery returns an intermediate result set.
A)True
B)False
Q3) It is better not to have a result set identified before writing group by and having clauses for a query.
A)True
B)False
Q4) While triggers do run automatically,________ do not.
Q5) ________ can be thought of as a special case of triggers.
Q6) Specifying the attribute names in the select statement will make it easier to find errors in queries and also correct for problems that may occur in the base system.
A)True
B)False
Q7) Explain how to combine queries using the UNION clause.
Q8) When a subquery is used in the FROM clause,it is called a(n)________.
Page 10
Q9) What is the difference between a trigger and a routine?
To view all questions and flashcards with answers, click on the resource link above.
Chapter 8: Database Application Development
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/9872
Sample Questions
Q1) HTML is an acronym for:
A) Hypertext Manipulation Language.
B) Hot Type Markup Language.
C) Hyperbolic Mechanical Language.
D) Hypertext Markup Language.
Q2) ________ is the process of assigning pieces of application code to clients or servers.
A) Application partitioning
B) Modularizing programs
C) Code distribution
D) Program breakup
Q3) The promise of Web services is the development of a standardized communication system using ________.
A) HTML
B) XST
C) XML
D) XPath
Q4) XML uses bcode,long commands embedded in quotes,to characterize data.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 11
Chapter 9: Data Warehousing
Available Study Resources on Quizplus for this Chatper
117 Verified Questions
117 Flashcards
Source URL: https://quizplus.com/quiz/9873
Sample Questions
Q1) The need for data warehousing in an organization is driven by its need for an integrated view of high-quality data.
A)True
B)False
Q2) An event is a database action that results from a transaction.
A)True
B)False
Q3) The first requirement for building a user-friendly interface is a set of metadata that describes the data in the data mart in business terms that users can easily understand.
A)True
B)False
Q4) An independent data mart is filled with data extracted from the operational environment without the benefit of a data warehouse.
A)True
B)False
Q5) Independent data marts do not generally lead to redundant data and efforts.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 12
Chapter 10: Data Quality and Integration
Available Study Resources on Quizplus for this Chatper
102 Verified Questions
102 Flashcards
Source URL: https://quizplus.com/quiz/9874
Sample Questions
Q1) Which of the following is a basic method for single field transformation?
A) Table lookup
B) Cross-linking entities
C) Cross-linking attributes
D) Field-to-field communication
Q2) Data may be loaded from the staging area into the warehouse by following:
A) SQL Commands (Insert/Update).
B) special load utilities.
C) custom-written routines.
D) all of the above.
Q3) Data are moved to the staging area before extraction takes place.
A)True
B)False
Q4) ________ duplicates data across databases.
A) Data propagation
B) Data duplication
C) Redundant replication
D) A replication server
Q5) What is a field-level transformation and what different types exist?
Q6) Sound data ________ is a central ingredient of a data quality program.
Page 13
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Data and Database Administration
Available Study Resources on Quizplus for this Chatper
116 Verified Questions
116 Flashcards
Source URL: https://quizplus.com/quiz/9875
Sample Questions
Q1) A ________ measures or detects personal characteristics such as fingerprints.
Q2) Forward recovery is faster than restore/rerun because:
A) transactions do not have to be repeated.
B) security can be avoided.
C) images are mirrored.
D) systems are more complete.
Q3) Loss of data integrity does not impact the quality of data in a database.
A)True
B)False
Q4) Which of the following is NOT an area of concern when trying to maintain a well-tuned database?
A) Memory usage
B) CPU usage
C) Input/output contention
D) User interface design
Q5) A(n)________ is a facility by which the DBMS refuses to accept any new transactions.
Q6) The ________ allows the DBMS to restore the database to a correct condition and restart processing transactions.
Q7) What is a journalizing facility?
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 12: Distributed Databases
Available Study Resources on Quizplus for this Chatper
109 Verified Questions
109 Flashcards
Source URL: https://quizplus.com/quiz/9876
Sample Questions
Q1) ________ is an alternative to the use of locks in a distributed database.
Q2) ________ is the ability to grow,reduce in size,and become more heterogeneous as the needs of the business change.
Q3) Discuss the different types of data replication.
Q4) The purpose of time-stamping is to allow transactions to be processed in parallel.
A)True B)False
Q5) Failure transparency is a design goal for distributed databases that guarantees that all the actions associated with a transaction are either committed or none of them are committed.
A)True B)False
Q6) What is horizontal and vertical partitioning?
Q7) A distributed unit of work allows various statements within a unit of work to refer to ________ remote DBMS locations.
Q8) What is the difference between a local transaction and a global transaction?
Q9) What are the three steps that a distributed DBMS uses to develop a query plan?
Q10) Describe the range of distributed database environments
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 13: Object-Oriented Data Modeling
Available Study Resources on Quizplus for this Chatper
91 Verified Questions
91 Flashcards
Source URL: https://quizplus.com/quiz/9877
Sample Questions
Q1) A(n)________ operation creates a new instance of a class.
Q2) Which of the following operations does not alter the state of an object?
A) Update
B) Query
C) Constructor
D) None of the above
Q3) A(n)________ operation does not alter the state of an object.
Q4) What is the difference between a class and an object?
Q5) Aggregation is a(n)________ relationship between a component object and an aggregate object.
Q6) When an operation may apply to two or more classes in different ways,this is known as ________.
Q7) What is encapsulation?
Q8) A ________ is the implementation of an operation.
A) meta-operation
B) method
C) query
D) constructor
Page 16
Q9) What is the difference between an abstract class and a concrete class?
Q10) What is polymorphism?
To view all questions and flashcards with answers, click on the resource link above.
Page 17
Chapter 14: Using Relational Databases to Provide Object
Persistence
Available Study Resources on Quizplus for this Chatper
113 Verified Questions
113 Flashcards
Source URL: https://quizplus.com/quiz/9878
Sample Questions
Q1) All of the following are object-relational mapping frameworks EXCEPT: A) (N)Hibernate.
B) EclipseLink
C) JPA.
D) Topdog.
Q2) An inheritance structure can be represented in at least four ways in a database. A)True
B)False
Q3) Object-relational mapping frameworks move the management of ________ outside of the core structure of the object-oriented applications.
Q4) ORM frameworks provide a layer of ________ that separates the object-oriented applications from the details of the database implementation.
Q5) All of the following are typical responsibilities of the ORM framework EXCEPT: A) generating SQL code for database access.
B) query language.
C) distributing code related to database access.
D) providing a layer of abstraction.
Q6) ORM frameworks have the responsibility for generating ________.
Page 18
Q7) Object-relational mapping frameworks provide the highest level of ________.
To view all questions and flashcards with answers, click on the resource link above.