CompTIA DataSys+ (DS0-001)Database DeploymentEasy
A database administrator is planning a new relational database deployment. The system will store customer orders and product inventory. Which of the following database objects should be designed first to ensure data integrity and efficient querying?
- AStored Procedures
- BViews
- CIndexes
- DTables
Show answer & explanationAnswer & explanation
Correct answer: D. Tables
Tables are the fundamental building blocks of a relational database, defining the structure where all data is stored. Without properly designed tables, other objects like views, stored procedures, or indexes cannot be effectively created or utilized.
Why the other options are wrong
- A. Stored procedures are pre-compiled SQL code for performing tasks; they operate on existing tables.
- B. Views are virtual tables based on the result-set of a SQL query; they rely on underlying tables.
- C. Indexes improve query performance but are created on existing table columns.
Relational Database Tables
Tables are the primary storage structures in a relational database, organizing data into rows and columns with defined data types and constraints.
- Fundamental building block of a relational database.
- Composed of rows (records) and columns (fields).
- Each column has a specific data type (e.g., INT, VARCHAR, DATE).
Memory trick: Tables are the 'T' in 'The foundation' of any database.