Explore Courses Blog Tutorials Interview Questions
0 votes
in SQL by (20.3k points)

I have two tables namely employees_ce and employees_sn under the database employees.

They both have their respective unique primary key columns.

I have another table called deductions, whose foreign key column I want to refer to primary keys of employees_ce as well as employees_sn. Is this possible?

for example



empid   name

khce1   prince



empid   name

khsn1   princess

so is this possible?



id      name

khce1   gold

khsn1   silver

1 Answer

0 votes
by (40.4k points)

Try doing as follows:

Start from a higher-level description of the database! As you have employees, and employees can be "ce" employees and "sn" employees (whatever those are). In oo(object-oriented terms), there is a class named as "employee", with two sub-classes named as "ce employee" and "sn employee". Now, you can translate this higher-level description to three tables as follows: employees, employees_ce and employees_sn:

employees(id, name)

employees_ce(id, ce-specific stuff)

employees_sn(id, sn-specific stuff)

Since all employees are employees, every employee must have a row in the employees table. "ce" employees will also have a row in the employees_ce table, and "sn" employees will also have a row in the employees_sn table. Here, is the foreign key to, just as is.

Refer to the employees table: you can refer to an employee of any kind like (ce or sn). 

Related questions

0 votes
1 answer
0 votes
1 answer
asked Oct 5, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
+1 vote
1 answer

Browse Categories