Home » Other » General » Define relationships
Define relationships [message #609537] Sun, 09 March 2014 20:39 Go to next message
man silence
Messages: 34
Registered: March 2013
Member
How can I set a relationship between these tables,Primary key, and FK Or there is no a relationship?

customers
1.name
2.place of brith
3.date of brith
4.address
5.phone

cars
1.name
2.model
3.color
4.number of passenger
5.discription

motors
1.name
2.model
3.number of wheels
4.discription


--update: topic title changed from CREATE DATABASE. jw.
  • Attachment: Capture.JPG
    (Size: 26.83KB, Downloaded 1618 times)

[Updated on: Mon, 10 March 2014 02:13] by Moderator

Report message to a moderator

Re: CREATE DATABASE [message #609538 is a reply to message #609537] Sun, 09 March 2014 21:31 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
you can not push a string
Re: CREATE DATABASE [message #609553 is a reply to message #609538] Mon, 10 March 2014 00:11 Go to previous messageGo to next message
man silence
Messages: 34
Registered: March 2013
Member
I will try in a new way
thanks BlackSwan Smile

[Updated on: Mon, 10 March 2014 00:14]

Report message to a moderator

Re: Define relationships [message #609572 is a reply to message #609537] Mon, 10 March 2014 02:13 Go to previous messageGo to next message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
Is this college homework question? If so, your teacher will probably want you to begin by adding keys to the tables, declaring relationships between them, and declaring various constraints.
Re: Define relationships [message #609648 is a reply to message #609572] Mon, 10 March 2014 18:12 Go to previous message
man silence
Messages: 34
Registered: March 2013
Member
yes
thank you .
I'm going to do
Previous Topic: What is the best modeling tool?
Next Topic: Oracle Licensing
Goto Forum:
  


Current Time: Mon Nov 25 22:41:45 CST 2024