Answered: person ID пате address emplayee student…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Consider the E-R diagram in Figure 8.9, which contains specializations, using
subtypes and subtables.
a. Give an SQL schema definition of the E-R diagram.
b. Give an SQL query to find the names of all people who are not secretaries.
c. Give an SQL query to print the names of people who are neither employees
nor students.
d. Can you create a person who is an employee and a student with the
schema you created? Explain how, or explain why it is not possible.

person
ID
пате
address
emplayee
student
salary
tol_credits
instructor
secretary
rank
hours_per_week
Figure 8.9 Specialization and generalization.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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