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

We want to get an idea of how many tickets we have and what our issues are. Print the ticket ID number, ticket description, ticket priority, ticket status, and, if the information is available, employee first name assigned to it for our records. Include all tickets regardless of whether they have been assigned to an employee or not. Sort it alphabetically by ticket status, and then numerically by ticket ID, with the lower ticket IDs on top.

Figure 1 shows an ASM chart representing the operation of a controller. Stateassignments for each state are indicated in square brackets for [Q1, Q0].Using the ASM design technique:(a) Produce a State Transition Table from the ASM Chart in Figure 1.(b) Extract minimised Boolean expressions from your state transition tablefor Q1, Q0, DISPATCH and REJECT. Show all your working.(c) Implement your design using AND/OR/NOT logic gates and risingedgetriggered D-type Flip Flops. Your answer should include a circuitschematic.

A controller is required for a home security alarm, providing the followingfunctionality. The alarm does nothing while it is disarmed (‘switched off’). It canbe armed (‘switched on’) by entering a PIN on the keypad. Whenever thealarm is armed, it can be disarmed by entering the PIN on the keypad.If motion is detected while the alarm is armed, the siren should sound AND asingle SMS message sent to the police to notify them. Further motion shouldnot result in more messages being sent. If the siren is sounding, it can only bedisarmed by entering the PIN on the keypad. Once the alarm is disarmed, asingle SMS should be sent to the police to notify them.Two (active-high) input signals are provided to the controller:MOTION: Asserted while motion is detected inside the home.PIN: Asserted for a single clock cycle whenever the PIN has beencorrectly entered on the keypad.The controller must provide two (active-high) outputs:SIREN: The siren sounds while this output is asserted.POLICE: One SMS…

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