What is the goal of conceptual design in database design?
Design a database independent of database software and physical details
Conceptual data model describes main data entities, attributes, relationships, and constraints.
List the steps involved in the conceptual design process.
- Data analysis and requirements
- Entity relationship modeling and normalization
- Data model verification
- Distributed database design
These steps guide the creation of a conceptual model for the database.
What is the minimum data rule in conceptual design?
All that is needed is there, and all that is there is needed
This principle ensures efficiency in data management.
What are the six phases of the Database Life Cycle (DBLC)?
- Database initial study
- Database design
- Implementation and loading
- Testing and evaluation
- Operation
- Maintenance and evolution
Each phase addresses specific aspects of database management and development.
Define top-down design in database design strategies.
Starts by identifying the data sets and then defines the data elements for each of those sets
This approach is suitable for simpler problems.
Define bottom-up design in database design strategies.
First identifies the data elements and then groups them together in data sets
This method is often used for more complex systems.
What are the common sources of database failure?
- Software-induced failures
- Hardware-induced failures
- Programming exemptions
- Transactions
- External factors
Understanding these sources helps in preventing database failures.
What is the purpose of data model verification?
Verified against proposed system processes
It ensures that the model meets user requirements and functions correctly.
What does module coupling refer to in database design?
Extent to which modules are independent of one another
Low coupling decreases unnecessary intermodule dependencies.
What is the centralized design approach?
All database design decisions are carried out centrally by a small group of people
Suitable for small problem domains.
What is the decentralized design approach?
Conceptual design models subsets of an organization’s database requirements, aggregated into a complete design
Typical for complex systems with many objects and procedures.
What is the process of physical design in database management?
Process of data storage organization and data access characteristics of the database
Ensures integrity, security, and performance.
What are the steps in logical design?
- Map the conceptual model to logical model components
- Validate the logical model using normalization
- Validate the logical model integrity constraints
- Validate the logical model against user requirements
These steps ensure the logical model aligns with user needs.
What is a database fragment?
Subset of a database stored at a given location
Ensures database integrity, security, and performance in distributed designs.
What factors affect DBMS software selection?
- Cost
- DBMS features and tools
- Underlying model
- Portability
- DBMS hardware requirements
These factors help organizations choose the right DBMS for their needs.
What is the Systems Development Life Cycle (SDLC) traditionally divided into?
- Planning
- Analysis
- Detailed systems design
- Implementation
- Maintenance
The SDLC traces the history of an information system and provides a framework for database design and application development.
What is the role of database design in an information system?
Foundation of a successful information system
Database design is crucial for effective data collection, storage, and retrieval.
What are the five phases in the Systems Development Life Cycle (SDLC)?
- Planning
- Analysis
- Detailed systems design
- Implementation
- Maintenance
Each phase serves a specific purpose in the development of an information system.
What is the iterative nature of the SDLC?
Iterative rather than sequential process
This means that phases can be revisited and refined as needed.
What does the database provide as part of an information system?
- Data collection
- Storage
- Retrieval
The database is a key component of the larger information system (IS).
What are the components of an information system (IS)?
- People
- Hardware
- Software
- Database(s)
- Application programs
- Procedures
These components work together to facilitate data management.
What is the process of systems development?
Creating an information system
This involves establishing the need for and extent of the information system.
What are the six phases in the Database Life Cycle (DBLC) framework?
_______
The DBLC framework is essential for designing databases effectively.
Distinguish between top-down and bottom-up approaches in database design.
_______
These approaches refer to different methodologies in structuring database design.
