SDLC - Design Part 1

What is the purpose of database design?

• To create a physical database design

• To choose data storage technologies

• To develop a logical database design

• To structure the data in stable structures

What is the primary key in a relation?

• An attribute that is functionally dependent on another attribute

• An attribute that is used for indexing

• An attribute that depends on the whole primary key

• An attribute whose value is unique across all occurrences of a relation

What is the purpose of normalization in database design?

• To complicate the database structure

• To increase data redundancy

• To create redundant relations

• To convert complex data structures into simple, stable data structures

What is the main goal of denormalization?

• To speed up system performance

• To reduce data redundancy

• To increase data integrity

• To split or combine normalized relations into physical tables based on affinity of use of rows and fields

What is the purpose of an index in a database?

• To determine the location of rows in a file that satisfy some condition

• To store a copy of each row before it is changed

• To create synonym primary keys

• To represent entities in a relation

What is the main advantage of indexed file organization?

• Allows for both random and sequential processing

• Requires extra space for indexes

• Creates wasted space when deleting rows

• Is impractical for random retrieval

What is the purpose of referential integrity in database design?

• To ensure that the value of an attribute in one relation depends on the value of the same attribute in another relation

• To allow for multiple key retrieval

• To speed up system performance

• To create synonym primary keys

What is the main goal of partitioning in database design?

• To split a table into separate sections

• To create synonym primary keys

• To increase data redundancy

• To reduce data integrity

What is the purpose of a calculated field in a database?

• To represent entities in a relation

• To create synonym primary keys

• To store a copy of each change to a file in a transaction log

• To derive a field from other database fields

What is the main objective of choosing data types for fields in a database?

• To create synonym primary keys

• To increase data redundancy

• To minimize storage space and improve data integrity

• To speed up system performance