SQL schema definition Person relation type is considered. create type Person (ID integer, name varchar (30), address varchar (50)) create table person of Person Employee relation type is considered. create type Employee under Person (salary integer) create table employee of Employee under person Student relation type is considered...

Question

Want to see the full answer?

Answer 1

Expert Solution & Answer

Chapter 8, Problem 12E

a.

Explanation of Solution

SQL schema definition

Person relation type is considered.
create type Person (ID integer, name varchar (30), address varchar (50))

create table person of Person

Employee relation type is considered.
create type Employee under Person (salary integer)

create table employee of Employee under person

Student relation type is considered...

b.

Explanation of Solution

SQL query to find the names of all people who are not secretaries

Query

select name from person where not exists

(select value(e) from employee e where value(e) is of (Secretary))

Explanation

The “is of” type predicate is used to test object instance of a particular subtype or not...

c.

Explanation of Solution

SQL query to print the names of people who are neither employees nor students

Query

select name from person where not exists

((select value(p) from person p where value(p) is of (employee)) and (select value(p) from person p where value(p) is of (student))...

d.

Explanation of Solution

Reason for not creating a person who is an employee and a student

“No”, a person who is both an employee and a student cannot be created.

Reason

Structured Query Language (SQL) does not support multiple inheritance.

Different tables are used to store an employee or a student...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Help! How do I turn the flowchart that searches for a name in an array of names into structured and spaced pseudocode?

The mail merge process has ____ steps. Question 19Select one: a. five b. six c. seven d. eight

If you created a main document based on an existing document entitled "Confirmation Letter," what default filename would Word give the main document? Question 14Select one: a. Confirmation Letter-1 b. Confirmation Letter-merge c. Document1 d. MergedDocument1

Answer 2

Expert Solution & Answer

Chapter 8, Problem 12E

a.

Explanation of Solution

SQL schema definition

Person relation type is considered.
create type Person (ID integer, name varchar (30), address varchar (50))

create table person of Person

Employee relation type is considered.
create type Employee under Person (salary integer)

create table employee of Employee under person

Student relation type is considered...

b.

Explanation of Solution

SQL query to find the names of all people who are not secretaries

Query

select name from person where not exists

(select value(e) from employee e where value(e) is of (Secretary))

Explanation

The “is of” type predicate is used to test object instance of a particular subtype or not...

c.

Explanation of Solution

SQL query to print the names of people who are neither employees nor students

Query

select name from person where not exists

((select value(p) from person p where value(p) is of (employee)) and (select value(p) from person p where value(p) is of (student))...

d.

Explanation of Solution

Reason for not creating a person who is an employee and a student

“No”, a person who is both an employee and a student cannot be created.

Reason

Structured Query Language (SQL) does not support multiple inheritance.

Different tables are used to store an employee or a student...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Expert Solution & Answer

Chapter 8, Problem 12E

a.

Explanation of Solution

SQL schema definition

Person relation type is considered.
create type Person (ID integer, name varchar (30), address varchar (50))

create table person of Person

Employee relation type is considered.
create type Employee under Person (salary integer)

create table employee of Employee under person

Student relation type is considered...

b.

Explanation of Solution

SQL query to find the names of all people who are not secretaries

Query

select name from person where not exists

(select value(e) from employee e where value(e) is of (Secretary))

Explanation

The “is of” type predicate is used to test object instance of a particular subtype or not...

c.

Explanation of Solution

SQL query to print the names of people who are neither employees nor students

Query

select name from person where not exists

((select value(p) from person p where value(p) is of (employee)) and (select value(p) from person p where value(p) is of (student))...

d.

Explanation of Solution

Reason for not creating a person who is an employee and a student

“No”, a person who is both an employee and a student cannot be created.

Reason

Structured Query Language (SQL) does not support multiple inheritance.

Different tables are used to store an employee or a student...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Expert Solution & Answer

Chapter 8, Problem 12E

a.

Explanation of Solution

SQL schema definition

Person relation type is considered.
create type Person (ID integer, name varchar (30), address varchar (50))

create table person of Person

Employee relation type is considered.
create type Employee under Person (salary integer)

create table employee of Employee under person

Student relation type is considered...

b.

Explanation of Solution

SQL query to find the names of all people who are not secretaries

Query

select name from person where not exists

(select value(e) from employee e where value(e) is of (Secretary))

Explanation

The “is of” type predicate is used to test object instance of a particular subtype or not...

c.

Explanation of Solution

SQL query to print the names of people who are neither employees nor students

Query

select name from person where not exists

((select value(p) from person p where value(p) is of (employee)) and (select value(p) from person p where value(p) is of (student))...

d.

Explanation of Solution

Reason for not creating a person who is an employee and a student

“No”, a person who is both an employee and a student cannot be created.

Reason

Structured Query Language (SQL) does not support multiple inheritance.

Different tables are used to store an employee or a student...

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Expert Solution & Answer

Answer 6

Expert Solution & Answer

Answer 7

Chapter 8, Problem 12E

a.

Explanation of Solution

SQL schema definition

Person relation type is considered.
create type Person (ID integer, name varchar (30), address varchar (50))

create table person of Person

Employee relation type is considered.
create type Employee under Person (salary integer)

create table employee of Employee under person

Student relation type is considered...

b.

Explanation of Solution

SQL query to find the names of all people who are not secretaries

Query

select name from person where not exists

(select value(e) from employee e where value(e) is of (Secretary))

Explanation

The “is of” type predicate is used to test object instance of a particular subtype or not...

c.

Explanation of Solution

SQL query to print the names of people who are neither employees nor students

Query

select name from person where not exists

((select value(p) from person p where value(p) is of (employee)) and (select value(p) from person p where value(p) is of (student))...

d.

Explanation of Solution

Reason for not creating a person who is an employee and a student

“No”, a person who is both an employee and a student cannot be created.

Reason

Structured Query Language (SQL) does not support multiple inheritance.

Different tables are used to store an employee or a student...

Answer 8

Chapter 8, Problem 12E

a.

Explanation of Solution

SQL schema definition

Person relation type is considered.
create type Person (ID integer, name varchar (30), address varchar (50))

create table person of Person

Employee relation type is considered.
create type Employee under Person (salary integer)

create table employee of Employee under person

Student relation type is considered...

Answer 9

Chapter 8, Problem 12E

a.

Explanation of Solution

SQL schema definition

Person relation type is considered.
create type Person (ID integer, name varchar (30), address varchar (50))

create table person of Person

Employee relation type is considered.
create type Employee under Person (salary integer)

create table employee of Employee under person

Student relation type is considered...

Answer 10

b.

Explanation of Solution

SQL query to find the names of all people who are not secretaries

Query

select name from person where not exists

(select value(e) from employee e where value(e) is of (Secretary))

Explanation

The “is of” type predicate is used to test object instance of a particular subtype or not...

Answer 11

b.

Explanation of Solution

SQL query to find the names of all people who are not secretaries

Query

select name from person where not exists

(select value(e) from employee e where value(e) is of (Secretary))

Explanation

The “is of” type predicate is used to test object instance of a particular subtype or not...

Answer 12

c.

Explanation of Solution

SQL query to print the names of people who are neither employees nor students

Query

select name from person where not exists

((select value(p) from person p where value(p) is of (employee)) and (select value(p) from person p where value(p) is of (student))...

Answer 13

c.

Explanation of Solution

SQL query to print the names of people who are neither employees nor students

Query

select name from person where not exists

((select value(p) from person p where value(p) is of (employee)) and (select value(p) from person p where value(p) is of (student))...

Answer 14

d.

Explanation of Solution

Reason for not creating a person who is an employee and a student

“No”, a person who is both an employee and a student cannot be created.

Reason

Structured Query Language (SQL) does not support multiple inheritance.

Different tables are used to store an employee or a student...

Answer 15

d.

Explanation of Solution

Reason for not creating a person who is an employee and a student

“No”, a person who is both an employee and a student cannot be created.

Reason

Structured Query Language (SQL) does not support multiple inheritance.

Different tables are used to store an employee or a student...

Answer 16

Expert Solution & Answer

Answer 17

Expert Solution & Answer

Answer 18

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 19

Ch. 8 - Prob. 1PE Ch. 8 - Prob. 3PE Ch. 8 - Prob. 4PE Ch. 8 - Consider the E-R diagram in Figure 8.7 showing...Ch. 8 - Consider the relational schema shown in Figure...Ch. 8 - Compute the relevance (using appropriate...Ch. 8 - Prob. 8PE Ch. 8 - Prob. 10E Ch. 8 - Prob. 11E Ch. 8 - Prob. 12E

Explanation of Solution

Explanation of Solution

SQL query to find the names of all people who are not secretaries Query select name from person where not exists (select value(e) from employee e where value(e) is of (Secretary)) Explanation The “is of” type predicate is used to test object instance of a particular subtype or not...

Explanation of Solution

SQL query to print the names of people who are neither employees nor students Query select name from person where not exists ((select value(p) from person p where value(p) is of (employee)) and (select value(p) from person p where value(p) is of (student))...

Explanation of Solution

Reason for not creating a person who is an employee and a student “No”, a person who is both an employee and a student cannot be created. Reason Structured Query Language (SQL) does not support multiple inheritance. Different tables are used to store an employee or a student...

Want to see the full answer?

Chapter 8 Solutions

SQL query to find the names of all people who are not secretaries

Query

select name from person where not exists

(select value(e) from employee e where value(e) is of (Secretary))

Explanation

The “is of” type predicate is used to test object instance of a particular subtype or not...

SQL query to print the names of people who are neither employees nor students

Query

select name from person where not exists

((select value(p) from person p where value(p) is of (employee)) and (select value(p) from person p where value(p) is of (student))...

Reason for not creating a person who is an employee and a student

“No”, a person who is both an employee and a student cannot be created.

Reason

Structured Query Language (SQL) does not support multiple inheritance.

Different tables are used to store an employee or a student...