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 48 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: 22521
Registered: January 2009
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: 4400
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: Tue Jul 29 09:27:29 CDT 2014

Total time taken to generate the page: 0.10724 seconds