Breaking News: Grepper is joining You.com. Read the official announcement!

What is good database design? Certain principles guide the database design process. The first principle is that duplicate information (also called redundant data) is bad, because it wastes space and increases the likelihood of errors and inconsistencies.

Anjali Sharma answered on January 3, 2023 Popularity 1/10 Helpfulness 1/10

answer What is good database design? Certain principles guide the database design process. The first principle is that duplicate information (also called redundant data) is bad, because it wastes space and increases the likelihood of errors and inconsistencies.

What is good database design? Certain principles guide the database design process. The first principle is that duplicate information (also called redundant data) is bad, because it wastes space and increases the likelihood of errors and inconsistencies.

Comment

The design process consists of the following steps:
	Determine the purpose of your database    
This helps prepare you for the remaining steps.
	Find and organize the information required     
Gather all of the types of information you might want to record in the database, such as product name and order number.
	Divide the information into tables    
Divide your information items into major entities or subjects, such as Products or Orders. Each subject then becomes a table.
	Turn information items into columns    
Decide what information you want to store in each table. 
Each item becomes a field, and is displayed as a column in the table. For example, an Employees table might include fields such as Last Name and Hire Date.
	Specify primary keys    
Choose each table’s primary key.
The primary key is a column that is used to uniquely identify each row. An example might be Product ID or Order ID.
	Set up the table relationships    
Look at each table and decide how the data in one table is related to the data in other tables. 
Add fields to tables or create new tables to clarify the relationships, as necessary.
	Refine your design    
Analyze your design for errors. Create the tables and add a few records of sample data.
See if you can get the results you want from your tables. Make adjustments to the design, as needed.
	Apply the normalization rules    
Apply the data normalization rules to see if your tables are structured correctly. 
Make adjustments to the tables, as needed.

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: Grepper

Tags: database-design principles space whatever

Link to this answer
Share Copy Link

Contributed on Jan 03 2023

Anjali Sharma

0 Answers Avg Quality 2/10

What is good database design? Certain principles guide the database design process. The first principle is that duplicate information (also called redundant data) is bad, because it wastes space and increases the likelihood of errors and inconsistencies.

Contents

More Related Answers

What is good database design? Certain principles guide the database design process. The first principle is that duplicate information (also called redundant data) is bad, because it wastes space and increases the likelihood of errors and inconsistencies.

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.