如何为网站设计数据库？ [英] How to design DB for website?

问题描述

我想为商店网站创建数据库，我不知道为什么这个天气中的主要实体以及如何确定表中的关系

请建议我如何创建关系桌子



我尝试过：

I want to Create a db for a Shop Website and i don't know why is the major entities in this weather and how to determine what relation in table
Please Suggest Me How Create Relation between Tables

What I have tried:

How Create Relation between Tables

推荐答案

在数据库设计上，请阅读：

1. 数据库设计简介 [ ^ ]

2. 数据库规范化中的1NF，2NF，3NF和BCNF DBMS教程| Studytonight [ ^ ]

关于实体的类型及其关系，这些只能来自您的用户需求分析。

On database design, read up on:
1. Introduction to database design[^]
2. 1NF, 2NF, 3NF and BCNF in Database Normalization | DBMS Tutorial | Studytonight[^]
As regards the kind of entities and their relationships, those can only be derived from your user requirements analysis.

工作的最大部分是非技术性的，通过思考要求;应存储哪些数据及其行为方式。如果清楚，那么您可以继续进行技术设计问题并考虑规范化表结构等。在解决方案1中，您可以获得关于这些主题的良好链接。



设计数据库后，您可以继续创建它。很少有可能派上用场的教程：

- 创建数据库（教程） [ ^ ]

- 创建表格（教程） [ ^ ]

- 创建外键关系 [ ^ ]

The biggest part of the job is non-technical, think through the requirements; What data should be stored and how it behaves. When this is clear then you can proceed to technical design issues and think about normalization table structures and so on. In solution 1 you have dew good links on those topics.

After designing the database you can proceed to creating it. Few tutorials that may come handy:
- Creating a Database (Tutorial)[^]
- Creating a Table (Tutorial)[^]
- Create Foreign Key Relationships[^]

这篇关于如何为网站设计数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！