You're designing a new database for your organization to track warehouse inventory. To ensure data integrity and consistency, you need to uniquely identify each inventory item within the database tables. Which key or keys should you use?
Options:
a. Tuple b. Foreign c. Primary d. Attribute e. Cell
Explanation:
The correct answer is (H) options b and c only.
- Primary Key: A unique identifier for each row in a table, ensuring data integrity and preventing duplicate records.
- Foreign Key: A field in one table that references the primary key in another table, establishing relationships and enforcing data consistency.