Database Design
Textbook Exam Questions
Course Introduction
Database Design is a foundational course that introduces students to the principles, techniques, and tools involved in creating efficient and effective database systems. Emphasizing relational database models, the course covers topics such as data modeling, entity-relationship diagrams, normalization, schema design, and SQL for data definition and manipulation. Students gain hands-on experience by designing, implementing, and managing databases to support real-world applications, with a focus on ensuring data integrity, minimizing redundancy, and optimizing performance. By the end of the course, students will have the practical skills required to assess user requirements, transform them into high-quality database solutions, and understand best practices for database security and maintenance.
Recommended Textbook
Database Principles Fundamentals of Design Implementation and Management international 10th
Available Study Resources on Quizplus
15 Chapters
1320 Verified Questions
1320 Flashcards
Source URL: https://quizplus.com/study-set/1336 Page 2
Chapter 1: The Database Approach
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26651
Sample Questions
Q1) Most data you encounter is best classified as ____.
A) structured
B) semistructured
C) unstructured
D) historical
Answer: B
Q2) ____ relates to the activities that make the database perform more efficiently in terms of storage and access speed.
A) Performance tuning
B) Database design
C) Query access
D) Database management
Answer: A
Q3) Historically, a manual file system was composed of a system of file folders and filing cabinets.
A)True
B)False
Answer: True
Q4) ____________________ is the result of processing raw data to reveal its meaning.
Answer: Information
To view all questions and flashcards with answers, click on the resource link above. Page 3
Chapter 2: Database Development Process
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26652
Sample Questions
Q1) Coding, testing, and debugging are part of the ____ phase of the SDLC.
A) planning
B) analysis
C) detailed systems design
D) implementation
Answer: D
Q2) Testing, fine-tuning, and evaluating the database and its applications are part of the ____ phase of the DBLC.
A) database initial study
B) database design
C) implementation and loading
D) testing and evaluation
Answer: D
Q3) In most modern relational DBMSs, a new database implementation requires the creation of special storage-related constructs to house the end-user tables.
A)True
B)False
Answer: True
To view all questions and flashcards with answers, click on the resource link above. Page 4
Chapter 3: Data Models
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26653
Sample Questions
Q1) In an SQL-based relational database, each table is dependent on another.
A)True
B)False
Answer: False
Q2) MySQL is an example of a(n) ____.
A) hierarchical model
B) file system data model
C) relational data model
D) XML data model
Answer: C
Q3) The hierarchical data model was developed in the ____.
A) 1960s
B) 1970s
C) 1980s
D) 1990s
Answer: A
Q4) In Chen notation, entities and relationships must be oriented horizontally.
A)True
B)False
Answer: False
To view all questions and flashcards with answers, click on the resource link above. Page 5
Chapter 4: Relational Model Characteristics
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26654
Sample Questions
Q1) In a database context, a(n) ____ indicates the use of different names to describe the same attribute.
A) entity
B) duplicate
C) synonym
D) homonym
Q2) ____ logic, used extensively in mathematics, provides a framework in which an assertion (statement of fact) can be verified as either true or false.
A) Predicate
B) Database
C) Relational
D) Index
Q3) Fortunately, the problems inherent in the ____________________ relationship can easily be avoided by creating a composite entity.
Q4) ____________________ relationships can be implemented by creating a new entity in 1:M relationships with the original entities.
Q5) A(n) ____________________ provides a detailed description of all tables found within the user/designer-created database.
To view all questions and flashcards with answers, click on the resource link above. Page 6
Chapter 5: Beginning Structured Query Language Sql
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26655
Sample Questions
Q1) Since computers identify all characters by their numeric codes, mathematical operators cannot be used to place restrictions on character-based attributes.
A)True
B)False
Q2) All SQL commands must be issued on a single line.
A)True
B)False
Q3) A table can be deleted from the database by using the ____ command.
A) DROP TABLE
B) DELETE TABLE
C) MODIFY TABLE
D) ERASE TABLE
Q4) The most recent fully approved version of standard SQL prescribed by the ANSI is
A) SQL-99
B) SQL-2003
C) SQL-4
D) SQL-07
Q5) How do you delete a table from the database? Provide an example.
To view all questions and flashcards with answers, click on the resource link above. Page 7
Chapter 6: Procedural Language Sql and Advanced Sql
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26656
Sample Questions
Q1) In an Oracle sequence, the ____________________ pseudo-column retrieves the current value of a sequence.
Q2) An implicit cursor is automatically created in procedural SQL when the SQL statement returns only one value.
A)True
B)False
Q3) The ____________________ outer join returns not only the rows matching the join condition (that is, rows with matching values in the common column), but also the rows in the left-side table with unmatched values in the right-side table.
Q4) Assume you are using the UNION ALL operator to combine the results from two tables with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2 table. How many records are returned when using the UNION ALL operator?
A) 7
B) 10
C) 15
D) 17
To view all questions and flashcards with answers, click on the resource link above.
Page 8
Chapter 7: Data Modeling With Entity Relationship
Diagrams
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26657
Sample Questions
Q1) The Crow's foot symbol with two parallel lines indicates ____ cardinality.
A) (0,N)
B) (1,N)
C) (1,1)
D) (0,1)
Q2) A ____ attribute can have only one value.
A) composite
B) simple
C) single-valued
D) multivalued
Q3) A(n) ____________________ attribute need not be physically stored within the database.
Q4) In the Chen model, a multivalued attribute is connected to the owning entity with a double line.
A)True
B)False
Q5) Cardinality expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 9
Chapter 8: Data Modeling Advanced Concepts
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26658
Sample Questions
Q1) The default comparison condition for the subtype discriminator attribute is the ____ comparison.
A) not equality
B) less than
C) greater than D) equality
Q2) One important inheritance characteristic is that all entity subtypes inherit their ____ key attribute from their supertype.
A) primary
B) natural
C) foreign
D) surrogate
Q3) Disjoint subtypes are also known as ____________________ subtypes.
Q4) The main concern with redundant relationships is that they remain ____________________ across the model.
Q5) Describe specialization and generalization.
Q6) Composite primary keys are particularly useful as identifiers of composite entities, where each primary key combination is allowed ____________________ in the M:N relationship.
To view all questions and flashcards with answers, click on the resource link above. Page 10
Chapter 9: Normalizing Database Designs
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26659
Sample Questions
Q1) With partial dependencies, data redundancies occur because every row entry requires duplication of data.
A)True
B)False
Q2) Normalization should be part of the design process.
A)True
B)False
Q3) Any attribute that is at least part of a key is known as a(n)
Q4) Describe a dependency diagram and explain its purpose.
Q5) A table that is in 1NF and includes no partial dependencies is said to be in ____.
A) BCNF
B) 2NF
C) 3NF
D) 4NF
Q6) All relational tables satisfy the ____________________ requirements.
Q7) A(n) ____________________ derives its name from the fact that a group of multiple entries of the same type can exist for any single key attribute occurrence.
Page 11
To view all questions and flashcards with answers, click on the resource link above.
Chapter 10: Distributed Databases
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26660
Sample Questions
Q1) The ____________________ commit protocol guarantees that if a portion of a transaction operation cannot be committed, all changes made at the other sites participating in the transaction will be undone to maintain a consistent database state.
Q2) ____ transparency allows a distributed database to be treated as a single logical database.
A) Distribution
B) Transaction
C) Failure
D) Performance
Q3) One of the advantages of a DDBMS is ____________________ operating cost.
Q4) One of the advantages of a DDBMS is improved communication.
A)True
B)False
Q5) A remote transaction, composed of several requests, may access data at multiple sites.
A)True
B)False
Q6) The ____________________ fragment condition indicates that each row is unique, regardless of the fragment in which it is located.
Page 12
To view all questions and flashcards with answers, click on the resource link above.
Chapter 11: Interacting With Databases Through the Web
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26661
Sample Questions
Q1) ____ is embedded inside an HTML page and is activated by triggering events such as clicking on a link.
A) A plug-in
B) A browser
C) Visual Basic
D) VBScript
Q2) Client-side extensions are available in various forms, such as ____.
A) COBOL
B) Java and JavaScript
C) Visual Basic .NET
D) Visor.Net
Q3) Extending the Web server functionality implies that the Web server and the Web-to-database middleware will properly communicate with each other.
A)True
B)False
Q4) ____________________ are objects that manage the connection with a data source and provide data to the consumers.
Q5) ODBC is ____________________'s implementation of a superset of the SQL Access Group CLI.
To view all questions and flashcards with answers, click on the resource link above. Page 13
Chapter 12: Database Administration and Security
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26662
Sample Questions
Q1) The DBA interacts with the end user by providing data and information support services to the organization's departments.
A)True
B)False
Q2) The selection of the DBMS ____________________ involves asking the question, "Are the company's needs better served by a relational, object-oriented, or object/relational DBMS?"
Q3) A(n) ________________________________________ provides a framework that includes the use of computerized, automated, and integrated tools such as a DBMS and CASE tools.
Q4) The DBA can use an audit log to automatically record a brief description of the database operations performed by the users.
A)True
B)False
Q5) User-access management is a subset of ____.
A) password protection
B) authorization management
C) data integrity
D) managerial control
To view all questions and flashcards with answers, click on the resource link above. Page 14
Chapter 13: Managing Transactions and Concurrency
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26663
Sample Questions
Q1) If T1 has not unlocked data item Y, T2 cannot begin; if T2 has not unlocked data item X, T1 cannot continue. Consequently, T1 and T2 each wait for the other to unlock the required data item. Such a deadlock is also known as a(n) ____________________.
Q2) A transaction is a ____ unit of work that must be either entirely completed or aborted.
A) timed
B) practical
C) logical
D) physical
Q3) The ____ manager is responsible for assigning and policing the locks used by the transactions.
A) transaction
B) database
C) lock
D) schedule
Q4) A shared lock produces no conflict as long as all the concurrent transactions are read-write only.
A)True
B)False
To view all questions and flashcards with answers, click on the resource link above. Page 15
Chapter 14: Managing Database and Sql Performance
Available Study Resources on Quizplus for this Chatper
70 Verified Questions
70 Flashcards
Source URL: https://quizplus.com/quiz/26664
Sample Questions
Q1) Most current-generation relational DBMSs perform automatic query optimization at the client end.
A)True
B)False
Q2) Indexes do not facilitate join operations.
A)True
B)False
Q3) The ____ must be set large enough to permit as many data requests to be serviced from cache as possible.
A) data cache
B) SQL cache
C) sort cache
D) optimizer mode
Q4) To work with the data, the DBMS must retrieve the data from the ____ and place it in the ____.
A) data files, procedure cache
B) data files, data cache
C) temporary files, RAM
D) temporary files, procedure cache
Q5) ____________________ is another name for table space.
Page 16
To view all questions and flashcards with answers, click on the resource link above.
Chapter 15: Databases for Decision Support
Available Study Resources on Quizplus for this Chatper
100 Verified Questions
100 Flashcards
Source URL: https://quizplus.com/quiz/26665
Sample Questions
Q1) ____________________ makes a copy of a table and places it in a different location to improve access time.
Q2) Normalizing fact tables improves data access performance and saves data storage space.
A)True
B)False
Q3) Computed or derived facts are sometimes called ____ to differentiate them from stored facts.
A) details
B) attributes
C) metrics
D) fact tables
Q4) A data mart is part of the "____" section of the business intelligence framework.
A) People
B) Management
C) Processes
D) Governance
Q5) What is a data mart? Why do some organizations prefer to create a data mart rather than a data warehouse?
To view all questions and flashcards with answers, click on the resource link above. Page 17