Consider the E-R diagram in Figure 8.9, which contains specializations, using subtypes and subtables. a. Give an
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.
Figure 8.9
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
ANSWER a CREATE TABLE person ID INT name VARCHAR50 address VARCHAR50 PRIMARY KEY ID CR...View the full answer
Answered By
Churchil Mino
I have been a tutor for 2 years and have experience working with students of all ages and abilities. I am comfortable working with students one-on-one or in small groups, and am able to adapt my teaching style to meet the needs of each individual. I am patient and supportive, and my goal is to help my students succeed.
I have a strong background in math and science, and have tutored students in these subjects at all levels, from elementary school to college. I have also helped students prepare for standardized tests such as the SAT and ACT. In addition to academic tutoring, I have also worked as a swim coach and a camp counselor, and have experience working with children with special needs.
0 Reviews
10+ Question Solved
Related Book For 
Database System Concepts
ISBN: 9780078022159
7th Edition
Authors: Abraham Silberschatz, Henry F. Korth, S. Sudarshan
Question Posted:
