我可以在本地数据库中建立表的关系，如果是这样的话 [英] Can I Make Relationship of Tables in Local Database, If then how

问题描述

我正在使用visual studio 2012提供的本地数据库I，e Entity Frame的工作。

我有一些表需要彼此建立关系。

我可以在本地数据库中建立表的关系，因为我们可以在SQL Server中创建它。

我只想使用本地数据库来达到我的学习水平。

解决方案

如果您的数据库是关系数据库，那么如果它是本地数据库则完全无关紧要。对于处理关系，学习一些SQL和关系模型：

http://en.wikipedia.org/ wiki / Relational_model [ ^ ]，

http://en.wikipedia.org/wiki/Relation_%28database%29 [ ^ ]，

http://code.tutsplus.com/articles/sql -for-beginners-part-3-database-relationships-net-8561 [ ^ ]。

-SA

Riaz写道：

是你是对的我应该首先了解基础知识。

我真的不知道表关系等等。谢谢。

如果你有任何其他有用的链接规范化和关系请与我分享。我会非常感谢你。

当然。我已经引用了一些关于人际关系的文章，但你可以找到更多：

https://msdn.microsoft.com/en-us/library/gg399176%28v=sql.110%29.aspx [ ^ ]，

https://technet.microsoft.com/en-us/library/ ms190651％28v = sql.105％29.aspx [ ^ ]，

http： //www.sqlinfo.net/oracle/oracle_Create_foreign_key_contraints.php [ ^ ]。



我认为这是重要的要学习关系模型本身，这是一回事，SQL就是一种语言;这是另一个。



现在，关于规范化和普通形式的参考：

http://en.wikipedia.org/wiki/Database_normalization [ ^ ]。



每个普通表格的解释，以及示例，也可以是在这里找到：

http://en.wikipedia.org/wiki/First_normal_form [< a href =http://en.wikipedia.org/wiki/First_normal_formtarget =_ blanktitle =New Window> ^ ]，

http://en.wikipedia.org/wiki/Second_normal_form [ ^ ]，

http ：//en.wikipedia.org/wiki/Third_normal_form [<啊ref =http://en.wikipedia.org/wiki/Third_normal_formtarget =_ blanktitle =New Window> ^ ]，

http://en.wikipedia.org/wiki/Fourth_normal_form [ ^ ]，

http： //en.wikipedia.org/wiki/Fifth_normal_form [ ^ ]，

http://en.wikipedia.org/wiki/Sixth_normal_form [ ^ ]，

http://en.wikipedia.org/wiki/Domain/key_normal_form [ ^ ]。



另请参阅这篇简短的文章，解释规范化的重要性： http ：//oderog.hubpages.com/hub/Understand-the-importance-of-data-normalization [ ^ ]。

-SA

I am Using Local Database provided by visual studio 2012 I,e Entity Frame work.
I have Some tables in it which needs to make relations each other.
Can I make Relationships of tables in local database as l we can do it in SQL Server.
I just want to use Local Database only to level of my learning.

解决方案

If your database is a relational database, it's absolutely irrelevant if it is local or not. For working with relations, learn some SQL and relational model:
http://en.wikipedia.org/wiki/Relational_model[^],
http://en.wikipedia.org/wiki/Relation_%28database%29[^],
http://code.tutsplus.com/articles/sql-for-beginners-part-3-database-relationships--net-8561[^].

—SA

Riaz wrote:

Yes you are right I should to know about basics first.
I really don't know about tables relationships and etc. Thanks.
And if you have any other useful links regarding Normalization and Relationships please share with me. I will be much thankful of you.

Sure. I already referenced some texts on relationships, but you can find a lot more:
https://msdn.microsoft.com/en-us/library/gg399176%28v=sql.110%29.aspx[^],
https://technet.microsoft.com/en-us/library/ms190651%28v=sql.105%29.aspx[^],
http://www.sqlinfo.net/oracle/oracle_Create_foreign_key_contraints.php[^].

I think it's important to learn relational model itself, this is one thing, and the SQL as a language; this is another one.

Now, references on normalization and normal forms:
http://en.wikipedia.org/wiki/Database_normalization[^].

The explanation of each normal forms, with examples, can also be found here:
http://en.wikipedia.org/wiki/First_normal_form[^],
http://en.wikipedia.org/wiki/Second_normal_form[^],
http://en.wikipedia.org/wiki/Third_normal_form[^],
http://en.wikipedia.org/wiki/Fourth_normal_form[^],
http://en.wikipedia.org/wiki/Fifth_normal_form[^],
http://en.wikipedia.org/wiki/Sixth_normal_form[^],
http://en.wikipedia.org/wiki/Domain/key_normal_form[^].

See also this short article explaining the importance of normalization: http://oderog.hubpages.com/hub/Understand-the-importance-of-data-normalization[^].

—SA

这篇关于我可以在本地数据库中建立表的关系，如果是这样的话的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！