[LBSC 690] Minor clarification to homework

1 view
Skip to first unread message

William Webber

unread,
Feb 29, 2012, 5:00:23 PM2/29/12
to lbsc690-sp...@googlegroups.com
Hi all!

I've modified the homework description for Homework 05 to
clarify that any many-to-many relationships must be resolved;
see the homework sheet for details.

William

Joel

unread,
Mar 4, 2012, 1:57:46 AM3/4/12
to lbsc690-spring12-0101
Is there really a way for the have the student table include "a list
of all the classes the student is in" without knowing the maximum
number of classes they can be in and listing that number of different
"class" foreign keys together?

William Webber

unread,
Mar 4, 2012, 9:05:33 AM3/4/12
to lbsc690-sp...@googlegroups.com
No, you're exactly right. But this information, while it is
a characteristic of the student _entity_ (in the modelling sense),
does not need to be represented in the student _table_. This
is a (fairly mild) example of the mismatch between how things
are described in natural language and how they're implemented
in the database.

William

Reply all
Reply to author
Forward
0 new messages