Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Entity Relationship model help

Author  Topic 

alm92
Starting Member

1 Post

Posted - 2014-04-18 : 14:44:56
hey all,
Im having trouble relating the following things to the customer along with figuring out the cardinality. guess just not getting the jist of the whole relationship model.

• Checking accounts
• Savings accounts
• Money market accounts
• Mortgages
• Auto loans
• Student loans

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2014-04-18 : 14:54:13
pretty vague question - not sure I know what you're asking. You mean like given a table of customers and a table of checking accounts how do you model it so you know which checking accounts belong to which customers?

So is this for school?

Be One with the Optimizer
TG
Go to Top of Page

chef423
Starting Member

15 Posts

Posted - 2014-04-18 : 17:46:18
well, your Cardnility is 6, from that ordered list. But yes, we need more info to help.
Go to Top of Page
   

- Advertisement -