Define relationships [message #609537] |
Sun, 09 March 2014 20:39 |
|
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: Define relationships [message #609572 is a reply to message #609537] |
Mon, 10 March 2014 02:13 |
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.
|
|
|
|