Database Design includes the functions like

2013

Database Design includes the functions like

  1. A.

    Identification of different tables

  2. B.

    Creation of fields with their attributes

  3. C.

    Creating validation rules and database interrelationships

  4. 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.

Explore the full course: Btsc Lab Assistant