Click here to Skip to main content
15,564,042 members
Home / Discussions / Database
   

Database

 
QuestionSSIS package Pin
Sachin Malviya31-Oct-14 7:01
Sachin Malviya31-Oct-14 7:01 
GeneralRe: SSIS package Pin
PIEBALDconsult31-Oct-14 7:03
professionalPIEBALDconsult31-Oct-14 7:03 
GeneralRe: SSIS package Pin
Richard Deeming31-Oct-14 7:18
mveRichard Deeming31-Oct-14 7:18 
GeneralRe: SSIS package Pin
PIEBALDconsult31-Oct-14 7:33
professionalPIEBALDconsult31-Oct-14 7:33 
QuestionLink to Microsoft Virtual System Pin
Shweta N Mishra31-Oct-14 4:41
professionalShweta N Mishra31-Oct-14 4:41 
AnswerRe: Link to Microsoft Virtual System Pin
Vijay Gill31-Oct-14 4:47
professionalVijay Gill31-Oct-14 4:47 
GeneralRe: Link to Microsoft Virtual System Pin
Shweta N Mishra31-Oct-14 6:21
professionalShweta N Mishra31-Oct-14 6:21 
QuestionUncertain on What to Use as Foreign Key of a Table Pin
ASPnoob30-Oct-14 6:19
ASPnoob30-Oct-14 6:19 
Hi all, I am trying to design a database to hold data for a job portal. Basically I have a database called SiteUsers which contains five tables (UsersTable, JobSeekersTable, ResumesTable, EmployersTable, and JobsTable). The following are the table schema for UsersTable, ResumesTable, and JobsTable.

The UsersTable has a Primary Key (PK) of UserID and a Foreign Key (FK) of Username.
The ResumesTable has a PK of ResumeID and the JobsTable has a PK of JobID.
The JobSeekersTable has a PK of Username.
The EmployersTable has a PK of Username.

The question I have is should the JobSeekersTable FK also be Username, or ResumeID, or a composite of Username and ResumeID. I think that the FK should be Username because it's unique but because it's not the primary key of the JobsTable I am uncertain. Also I did not want to use ResumeID as the FK in the JobSeekersTable because although it will be unique a job seeker can have more than one resume.

Whether you agree or disagree with my assumption that Username should be the PK and FK in the JobSeekersTable, please elaborate your answer . Thanks in advance for your help.

modified 30-Oct-14 12:35pm.

GeneralRe: Uncertain on What to Use as Foreign Key of a Table Pin
PIEBALDconsult30-Oct-14 6:59
professionalPIEBALDconsult30-Oct-14 6:59 
AnswerRe: Uncertain on What to Use as Foreign Key of a Table Pin
Eddy Vluggen30-Oct-14 7:08
professionalEddy Vluggen30-Oct-14 7:08 
GeneralRe: Uncertain on What to Use as Foreign Key of a Table Pin
ASPnoob30-Oct-14 7:34
ASPnoob30-Oct-14 7:34 
Questionplsql Pin
Member 1118871528-Oct-14 22:28
Member 1118871528-Oct-14 22:28 
AnswerRe: plsql Pin
Mycroft Holmes28-Oct-14 23:03
professionalMycroft Holmes28-Oct-14 23:03 
GeneralRe: plsql Pin
PhilLenoir29-Oct-14 4:04
professionalPhilLenoir29-Oct-14 4:04 
RantRetrieve Data Using Comma Separated List Pin
ASPnoob28-Oct-14 21:10
ASPnoob28-Oct-14 21:10 
GeneralRe: Retrieve Data Using Comma Separated List Pin
Mycroft Holmes28-Oct-14 23:01
professionalMycroft Holmes28-Oct-14 23:01 
GeneralRe: Retrieve Data Using Comma Separated List Pin
Shweta N Mishra29-Oct-14 2:23
professionalShweta N Mishra29-Oct-14 2:23 
GeneralRe: Retrieve Data Using Comma Separated List Pin
Mycroft Holmes29-Oct-14 4:13
professionalMycroft Holmes29-Oct-14 4:13 
QuestionAdvice on Perfomance Turning of the Query Pin
Vimalsoft(Pty) Ltd28-Oct-14 8:27
professionalVimalsoft(Pty) Ltd28-Oct-14 8:27 
GeneralRe: Advice on Perfomance Turning of the Query Pin
PIEBALDconsult28-Oct-14 9:04
professionalPIEBALDconsult28-Oct-14 9:04 
AnswerRe: Advice on Perfomance Turning of the Query Pin
Eddy Vluggen28-Oct-14 9:59
professionalEddy Vluggen28-Oct-14 9:59 
AnswerRe: Advice on Perfomance Turning of the Query Pin
Mycroft Holmes28-Oct-14 13:59
professionalMycroft Holmes28-Oct-14 13:59 
GeneralRe: Advice on Perfomance Turning of the Query Pin
Vimalsoft(Pty) Ltd4-Nov-14 22:56
professionalVimalsoft(Pty) Ltd4-Nov-14 22:56 
QuestionCombine results from 2 foxpro DBF files using union Pin
jkirkerx27-Oct-14 13:30
professionaljkirkerx27-Oct-14 13:30 
AnswerMakes no sense how it works Pin
jkirkerx27-Oct-14 14:01
professionaljkirkerx27-Oct-14 14:01 

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.