First, you do not have "tables" after normalization- you have a normalized
ER model. Your instructor (or text) should have a section on mapping your
ERD (model) to an ER schema (the tables). You need to consider the
cardinality and participation constraints to properly transform the model
into tables.
"oracle" <oracle9i-helpme_at_mail2me.com> wrote in message
news:9422fafe.0404260825.4ac57a6_at_posting.google.com...
> Hi,
> suppose I found following tables
> after normalization .
>
> students :
> student_id
> student_name
>
> courses :
> course_id
> course_name
>
> student_course
> student_id
> course_id
>
> My confusion is that how do I setup those
> table . How many tables I need to create ? two or three .
> What to do with that link(student_course) table ?
>
> Please help me . I understand normalization but
> those questions bothers me .
>
> Thank You.
Received on Mon Apr 26 2004 - 11:54:27 CDT
