Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL Homework NoEffort
I have 4 tables
table 1 has 1 column named car
table 2 has 2 columns named car and name
table 3 has 3 columns car ,name, and group
table4 has 4 columns named car ,name,group, owner i want to likn k the coulmns in the tables so that car,name,group in table1,2and 3 are the same
Posted 17-Sep-12 23:07pm
mrDivan879
Edited 17-Sep-12 23:10pm
v2
Comments
Zoltán Zörgő at 18-Sep-12 5:10am
   
Good for you, and how can we help? This is no question.
shabari7 at 18-Sep-12 5:16am
   
try foreign key concept

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Hi,
you can use primary key and foreign key concept.
like keep car as primary key in table1 and give its reference to all three tables.
in same way for name and group in their respective tables.
it will help to remove data redundancy.
  Permalink  
Comments
mrDivan at 18-Sep-12 6:25am
   
Thank you

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 410
1 CHill60 255
2 Sergey Alexandrovich Kryukov 170
3 RyanDev 135
4 Richard MacCutchan 115


Advertise | Privacy | Mobile
Web04 | 2.8.140709.1 | Last Updated 18 Sep 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid