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

Considering the TM example of binary sum ( see attached)do the step-by-step of execution for the binary numbers 1101 and 11. Feel free to use the Formal Language Editor Tool to execute it; Write it down the current state of the tape (including the head position) and indicate the current state of the TM at each step.

I need help on inculding additonal code where I can can do the opposite code of MatLab, where the function of t that I enter becomes the result of F(t), in other words, turning the time-domain f(t) into the frequency-domain function F(s):

I need help with the TM computation step-by-step execution for the binary numbers 1101 and 11. Formal Language Editor Tool can be used to execute it; Write it down the current state of the tape (including the head position) and indicate the current state of the TM at each step;

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...