In database modeling, a _______ key is a key that uniquely identifies a record within a table.
- Composite
- Foreign
- Primary
- Secondary
In database modeling, a primary key is a key that uniquely identifies a record within a table. It serves as the unique identifier for each row and ensures data integrity by preventing duplicate or null values in this key field.
Loading...
Related Quiz
- In NoSQL databases, what is the significance of the CAP theorem regarding data consistency?
- Scenario: A multinational corporation requires a database design tool that can integrate with their existing software ecosystem, including enterprise resource planning (ERP) systems. They also need robust support for data security and compliance. Which database design tool would you suggest, and how does it meet the corporation's requirements?
- An entity that inherits properties and relationships from another entity is known as a _______.
- Scenario: Two data modelers are working on the same entity-relationship diagram (ERD) simultaneously. They make conflicting changes to the diagram. How would you resolve this conflict?
- What is clustering in the context of databases?