FIGURE Q3.18 The Ch03_Theater Database Tables Table name: DIRECTOR DIR_NUM DIR LNAME DIR DOB 100 Broadway Database name: Ch03_Theater | 12-Jan-65 101 Hollywoody 18-Nov-53 102 Goofy | 21-Jun-62 Table name: PLAY PLAY CODE PLAY NAME 1001 Cat On a Cold, Bare Roof 1002 Hold the Mayo, Pass the Bread 1003 I Never Promised You Coffee 1004 Silly Putty Goes To Washington DIR NUM 102 101 102 100 1005 See No Sound, Hear No Sight 101 1006 Starstruck in Biloxi 102 1007 Stranger In Parrot Ice 101 Use the database shown in Figure Q3.18 to answer Problems 4-7. 4. Identify the PK and FK for both tables as shown in figure 3.18 Tablename PK FK 5. Create the ERD for the above tables using the Chen and Crow's Foot Model. 6. Draw the relational diagram for DIRECTOR and PLAY.

Q: 5. The HAVING clause can be used only with ...

A: Having clause is used to perform selection operation on the groups we have selected at the output…

Q: The WHERE statement identifies the. Sort None of these Filter All of these Table Fields

A: The WHERE statement identifies the

Q: Write the corresponding syntax of the given SQL statements. Using COUNT Clause

A: Given: Write the corresponding syntax of the given SQL statements. Using COUNT Clause

Q: Given a truth table below with the first two columns of truth values provided: b. f(p,a) T. F T ? 4.…

A: I have solved the question and uploaded image for it. NOTE: ^ - AND V - OR XOR- A'B+ AB' Please…

Q: Which character kinds are supported by SQL?

A: Algorithm : The actual numeric data types are SMALLINT, INTEGER, BIGINT, NUMERIC(p,s), and…

Q: el Patterson's first and last name are in two

A: Rachel Patterson's first and last name are in two separate columns. Does that make a difference?

Q: I Wrote down QUESTION 7 as shown above. Not Question 1.

A: According to the information given:- As mentioned you need the solution of question 7 for that we…

Q: Customer Ic 8710101022 Amirul 12 8413521122 11 Custom Roo er Name m ld 7311001111 Amran able De…

A:

Q: Can you provide me with the answers to the rest of the questions except Question 8, as shown in the…

A: In this question we have to provide some of the questions which are associated with Haskell…

Q: What is the maximum cardinality?

A: Given: What is the maximum cardinality?

Q: you did not answer question 2

A: A finite state machine is a machine that can, at any point in time, be in a specific state from a…

Q: Name the rules exhange data between computers.

A: Given: Name the rules exhange data between computers.

Q: Show students’ first name and last name, the course numbers the student took (don’t include…

A: Data is coming from 3 tables . So apply inner join on 3 tables with joining condition.  student…

Q: 7. List all customers who were referred to the bookstore by another customer. List each customer’s…

A: The answer to the question is given below:

Q: Product a report showing the distinct first and last names of customers from the state of New York…

A: In the Database , a SQL query which refers to the one it is a request for data from a database. SQL…

Q: What are all the different normalizations?

A: What are all the different normalizations

Q: Explain the SQL function categories

A: Given: Explain the SQL function categories

Q: Determine which types of books are currently available in the current inventory. Each category…

A: Real-world examples can make inventory models easier to understand. The following examples…

Q: Question 14 A fair is visited by at least one visitor. One visitor visits at least one fair. Visitor…

A:

Q: C) Which employees earn less salary than the average salary for the consultants who perform the same…

A: According to the information given:- We have to consider the instruction to write queries on the…

Q: What is the name of the columns of thee left hand side of the relationships between columns called?

A: Here is the solution which is mentioned below:

Q: Write the required SQL statements to create the PET_2 table

A: Here we will create the PET_2 table

Q: price 29.8.29 m sell city store sid S1001 S1002 $1003 store table sid city Union Edison Newark sid…

A: In the ER diagram we can see that we have the three entities those entities are  Store , sell and…

Q: normalize the following Table into 3rd Normal Form.

A: Given :- In the above given question, the statements are mention below as,   Need to explain the…

Q: Up to 10 characters Integer Integer SMITH Employee surname Employee's job title No ID no. of…

A: Given:

Q: 5. Determine the profit of each book sold to Jake Lucas, using the actual price the customer paid…

A: Profit:- Total Revenue - Total Expenses = Profit is how profit is calculated. After deducting all…

Q: Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc.…

A: Hello studentIn SQL querying, crafting precise SELECT statements is crucial to retrieving accurate…

Q: List the names of all Staff members who hold a faculty position and have a salary of $45,000 or…

A: SQL Space: To leave the space while displaying the data ,a function called space is used. Syntax:…