What are the main steps in Database Design?

Asked By Kane West 0 points N/A Posted on - 12/03/2012

What are the main steps in Database Design? It is really helpful for my exam.

• Status: Open
• Question Views: 870
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by John major

Go To Solution

Best Answer

Best Answer

Answered By John major 0 points N/A #162494

What are the main steps in Database Design?

 

Hello,

Generally the Database design part can be divided into 6 steps.

1.   Requirement Analysis.

Find what is going to do with database and what data is to be stored.

2.   Conceptual Database Design.

Describe data in High-level format using ER-Diagram.

3.   Logical database design.

This step includes convert conceptual database design into relational database design.

4.   Schema Refinement.

Analyze the collection of relation in the relational database schema.

5.   Physical Database design.

6.   Application Security and Design.

 

Thank You

John Major.

About John major

Questions
1

Answers
106

Best Answers
47

• Vote Up 0 Vote Down

• Posted on - 12/03/2012
• Question Category: MS SQL Server