Create issue

15 pts.
Tags:
Create
here my two table:Create Table Schdule 
(Station_ID NUMBER( 3 ), 
Monorail_Station VARCHAR( 26 ),
 KelananJaya_Station VARCHAR( 26 ), 
SriPetaling_Station VARCHAR( 26 ), 
PRIMARY KEY (Station_ID) ).  

Create Table Route (Route_ID VARCHAR( 13 ),
 Start Station VARCHAR( 26 ), 
Turning Point Station VARCHAR( 26 ), 
 Station_id NUMBER( 3 ), 
PRIMARY KEY (Route_ID) ).

As you can see l'm using the same and correct data type to enforce entity relation in this two table. l trying to create both in sql. But when l'm trying to create the second table in sql, it state "invaild identified" of the 'station_id', which is the primary key l have created in the previous table. What can l do to keep this column in both table?


Software/Hardware used:
oracle sql server
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    Not sure if this is this issue...the missing underscores in the column names.


    Start_Station VARCHAR( 26 ), 
    Turning_Point_Station VARCHAR( 26 ), 
    131,605 pointsBadges:
    report
  • ErinLee997
    OMG thanks! my problem solved. l'm beginner learner of database. =)
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: