Click here to Skip to main content
14,699,674 members
Home » Discussions » Database
   

Database

 
GeneralRe: Calculate and display a progressive balance Pin
smcnulty200018-Jul-11 14:36
Membersmcnulty200018-Jul-11 14:36 
QuestionSelecting multiple columns from several tables without using JOIN Pin
Dominick Marciano11-Jul-11 5:41
professionalDominick Marciano11-Jul-11 5:41 
AnswerRe: Selecting multiple columns from several tables without using JOIN Pin
Blue_Boy11-Jul-11 5:55
MemberBlue_Boy11-Jul-11 5:55 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
David Mujica11-Jul-11 6:28
MemberDavid Mujica11-Jul-11 6:28 
AnswerRe: Selecting multiple columns from several tables without using JOIN Pin
kmoorevs11-Jul-11 11:08
Memberkmoorevs11-Jul-11 11:08 
AnswerRe: Selecting multiple columns from several tables without using JOIN Pin
Shameel11-Jul-11 22:30
professionalShameel11-Jul-11 22:30 
AnswerRe: Selecting multiple columns from several tables without using JOIN Pin
David Skelly12-Jul-11 4:54
MemberDavid Skelly12-Jul-11 4:54 
AnswerRe: Selecting multiple columns from several tables without using JOIN Pin
AnnieMacD14-Jul-11 7:24
MemberAnnieMacD14-Jul-11 7:24 
I think you need to go back and look at your datadase design. You say there is no connection between Instructors and Courses but I think, in reality, there is a many-to-many relationship. You can achieve the connection with a linked (or intermediate) table which only contains the two primary keys - one from each table. Then create foreign keys on this table to the Instructors and Classes tables. The Primary Key of the linking table needs to be the composite of the two elements InstructorID and CourseID - see below.

Instructor Table: InstructorID, FirstName, LastName,...<br />
Course Table: CourseID, Subject, DateStart, DateEnd,.... <br />
InstructorCourse Table: InstructorID, CourseID  //This is a new table with just two fields


I presume you don't want Lecturer A being able to teach Geography when really his/her subject is History, but Lecturer B can teach Mathematics and Statistics - no problem.
It’s not because things are difficult that we do not dare, it’s because we do not dare that things are difficult. ~Seneca

GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
Shameel14-Jul-11 19:52
professionalShameel14-Jul-11 19:52 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
smcnulty200014-Jul-11 23:46
Membersmcnulty200014-Jul-11 23:46 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
Shameel15-Jul-11 3:22
professionalShameel15-Jul-11 3:22 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
AnnieMacD15-Jul-11 3:45
MemberAnnieMacD15-Jul-11 3:45 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
Shameel15-Jul-11 8:50
professionalShameel15-Jul-11 8:50 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
AnnieMacD15-Jul-11 8:56
MemberAnnieMacD15-Jul-11 8:56 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
smcnulty200015-Jul-11 6:39
Membersmcnulty200015-Jul-11 6:39 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
Shameel15-Jul-11 8:48
professionalShameel15-Jul-11 8:48 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
smcnulty200015-Jul-11 9:08
Membersmcnulty200015-Jul-11 9:08 
GeneralRe: Selecting multiple columns from several tables without using JOIN Pin
AnnieMacD15-Jul-11 3:44
MemberAnnieMacD15-Jul-11 3:44 
AnswerRe: Selecting multiple columns from several tables without using JOIN Pin
smcnulty200015-Jul-11 0:20
Membersmcnulty200015-Jul-11 0:20 
QuestionTemp and variable table cannot be created. Pin
Groulien10-Jul-11 23:27
MemberGroulien10-Jul-11 23:27 
AnswerRe: Temp and variable table cannot be created. Pin
Shameel11-Jul-11 2:42
professionalShameel11-Jul-11 2:42 
AnswerRe: Temp and variable table cannot be created. Pin
DaveAuld11-Jul-11 3:57
professionalDaveAuld11-Jul-11 3:57 
AnswerRe: Temp and variable table cannot be created. Pin
Corporal Agarn11-Jul-11 7:00
professionalCorporal Agarn11-Jul-11 7:00 
AnswerRe: Temp and variable table cannot be created. Pin
S Douglas11-Aug-11 11:07
professionalS Douglas11-Aug-11 11:07 
QuestionRestoration of publisher database to another system (merge replication) Pin
Abd.Jabbar9-Jul-11 22:39
MemberAbd.Jabbar9-Jul-11 22:39 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.