How does an ERD help in database design and modeling?
- Defines data types
- Identifies primary keys
- Maps SQL queries
- Provides visual representation
An ERD (Entity-Relationship Diagram) aids in visualizing the structure of a database, showing entities, their attributes, and the relationships between them. It helps in understanding the database schema and designing the database efficiently.
Loading...
Related Quiz
- A deadlock in DB2 occurs when ________ transactions are waiting for each other to release locks.
- The IMPORT utility in DB2 supports the ________ option, which allows for skipping header rows in the input file.
- In DB2, what is the purpose of clustering indexes?
- How does the performance of a subquery differ from that of a join in DB2?
- What are the advantages and disadvantages of using row-level locking in DB2?