How is the design of a relational database determined in an organisation?
A)each department is given an allocation of tables
B)senior management decide how many tables are needed.
C)IT professionals advise on the best design.
D)by modelling the rules that describe how the business works.

Question

Quizplus · Accepted Answer

The design of a relational database in an organization is best determined by modelling the rules that describe how the business works. This involves analyzing the business requirements, identifying entities and their relationships, and defining the attributes and constraints. IT professionals may provide technical expertise, but the design should be driven by the business needs. Allocating tables to departments or leaving it to senior management's discretion may not result in an optimal design that supports efficient data management and processing.

How Is the Design of a Relational Database Determined in an Organisation