31 Questions
Which informal measure of quality for relation schema design focuses on the possibility of generating spurious tuples?
The possibility of generating spurious tuples
What is the focus of First Normal Form (1NF) in relational database design?
Ensuring each attribute contains atomic values
Which concept addresses the issue of redundant values in tuples and update anomalies?
Normalization
What is the main focus of Boyce-Codd Normal Form (BCNF) in relational database design?
Addressing functional dependences
Which concept deals with the definitions, inference rules, and closure of attribute sets in relational databases?
Functional dependences
What is the primary objective of Third Normal Form (3NF) in relational database design?
Addressing functional dependences
According to the guideline, how should entity sets and relationship sets be mapped to relation schemas?
Map each entity set to a relation and each relationship set to a relation separately
Why is the 'EMP_DEPT' relation considered poor design?
The attributes' semantics are not clear
What is the primary reason for data redundancy issues in the 'EMP_DEPT' relation?
Repeating attribute values for every employee in the same department
What is the difficulty associated with inserting a new department that has no employees yet in the 'EMP_DEPT' relation?
The inability to insert a new department without null values for employee attributes
What does a deletion anomaly in the 'EMP_DEPT' relation result in?
Loss of information concerning the department from the database
What is the main problem caused by an insertion anomaly in the 'EMP_DEPT' relation?
Inability to insert a new department with no employees yet
How does the 'EMP_DEPT' relation violate the guideline for designing relation schemas?
By mixing attributes from distinct real-world entities into a single relation
What is the disadvantage of having repeated attribute values for every employee who works for the same department in the 'EMP_DEPT' relation?
Waste of storage space due to data redundancy
How does updating the department name of a particular department lead to modification (update) anomalies?
'EMP_DEPT' updates causing updating of too many rows
'Data redundancy' refers to which of the following?
Copying of same data in different tables or multiple tables
What is the primary issue that results from having attributes like DNumber, DName, and DMGRSSN repeated for every employee who works for the same department?
Loss of information concerning the department from the database
What is the first phase in the Iterative Process of Design?
Analysis
Which phase involves creating a design that solves the problem or fits the opportunity?
Design
According to Chris Swain, what percentage of game design is inspiration and iteration?
1% inspiration and 99% iteration
What is the main focus of the Testing phase in the Iterative Process of Design?
Analyzing the results of game testing
Which phase involves modifying the design based on game testing results and then implementing and testing again?
Iteration
What is considered critically important in the Iterative Process of Design?
Analyzing the results of game testing
What is the most important resource in game design?
Time
What should designers focus on to get the game up and running ASAP?
Mechanics
What is a significant element of the iterative design process?
Listening to multiple sources including oneself, team, audience, and client
What is important for maintaining creativity in game design?
Taking breaks when needed
What is the goal of implementation in game design?
To get from design to testing quickly and efficiently
What can be used for GUI testing instead of a digital prototype?
Testing various states of menu system on people using paper prototypes
In what phase are mechanics considered the most important element?
Design phase
What should designers focus on during the iterative process of design?
Attitude of listening to oneself, team, audience, and client
Test your knowledge on the iterative process of design, innovation, brainstorming, professional development phases, and scoping. Explore the concepts of analysis, design, implementation, testing, and iteration as well as the importance of changing your mind in the design process.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free