GPT Database Design

Question 1

What are all the stages in the Database Development Life Cycle (DDLC)?

Answer 1

1. Requirement Analysis
2. COnceptual Design
3. Logical Design
4. Physical Design
5. Data Loading
6. Testing
7. Maintenance

Question 2

What is the focus of data-driven design in database development?

Answer 2

• Emphasize Data Stability
• Design database before applications

Question 3

Phases of Database Design

Answer 3

1. Conceptual
2. Logical
3. Physical

Question 4

Goal of conceptual design phase

Answer 4

Create a high-level schema independent of DBMS

E/R Diagram

Question 5

Logical Design Phase

Answer 5

Translates conceptual schema to logical model according to DBMS chosen (Ex. Relational)

Question 6

Physical Design Phase

Answer 6

Define data storage and access structure specific to DBMS

Ex: Tablespaces, indexes

Question 7

Key activities involved in Requirements Gathering and Analysis?

*The thing that we should do before we move into database design phases

Answer 7

1. Create glossary
2. Resolve ambiguities
3. Group similar requirements

Question 8

4 Focuses in Database Requirements Gathering

Answer 8

1. Data
2. Process
3. Dynamics
4. Integrity Constraints

Question 9

How does indexing improve database performance?

Answer 9

Enhancing query efficiency and ensuring data integrity

Question 10

What does application design create in relation to databases?

Answer 10

Software modules and user interfaces to interact with the database