Database Design includes the functions like
2013
Database Design includes the functions like
- A.
Identification of different tables
- B.
Creation of fields with their attributes
- C.
Creating validation rules and database interrelationships
- D.
All of the above
Attempted by 65 students.
Show answer & explanation
Correct answer: D
Concept
Database design is the process of organising data into a structured schema before any data is stored. It is not a single action but a set of coordinated functions: deciding what entities to store, describing each entity's attributes, and defining the rules and links that keep the data consistent.
Application
The three statements offered are not alternatives — each names a distinct, necessary stage of the design process:
Identifying the different tables decides which real-world entities (e.g. Students, Courses) each become a separate table.
Creating fields with their attributes describes each table's columns and their data types, sizes and defaults.
Creating validation rules and interrelationships adds the constraints (e.g. NOT NULL, range checks) and the foreign-key relationships that bind the tables together.
Conclusion
Because every one of these is a genuine function of database design, the option that covers all three — "All of the above" — is the complete and correct answer. Choosing only one of them describes a single step rather than the full design activity.