Fundamentals of Database Design Study Guide Questions

Course Introduction

Fundamentals of Database Design introduces students to the principles and techniques required to design robust, efficient, and scalable databases. The course covers essential topics such as data modeling, relational database structures, normalization, entity-relationship (ER) diagrams, and the use of Structured Query Language (SQL) for data definition and manipulation. Students will explore best practices in database schema development, integrity constraints, and indexing, while also gaining practical experience through hands-on projects. By the end of the course, participants will be equipped with the foundational knowledge necessary to design and implement effective database solutions for a variety of applications.

Recommended Textbook

Concepts of Database Management 7th Edition by Philip J. Pratt

Available Study Resources on Quizplus

9 Chapters

524 Verified Questions

524 Flashcards

Source URL: https://quizplus.com/study-set/1914 Page 2

Chapter 1: Introduction to Database Management

Available Study Resources on Quizplus for this Chatper

50 Verified Questions

50 Flashcards

Source URL: https://quizplus.com/quiz/38174

Sample Questions

Q1) A DBMS lets you assign users to ____.

A)groups

B)classes

C)attributes

D)clusters

Answer: A

Q2) A relationship is an association between attributes.

A)True

B)False

Answer: False

Q3) Popular ____ include Access,Oracle,DB2,MySQL,and SQL Server.

A)E-R diagrams

B)DBAs

C)DBMSs

D)data files

Answer: C

Q4) Sharing data is one advantage of database processing.

A)True

B)False

Answer: True

To view all questions and flashcards with answers, click on the resource link above. Page 3

Chapter 2: The Relational Model 1: Introduction, QBE, and Relational Algebra

Available Study Resources on Quizplus for this Chatper

50 Verified Questions

50 Flashcards

Source URL: https://quizplus.com/quiz/38175

Sample Questions

Q1) When a structure satisfies all the properties of a relation except for the first item-in other words,some entries contain repeating groups and thus are not single-valued-it is referred to as a(n) ____________________.

Answer: unnormalized relation

Q2) To find the total of all customers' balances,use the ____________________ function.

Answer: SUM sum

Q3) In a relation,the order of rows is important.

A)True

B)False

Answer: False

Q4) In a relation,the order of the columns is immaterial. A)True

B)False

Answer: True

Q5) To list the records in a query's results in a particular order,you need to ____________________ the records.

Answer: sort

To view all questions and flashcards with answers, click on the resource link above. Page 4

Chapter 3: The Relational Model 2: SQL

Available Study Resources on Quizplus for this Chatper

74 Verified Questions

74 Flashcards

Source URL: https://quizplus.com/quiz/38176

Sample Questions

Q1) In MySQL,the ____ is used as a wildcard to represent any collection of characters.

A)asterisk (*)

B)underscore (_)

C)percent sign (%)

D)question mark (?)

Answer: C

Q2) One common restriction placed on table and column names by DBMSs is that names can contain only letters,numbers,and ____________________.

Answer: underscores

Q3) When rows are grouped,____.

A)the totals appear with the rows

B)the rows appear in order

C)no output is produced

D)one line of output is produced for each group

Answer: D

Q4) The ____________________ data type stores integers,but uses less space than INTEGER.

Answer: SMALLINT

To view all questions and flashcards with answers, click on the resource link above. Page 5

Chapter 4: The Relational Model 3: Advanced Topics

Available Study Resources on Quizplus for this Chatper

50 Verified Questions

50 Flashcards

Source URL: https://quizplus.com/quiz/38177

Sample Questions

Q1) The following command will enable Jones to retrieve data from the Customer table,but not to take any other action: GRANT SELECT ON Customer TO Jones ; A)True

B)False

Q2) Essentially,setting the value in a given field to ____ is similar to not entering a value in it at all.

A)0

B)nil

C)blank

D)null

Q3) Views cannot be used to examine table data.

A)True

B)False

Q4) In SQL,you specify referential integrity using a(n) ____________________ clause in either the CREATE TABLE or ALTER TABLE commands.

Q5) A stored procedure is placed on a client computer.

A)True B)False

Q6) ____________________ is the prevention of unauthorized access to the database.

Page 6

To view all questions and flashcards with answers, click on the resource link above.

Chapter 5: Database Design 1: Normalization

Available Study Resources on Quizplus for this Chatper

50 Verified Questions

50 Flashcards

Source URL: https://quizplus.com/quiz/38178

Sample Questions

