Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> re:Data modeling issues for a travel planning system

re:Data modeling issues for a travel planning system

From: hensome2004 <henrychang04_at_hotmail-dot-com.no-spam.invalid>
Date: Sat, 05 Nov 2005 02:10:29 -0600
Message-ID: <s6idnTIAUJ9o9fHeRVn_vA@giganews.com>


Thanks Kevin.

But looking into the STATION_LINE table, it is not normalised if we use one PK. The primary key of this table should be a composite key, made up of 3 columns, line_id, stat_id, and direction_id. This is because the next station is only determined by these 3 attributes together.

In addition, do I miss something in the tables if you consider the requirements carefully?

Anyone has suggestion on this? Thanks a lot!!

Received on Sat Nov 05 2005 - 02:10:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US