标准和简单的方法来进行模式设计 [英] standard and easy way to do schema design

问题描述

我想知道，而不仅仅是头脑风暴，可能有非常标准的

a和一种简单的方法来进行数据库架构设计。


让我们说我们正在做一个网站。用户可以查看

并输入电影名称和邮政编码，并且网站

将返回显示该电影的所有影院以及

时间，仅适用于THAT邮编的影院（为简单起见）。


所以我们如何开始使用标准方法

可以很简单并且非常准确地确保良好的桌子设计？

解决方案

8月15日下午1:30，sybrandb< sybra ... @ gmail.comwrote：

8月15日下午1:08，Summercooln ... @ gmail.com写道：

我想知道，而不仅仅是头脑风暴，可能有非常标准的

a和一种简单的方法来进行数据库架构设计。

是的，方式确实很简单。首先，阅读Handbook of

关系数据库设计等书籍

http：/ /www.amazon.com/Handbook-Relat...7036320&sr=1-1


之后，您需要几个月的错误。在那之后，

的东西变得非常标准和简单 - 就像编写软件一样

一般> - :)

< Su ************ @ gmail.comwrote in message

news：11 *** *******************@z24g2000prh.googlegr oups.com ...

我想知道而不仅仅是头脑风暴，可能是非常标准的，并且是一种简单的数据库架构设计方式。


让我们说我们正在做一个网站。用户可以查看

并输入电影名称和邮政编码，并且网站

将返回显示该电影的所有影院以及

时间，仅适用于THAT邮编的影院（为简单起见）。


所以我们如何开始使用标准方法

可以很简单并且非常准确地确保良好的桌子设计？

如果你想了解什么是数据建模和桌面设计

所有关于，看一下本网站的大纲：

http://www.utexas.edu/its/windows/da.../overview.html


这些技巧是你概述的问题有点过分。但是，如果

信息需求一如既往地增长，您将很快进入需要这些技术或类似技术的地方。

8月15日上午5:21，David Cressey < cresse ... @ verizon.netwrote：

< Summercooln ... @ gmail.comwrote in message


新闻：11 ********************** @ z24g2000prh.googlegr oups.com ......

我想知道而不仅仅是头脑风暴，可能是非常标准的一个简单的方法来进行数据库架构设计。

让我们说我们正在做一个网站。用户可以查看

并输入电影名称和邮政编码，并且网站

将返回显示该电影的所有影院以及

时间，仅适用于THAT邮编的影院（为简单起见）。

现在，当我去面试时，很多面试官都希望

我可以在2,3分钟内制作一个模式...


所以我想知道上面的例子，是否有2分钟的思维方式

来制作解决方案？

I wonder instead of just brainstorming, there probably is
a very standard and a simple way to do database schema design.

let''s say we are doing a website. the user can go over
and type in the movie name and zipcode, and the website
will return all the theaters showing that movie and at what
time, for theaters in THAT zipcode only (for simplicity).

so how do we just start and use a standard method that
can be simple and very accurate to ensure good tables design?

解决方案

On Aug 15, 1:30 pm, sybrandb <[e-mail]:

On Aug 15, 1:08 pm, [e-mail] wrote:

I wonder instead of just brainstorming, there probably is
a very standard and a simple way to do database schema design.

Yes, the way is indeed simple. First, read books like "Handbook of
Relational Database Design"

http://www.amazon.com/Handbook-Relat...7036320&sr=1-1

After that, you need a few month of making mistakes. After that,
things become very standard and simple - just as with writing software
in general >-:)

<Su************@gmail.comwrote in message
news:11**********************@z24g2000prh.googlegr oups.com...

I wonder instead of just brainstorming, there probably is
a very standard and a simple way to do database schema design.

let''s say we are doing a website. the user can go over
and type in the movie name and zipcode, and the website
will return all the theaters showing that movie and at what
time, for theaters in THAT zipcode only (for simplicity).

so how do we just start and use a standard method that
can be simple and very accurate to ensure good tables design?

If you want to get an overview of what data modeling and table design are
all about, take a look at the outline in this website:

http://www.utexas.edu/its/windows/da.../overview.html

These techniques are overkill for the problem you outlined. But if the
information needs grow, as they always do, you will soon be in the
territory where you need these techniques or something like them.

On Aug 15, 5:21 am, "David Cressey" <[e-mail]:

<[e-mail] in message

news:11**********************@z24g2000prh.googlegr oups.com...

I wonder instead of just brainstorming, there probably is
a very standard and a simple way to do database schema design.

let''s say we are doing a website. the user can go over
and type in the movie name and zipcode, and the website
will return all the theaters showing that movie and at what
time, for theaters in THAT zipcode only (for simplicity).

Nowadays when I go for interviews, many interviewers hope that
I can produce a schema in just 2, 3 minutes...

So I wonder for the example above, is there a 2 minute way of thinking
to produce the solution?

这篇关于标准和简单的方法来进行模式设计的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！