What is best way to represent specialization/generalization hierachy if the participation and disjoint constraints are MANDATORY AND NONDISJOINT? A)Student(ssn,name,phone,program), Staff(ssn,name,phone,department) B)Person(ssn,name,phone), PersonDetails(ssn,studentFlag,program,staffFlag,department) C)Person(ssn,name,phone), Student(ssn,program),Staff(ssn,department) D)Person(ssn,name,phone,studentflag,program,stafflag,department)

Systems Architecture
7th Edition
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Stephen D. Burd
Chapter3: Data Representation
Section: Chapter Questions
Problem 3RP
icon
Related questions
icon
Concept explainers
Question

What is best way to represent specialization/generalization hierachy if the participation and disjoint constraints are MANDATORY AND NONDISJOINT?

A)Student(ssn,name,phone,program), Staff(ssn,name,phone,department)

B)Person(ssn,name,phone), PersonDetails(ssn,studentFlag,program,staffFlag,department)

C)Person(ssn,name,phone), Student(ssn,program),Staff(ssn,department)

D)Person(ssn,name,phone,studentflag,program,stafflag,department)

Person
SSN {PK}
name
phone
Student
Staff
program
department
Transcribed Image Text:Person SSN {PK} name phone Student Staff program department
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Query Syntax
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Systems Architecture
Systems Architecture
Computer Science
ISBN:
9781305080195
Author:
Stephen D. Burd
Publisher:
Cengage Learning