Q1) Another name for a nonkey column is a ____.

A)nonkey attribute

B)key attribute

C)nonkey row

D)key table

Q2) A table is in fourth normal form when it is in third normal form and there are no

A)alternate dependencies

B)partial dependencies

C)multivalued dependencies

D)primary dependencies

Q3) Any column or collection of columns that determines another column is called a(n)

Q4) Discuss how candidate keys,primary key,and alternate keys are related.

Q5) Second normal form can be defined as a table that is in first normal form but that contains no ____.

A)partial dependencies

B)alternate keys

C)nonkey columns

D)interrelation constraints

To view all questions and flashcards with answers, click on the resource link above. Page 7

Chapter 6: Database Design 2: Design Method

Available Study Resources on Quizplus for this Chatper

75 Verified Questions

75 Flashcards

Source URL: https://quizplus.com/quiz/38179

Sample Questions

Q1) On an E-R diagram,____________________ entities have rounded corners.

Q2) The simplest way to implement a one-to-one relationship is to treat it as a one-to-many relationship.

A)True

B)False

Q3) The crucial issue in making the determination between a single many-to-many-to-many relationship and two (or three) many-to-many relationships is the ____.

A)independence

B)data dependence

C)redundancy

D)cardinality

Q4) Convert the following table to first normal form: Branch (BranchNum ,BranchName,(BookCode,Title,CopyNum,Quality,Price) )

A)Branch (BranchNum,BranchName) Book (BookCode ,Title,CopyNum)

B)Branch (BranchNum,BranchName)

C)Book (BookCode,Title,Copynum)

D)Branch (BranchNum,BranchName, BookCode ,Title, CopyNum ,Quality,Price)

Q5) The style of E-R diagram used in the text is ____________________.

To view all questions and flashcards with answers, click on the resource link above. Page 8

Chapter 7: Dbms Functions

Available Study Resources on Quizplus for this Chatper

50 Verified Questions

50 Flashcards

Source URL: https://quizplus.com/quiz/38180

Sample Questions

Q1) Additional disk and memory space are not required to store timestamp values.

A)True

B)False

Q2) When the DBMS locks more rows and releases none of the locks,this is called an expanding phase.

A)True

B)False

Q3) ____ denies access by other users to data while the DBMS processes one user's updates to the database.

A)Timestamping

B)Committing

C)Journaling

D)Locking

Q4) ____ contain information about table relationships,views,indexes,users,privileges,and replicated data.

A)Datalists

B)Catalogs

C)Workgroups

D)Journals

Q5) What is two-phase locking?

To view all questions and flashcards with answers, click on the resource link above. Page 9

Chapter 8: Database Administration

Available Study Resources on Quizplus for this Chatper

50 Verified Questions

50 Flashcards

Source URL: https://quizplus.com/quiz/38181

Sample Questions

Q1) After the database designers complete the information-level design,the DBA does the ____-level design.

A)physical

B)information

C)logical

D)graphical

Q2) Which of the following DBMS evaluation categories does the following question relate to: What is the unit that may be locked and are exclusive locks the only ones permitted?

A)Concurrent update

B)Data recovery

C)Data dictionary

D)Security

Q3) To protect an organization's data against physical damage,the DBA creates and implements backup and recovery procedures as part of a disaster recovery plan.

A)True

B)False

Q4) ____________________ is the prevention of unauthorized access,either intentional or accidental,to a database.

To view all questions and flashcards with answers, click on the resource link above. Page 10

Chapter 9: Database Management Approaches

Available Study Resources on Quizplus for this Chatper

75 Verified Questions

75 Flashcards

Source URL: https://quizplus.com/quiz/38182

Sample Questions

Q1) With respect to the definition of data warehouse,____ means that the data is read-only.

A)time-variant

B)integrated

C)nonvolatile

D)subject-oriented

Q2) A(n) ______________________________ is one in which data and the actions that operate on the data are encapsulated into objects.

Q3) In a three-tier client/server architecture,the clients perform the presentation functions,a database server performs the database functions,and separate computers called ____________________ perform the business functions and serve as an interface between clients and the database server.

Q4) What are the advantages of distributed databases?

Q5) In objected-oriented DBMSs,the actions defined for a class are known as macros.

A)True

B)False

Q6) Discuss the differences between how client-side extensions and server-side extensions are created and executed,including the kinds of languages used to create them.

Page 11

To view all questions and flashcards with answers, click on the resource link above.