INMT 342 Exam 3 Question and
answers already passed 2025/2026
what is the purpose of physical db design? - correct answer ✔translate the
logical description into technical specifications for storing and retrieving data
what is the goal of physical db design? - correct answer ✔create a design for
storing data that will provide:
•Performance
•Data Integrity
•Data Security
•Data Recoverability
•Simplify Application Development
inputs of physical design process - correct answer ✔•Normalized relations
•Volume estimates
•Attribute definitions
•Response time expectations
•Data security needs
•Backup/recovery needs
•Integrity expectations
•DBMS technology used
inputs lead to decisions of physical design process. these include: - correct
answer ✔•Attribute data types
•Physical record designs (doesn't always match logical design)
•File organizations
,•Indexes and database architectures
•Hardware configuration options
Composite Usage Maps - correct answer ✔•Use of tables to capture table
sizes and access rates/expectations
•Requirements may also be recorded and displayed using an annotated ERD
Data Volume - correct answer ✔•Data Volume
•Size Estimate
•Disk Storage Requirement
Data Volume - correct answer ✔How many records in entity?
Size Estimate - correct answer ✔How large is each table?
Disk Storage Requirement - correct answer ✔How much storage needed?
Data Usage - correct answer ✔•Access Paths/Security
•File Organization
•Memory/Processor Requirement
Access Paths/Security - correct answer ✔Which tables are accessed?
File Organization - correct answer ✔How are they accessed?
Memory/Processor Requirement - correct answer ✔How often accessed?
, Physical File - correct answer ✔A named portion of secondary memory
allocated for the purpose of storing physical records
Tablespace - correct answer ✔Disk storage in which database tables are
stored
File Organization - correct answer ✔How the files are arranged on the disk
Access Method - correct answer ✔How the data can be retrieved based on
the file organization
db design decisions - correct answer ✔•Normalization
•Denormalization
•Partitioning
•File Organization/Indexing
normalization - correct answer ✔•The process of grouping attributes together
into tables.
•Validates and improves logical database design to satisfy certain constraints
and AVOID duplication of data.
•Decomposition of tables to REMOVE anomalies and create 2 or more well-
structured tables.
creating well-structured tables - correct answer ✔•Contain minimal
redundancy
answers already passed 2025/2026
what is the purpose of physical db design? - correct answer ✔translate the
logical description into technical specifications for storing and retrieving data
what is the goal of physical db design? - correct answer ✔create a design for
storing data that will provide:
•Performance
•Data Integrity
•Data Security
•Data Recoverability
•Simplify Application Development
inputs of physical design process - correct answer ✔•Normalized relations
•Volume estimates
•Attribute definitions
•Response time expectations
•Data security needs
•Backup/recovery needs
•Integrity expectations
•DBMS technology used
inputs lead to decisions of physical design process. these include: - correct
answer ✔•Attribute data types
•Physical record designs (doesn't always match logical design)
•File organizations
,•Indexes and database architectures
•Hardware configuration options
Composite Usage Maps - correct answer ✔•Use of tables to capture table
sizes and access rates/expectations
•Requirements may also be recorded and displayed using an annotated ERD
Data Volume - correct answer ✔•Data Volume
•Size Estimate
•Disk Storage Requirement
Data Volume - correct answer ✔How many records in entity?
Size Estimate - correct answer ✔How large is each table?
Disk Storage Requirement - correct answer ✔How much storage needed?
Data Usage - correct answer ✔•Access Paths/Security
•File Organization
•Memory/Processor Requirement
Access Paths/Security - correct answer ✔Which tables are accessed?
File Organization - correct answer ✔How are they accessed?
Memory/Processor Requirement - correct answer ✔How often accessed?
, Physical File - correct answer ✔A named portion of secondary memory
allocated for the purpose of storing physical records
Tablespace - correct answer ✔Disk storage in which database tables are
stored
File Organization - correct answer ✔How the files are arranged on the disk
Access Method - correct answer ✔How the data can be retrieved based on
the file organization
db design decisions - correct answer ✔•Normalization
•Denormalization
•Partitioning
•File Organization/Indexing
normalization - correct answer ✔•The process of grouping attributes together
into tables.
•Validates and improves logical database design to satisfy certain constraints
and AVOID duplication of data.
•Decomposition of tables to REMOVE anomalies and create 2 or more well-
structured tables.
creating well-structured tables - correct answer ✔•Contain minimal
redundancy
