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.

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

instructor rank employee salary person ID name address student tot_credits secretary hours_per_week

instructor rank employee salary person ID name address student tot_credits secretary hours_per_week

Step by Step Solution

★★★★★

3.40 Rating (178 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

ANSWER a CREATE TABLE person ID INT name VARCHAR50 address VARCHAR50 PRIMARY KEY ID CR... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Database System Concepts Questions!

Q:

Create an appropriate query to find the names of all artists and the instruments they play. Return the data into an Excel table. Then create a pivot table from this table and use it to find a list of...

Q:

Give an SQL schema definition for the employee database of Figure. Choose an appropriate domain for each attribute and an appropriate primary key for each relationschema. employee (employee-name,...

Q:

Give an SQL schema definition for the employee database of Figure 3.19. Choose an appropriate domain for each attribute and an appropriate primary key for each relation schema. Include any...

Q:

Consider the E-R diagramin Figure, which contains composite, multivalued and derived attributes. a. Give an SQL: 1999 schema definition corresponding to the E-R diagram. Use an array to represent the...

Q:

Consider the E-R diagram in Figure 8.7 showing entity set instructor. Give an SQL schema definition corresponding to the E-R diagram, treating phone number as an array of 10 elements, using Orac/8le...

Q:

Define the contextual-equivalence relation ` M =ctx M0 : for pairs of PCF terms M, M0 , PCF types , and PCF type environments . [3 marks] (ii) For PCF terms M and N with respective typings ` M : and...

Q:

A creative engineer suggests structuring the TLB so that not all the bits of the presented address need match to result in a hit. Suggest how this might be achieved, and what might be the costs and...

Q:

i know its a long project but please answer it based on the format below 1-Introduction 2-Data Requirements and Conceptual Design 3-Database Construction and Population 4-Querying the Database...

Q:

i need this project based on the format below anything else won't be acceptable by my teacher please and thank you . 1. Introduction 2. Data Requirements and Conceptual Design 3. Database...

Q:

the following relational algebra questions based on tables S1 and S2 (below) Question 1 What is the output of S1 S2 ? The row identified by sid 22 The rows identified by sid 31 and 58 The row...

Q:

Given the generator matrix G= 1 0 0 0 0 1 1 1 0 0 1 0 1 0 0 0 1 0 1 1 0 0 0 0 1 1 1 1 corresponding to the encoding function e: B B7, find the corresponding parity check matrix and use it to decode...

Q:

Write a paper about Policy and Implementation in Network Security.

Q:

A sale on credit ends up on the income statement as revenue and as what on the balance sheet?Group of answer choicesShort - term liabilityOperating cash flowLong - term assetsAccounts receivable

Q:

6. Suppose that the opportunity-cost ratio for watches and cheese is 1C 1W in Switzerland but 1C 4W in Japan. At which of the following international exchange ratios (terms of trade) will...

Q:

A company named RT&T has a network of n switching stations connected by m high-speed communication links. Each customers phone is directly connected to one station in his or her area. The engineers...

Q:

A graph G is bipartite if its vertices can be partitioned into two sets X and Y such that every edge in G has one end vertex in X and the other in Y. Design and analyze an efficient algorithm for...

Q:

Computer networks should avoid single points of failure, that is, network vertices that can disconnect the network if they fail. We say an undirected, connected graph G is biconnected if it contains...

Q:

Question 6 (1 point) Revenue and Sales Returns are accounts shown on the Statement of Income True False Question 7 (1 point) Investing activities on a statement of cash flows deal with the principle...

Q:

Question 24 (2 points) If the prevailing interest rate is 5%, which of the following bonds will trade at a discount? Select all that apply. Bond

Q:

A stock had returns of 18 percent, 16 percent, 12 percent, -7 percent, 15 percent, and 5 percent over the last six years. Required: (a) What is the arithmetic return for the stock? (Click to select)...