Which of the following decisions would be part of Distributed Database Design?
A) Student data and enrollment data will be stored in two different tables
B) An index file will be created on the last name of students in the Student table
C) The Social Security number will be chosen as the primary key of the Student table
D) Student data and enrollment data will be stored in two different tables at two different locations

Question

Quizplus · Accepted Answer

Distributed database design involves the decision of where to store data and how to distribute it across multiple locations. Therefore, the option D, where Student data and enrollment data will be stored in two different tables at two different locations, is the only decision that falls under distributed database design. Option A is a decision that falls under logical database design, option B is a query optimization decision, and option C is a decision that falls under determining the primary key of a table.

Which of the Following Decisions Would Be Part of Distributed