219k views
1 vote
When designing a database, what should your first step be?

A. Clearly define the purpose of the database.
B. Divide data into tables that don't duplicate data.
C. Specify table relationships.
D. Choose the primary key for each table.

1 Answer

0 votes

Answer:

Option A is the right answer. When designing a database the first step is to clearly define the purpose of database. What are the primary goals you want to achieve by building a database for a specific purpose. There are various methods of defining core purpose of database design.

Step-by-step explanation:

  • As we understand defining purpose of database is the first step in database development, followed by series of steps to accomplish a database for required purpose.
  • Requirement analysis/ elicitation defines the purpose of a database.
  • Requirement analysis help us finding and organizing the information required i.e. purpose-the foremost step, to build a database.
  • Gather the required information and group/ divide that information into tables.
  • Select the unique identifier in each table to make it primary key.
  • Set up and specify table relationships i.e one-to-one, one-to-many etc.

Answer details

Grade: College

Subject: Computers and Technology

Chapter: Database Design

Keywords: designing database, relations in database, primary key etc

User Ckesplin
by
5.4k points