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

using r language for integration theta = integral 0 to infinity (x^4)*e^(-x^2)/2 dx (1) use the density function of standard normal distribution N(0,1) f(x) = 1/sqrt(2pi) * e^(-x^2)/2 -infinity <x<infinity as importance function and obtain an estimate theta 1 for theta set m=100 for the estimate whatt is the estimate theta 1? (2)use the density function of gamma (r=5 λ=1/2)distribution f(x)=λ^r/Γ(r) x^(r-1)e^(-λx) x>=0 as importance function and obtain an estimate theta 2 for theta set m=1000 fir the estimate what is the estimate theta2? (3) use simulation (repeat 1000 times) to estimate the variance of the estimates theta1 and theta 2 which one has smaller variance?

using r language A continuous random variable X has density function f(x)=1/56(3x^2+4x^3+5x^4).0<=x<=2 (1) secify the density g of the random variable Y you find for the acceptance rejection method. (2) what is the value of c you choose to use for the acceptance rejection method (3) use the acceptance rejection method to generate a random sample of size 1000 from the distribution of X .graph the density histogram of the sample and compare it with the density function f(x)

using r language a continuous random variable X has density function f(x)=1/4x^3e^-(pi/2)^4,x>=0 derive the probability inverse transformation F^(-1)x where F(x) is the cdf of the random variable X

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