[punjabian263]

how i can make relation of these entities


Q: in a university a person can be a student, alumunus or an employee.

A student can work as an employ as well
Attributes:

Person: name, address, ssn, dob, gender
employ: salary, hdate, job(can be either staff or faculty)
alumunus: degree, year, session
sudent: major_dept, program(can be either graduate or under graduate)

thanks for help.

[Rockn]

Seperate table for category...

Field name:
Category

Student
Alumnus
Employee

Use the primary key to join to other tables.

[punjabian263]

I made these relations

Person(name, address, pssn, dob, gender)
employ(salary, hdate,pssn)
employ_job(pssn,hdate, job)
alumunus(degree, year, session,pssn)
sudent(major_dept,pssn)
sudent_program(major_dept,pssn,program)

[punjabian263]

quote "
Field name:
Category

Student
Alumnus
Employee



I will make the table of person or not.