Question

When designing an information system, what dictates which data must be stored in the database? In other words, what should you examine first to determine what data needs to be stored in the database tables?

A. Queries
B. Macros
C. Forms
D. Reports
E. Relationships

Answer 1

The relationships between entities dictate what data needs to be stored in the database tables when designing an information system.

Step-by-step explanation:

When designing an information system, the determining factor for what data needs to be stored in the database tables is relationships.

Relationships between entities and tables help establish the structure of the database and determine the types of data that need to be stored. By examining the relationships between entities, you can identify the necessary data elements and define the appropriate tables.

For example, if you are designing a student information system, you would identify the relationships between students, courses, and grades. This analysis would help you determine the necessary data to store, such as student IDs, course codes, and grades.