Database Systems Analysis and Design
Pre-Test Questions
Course Introduction
Database Systems Analysis and Design introduces students to the fundamental concepts, methodologies, and tools essential for modeling, designing, implementing, and managing relational database systems. The course covers requirements analysis, data modeling with Entity-Relationship and Unified Modeling Language (UML) diagrams, normalization techniques to optimize data integrity, and the use of Structured Query Language (SQL) for data manipulation and retrieval. Students will explore the principles of database architecture, transaction management, security, and the lifecycle of database development, while engaging in practical exercises to design and implement database solutions for real-world scenarios.
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) Explain why it is better to try to control redundancy rather than eliminate it. Answer: Although eliminating redundancy is the ideal,it is not always possible. Sometimes,for reasons having to do with performance,you might choose to introduce a limited amount of redundancy into a database. However,even in these cases,you would be able to keep the redundancy under tight control,thus obtaining the same advantages. This is why it is better to say that you control redundancy rather than eliminate it.
Q2) A relationship is an association between attributes.
A)True
B)False
Answer: False
Q3) Eliminating redundancy is always possible when using a database approach. A)True
B)False
Answer: False
Q4) In an E-R diagram,____________________ represent relationships between connected entities.
Answer: lines
Q5) In an E-R diagram,____________________ represent entities.
Answer: rectangles
3
To view all questions and flashcards with answers, click on the resource link above.
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) What is the difference between an AND criterion and an OR criterion? How is each criterion created in QBE?
Answer: In an AND criterion,both criteria must be True for the compound criterion to be True. In an OR criterion,the overall criterion is True if either of the individual criteria is True. In QBE,to create an AND criterion,place the criteria for multiple fields on the same Criteria row in the design grid; to create an OR criterion,place the criteria for multiple fields on different Criteria rows in the design grid.
Q2) Using the product operator,if table A has 4 rows and table B has 4 rows,the number of rows in the product of these two tables is ____.
A)4
B)8 C)16
D)256
Answer: C
Q3) QBE is a visual approach to writing queries.
A)True
B)False
Answer: True
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) What are some common restrictions place on table and column names by DBMSs?
Answer: Some common restrictions are: 1. The names cannot exceed 18 characters.2. The names must start with a letter.3. The names can contain only letters,numbers,and underscores.4. The names cannot contain spaces.
Q2) Based on the code above,list the number,name,and available credit for all customers with credit limits that exceed their balances.
A)SELECT CustomerNum,CustomerName AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ;
B)SELECT CustomerNum,CustomerName,CreditLimit AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ;
C)SELECT CustomerNum,CustomerName,Balance AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ;
D)SELECT CustomerNum,CustomerName,CreditLimit-Balance AS AvailableCredit FROM Customer WHERE CreditLimit>Balance ;
Answer: D
Q3) You use the SQL ____________________ command to create a table by describing its layout.
Answer: CREATE TABLE
To view all questions and flashcards with answers, click on the resource link above.
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 SQL command for deleting the Warehouse field from the Part table is ____.
A)ALTER TABLE Part DROP COLUMN Warehouse ;
B)ALTER Part DROP Warehouse ;
C)ALTER Part DELETE Warehouse ;
D)ALTER TABLE DELETE Warehouse ;
Q2) ____________________ is the rule that no field that is part of the primary key may accept null values.
Q3) To create an index for the Customer table named RepBal with the keys RepNum and Balance and with the balances listed in descending order,the command is ____.
A)CREATE INDEX RepBal ON Customer (RepNum,Balance) ;
B)CREATE INDEX RepBal Customer (RepNum DESC) ;
C)CREATE INDEX ON Customer (RepNum,Balance ASC) ;
D)CREATE INDEX RepBal ON Customer (RepNum,Balance DESC) ;
Q4) Access has a tool called the ____________________,which allows you to easily print detailed documentation concerning any table,query,report,form,or other object in the database.
Q5) Views cannot be used to examine table data.
A)True B)False
To view all questions and flashcards with answers, click on the resource link above. Page 6
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) By converting a given collection of tables to an equivalent third normal form collection of tables,you remove any problems arising from ____________________ dependencies.
Q2) A table that contains a repeating group is called a(n) ____.
A)dependent relation
B)unnormalized relation
C)nominal relation
D)non-nominal relation
Q3) By splitting relations to achieve third normal form tables,you create the need to express a(n) ____________________ constraint,a condition that involves two or more relations.
Q4) A column B is ____________________ on another column A if each value for A in the database is associated with exactly one value of B.
Q5) In a table with columns A,B,and C,there is a(n) ____________________ dependence of column B on column A if each value for A is associated with a specific collection of values for B and,further,this collection is independent of any values for C.
Q6) Describe the procedure for converting a table to the third normal form.
Q7) Discuss how candidate keys,primary key,and alternate keys are related.
Page 7
To view all questions and flashcards with answers, click on the resource link above.
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) To obtain information about ____________________ you might ask users questions such as: "If you know a particular employee number,can you establish other information,such as employee name?"
Q2) The second step in creating a user view is to normalize the tables.
A)True
B)False
Q3) On an E-R diagram,the number closest to the relationship represents ____ cardinality.
A)maximum
B)minimum
C)midvalue
D)largest
Q4) An alternative to the primary key of a table is listed with the ____ abbreviation in DBDL.
A)SK
B)FK
C)PK
D)AK
Q5) In the ____________________ design method,specific user requirements are synthesized into a design.
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) ____ identify users by physical characteristics such as fingerprints,voiceprints,handwritten signatures,and facial characteristics.
A)Passwords
B)Visualizations
C)Econometrics
D)Biometrics
Q2) One strategy to manage deadlocks is to let them occur and then have the DBMS detect and break any deadlock.
A)True
B)False
Q3) ____________________ key constraints are governed by entity integrity and enforce the uniqueness of the primary key.
Q4) ____ contain information about table relationships,views,indexes,users,privileges,and replicated data.
A)Datalists
B)Catalogs
C)Workgroups
D)Journals
Q5) ____________________ involves maintaining a log of all updates to the database.
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) Another term for production system is the sandbox.
A)True
B)False
Q2) The ____________________ Act of 2002 is a federal law that specifies data retention and verification requirements for public companies,requires CEOs and CFOs to certify financial statements,and makes it a crime to tamper with financial records.
Q3) ____________________ is the prevention of unauthorized access,either intentional or accidental,to a database.
Q4) If a DBMS lacks essential security features,the DBA might create or purchase special security programs that provide the missing features.
A)True
B)False
Q5) QBE is an example of a nonprocedural language.
A)True
B)False
Q6) SQL is an example of a procedural language.
A)True
B)False
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) To execute the steps in a method,the user sends a(n) ____________________ to the object.
Q2) On a client/server network,the server is a computer that provides data to the clients.
A)True
B)False
Q3) ____ implies that no site should depend on another site to perform its database functions.
A)No reliance on a central site
B)Local autonomy
C)Continuous operation
D)Fragmentation transparency
Q4) A distributed database is a single logical database that is physically divided among computers at several sites on a network.
A)True
B)False
Q5) Web pages that display the same content for all Web clients are called ____________________ Web pages.
Q6) Explain the difference between a Web page,a Web server,and a Web client.
To view all questions and flashcards with answers, click on the resource link above. Page 11