开发者

ER to Relational mapping to Create statments

I am making a .NET website which makes uses of a database to store information. It's a practice/experimental project not related to work or uni projects.

My question is to with mapping of the ER diagram to a RelationModel and then onto writing the actual create table statements.

following is my ER: http://img577.imageshack.us/img577/2405/climsyclipboardf.jpg

i'm confused about the part where an entity has ISA relation so it can be two things.

i know how i can for example map Business Account to Ac开发者_JAVA技巧count by including all the attributes of Account into Business Account, but not sure if it makes sense when it comes to create statements.

for example, Account is either business or private account has payment of either CC or Direct Debit. How do i do this in create table statements?


For business vs. private accounts, you can make the account type an attribute of the account by implementing it in a column. Now the same thing can be said about CC and Direct Debit. It really depends on how intricate you want to make this system.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