To begin designing a relational database,one must define the _____ by defining each table and the fields in it.
A)physical structure
B)logical structure
C)primary key
D)foreign key

Question

Quizplus · Accepted Answer

The logical structure of a relational database is defined by the tables and fields within each table. This involves identifying the entities that need to be stored in the database and defining the relationships between them. The physical structure involves deciding how the data is physically stored on disks or other storage devices. The primary key is a field or set of fields that uniquely identifies each record in a table, while the foreign key is a field in one table that refers to the primary key of another table to establish a relationship between them. However, before defining primary and foreign keys, one must first define the tables and fields in the logical structure.

To Begin Designing a Relational Database,one Must Define the _____