Database name: Ch03_Theater Table name: DIRECTOR DIR_NUM DIR LNAME DIR DOB 100 Broadway 101 Hollywoody 18-Nov-53 102 Goofy 12-Jan-65 21-Jun-62 Table name: PLAY PLAY CODE PLAY NAME DIR NUM 1001 Cat On a Cold, Bare Roof 1002 Hold the Mayo, Pass the Bread 102 101 1003 I Never Promised You Coffee 102 1004 Silly Putty Goes To Washington 1005 See No Sound, Hear No Sight 100 101 1006 Starstruck in Biloxi 102 1007 Stranger In Parrot ice 101

Q: borrowerNo B023 B141 B687 name Ted Brown Irina Petkevits Nancy Herman dateOfBirth address email…

A: From both the tables-  Foreign Key – is a column that creates a relationship between two tables. The…

Q: Create data base 4 table about Oscar Award : 1-actor 2-actress 3-movie 4-Nominations

A: Here are the tables regarding Oscar:

Q: (c) Construct a proper SQL query for the following questions. i. Display the names, age, date of…

A: The current scenario here is to write the query for the following. 1. solution: SELECT First Name,…

Q: 4. Show the result of the following queries as it would apply to the database state given above. 1.…

A: All distinct student names from Student table whose Major is CS are displayed Name Smith…

Q: 1. Use the following table to answer the questions below. Table name: Products Column Role Data Type…

A: We have to extract year from the Date filed and then the year has to be 2021  Now, we have to count…

Q: lter table product so that column productlype is an integer instead of a varchar, not null should be…

A: Lets see the solution.

Q: Given that information ERD and EERD. draw the dependency diagram 1NF,2NF and 3NF. Make sure that you…

A: ER diagram

Q: Develop a simplified SQL query Display schedule_id, source, destination and travel_time which has…

A: Required: We need to create a task that displays travel_time, source, destination, and schedule_id…

Q: regions REGION_ID NUMBER REGION_NAME VARCHAR2(25) departments DEPARTMENT_ID NUMBER DEPARTMENT NAME…

A: Please find the respective SQL statements for the queries: We use aggregate functions like count and…

Q: In computer terminology, what is optimum performance?

A: To be determine: In computer terminology, what is optimum performance?

Q: Some data can be represented using nested Tables. A Table is considered nested when its parent…

A: The nested table in HTML means creating a table on a webpage inside another table on the same web…

Q: Name the candidate keys in the following table: Student L number Student_Name Student SS Number…

A: a candidate key is a super key which has no redundant attribute.

Q: a Write in SQL a command that creates the table Products according to the above description a. Write…

A: Given :

Q: Answer the following questions then copy your code to a text document (with print screens) and…

A: As per our guidelines we are suppose to answer only first three questions. Kindly repost other…

Q: QLite query: What is the name of the customer who purchased the most Classical tra

A: SQL Queries Description:   1- The name of the customer who purchased the most Classical tracks? This…

Q: What exactly is an ID column?

A: Introduction: Column for identifying yourself

Q: Using SQL, insert at least 2 rows for each table. CourseCodes-SCI1 and SCI2 and one section each in…

A: Please check the step 2 for solution

Q: Q16) List the V_CODE and V_NAME of vendors that provide products Q8) List the product description,…

A: Structured Query Language is abbreviated as SQL or also pronounced as See-Qwell. It is developed for…

Q: The PatientDim table contains a column, Name. which of the following SELECT clauses will make…

A: Alias for column or table: Alias indicates that create an duplicate name for the column where the…

Q: hich one is correct Select the constraint (if any) that is violated by each the following operations…

A: Here table student_course contains primary key of table student and course.  Now we are deleting…

Q: Enter ID: Add ID ID 123 abc 123abc abc123 54321 Remove All Item Name Price Number of Rows: 5

A: The HTML CSS JS code is given below with output screenshot

Q: ormalized 3nf int.

A: 1NF (First Normal Form): A relation is in 1NF if every attribute value in a tuple is atomic, i.e.,…

Q: Add a CHECK constraint on the BEDROOOM column in the ROOMS table. It must accept a value from 1 to 5…

A: CHECK is the keyword used for CHECK constraint and after table has created, if you want to add this…

Q: How is the number of columns in a Web table determined? What adjustment do you have to make when a…

A: Explanation: Table property allow the web developers to present the data in rows and columns…

Q: How many actors stared in the film titled “BREAKING HOME”? Display: number of actors

A: SOLUTION - How many actors stared in the film titled “BREAKING HOME”? Below is the query -   SELECT…

Q: Table : PURCHASE_ORDER ORDER_NO AMOUNT ORDER DATE CUSTOMER_ID SALESMAN ID DELIVERY_ DATE 1001 300…

A: b) SELECT * FROM PURCHASE_ORDER INNER JOIN PURCHASE_DETAILS ON PURCHASE_ORDER.ORDER_NO =…

Q: Normalise the data :

A: Q

Q: Find the names and surnames of the customers who received the "Kalem" in 2018 but did not receive it…

A: Note: we have provided answer according to table and attributes mention in picture part. we need to…

Q: Drow ER diegram please

A: ER diagram is the graphical representation of the relationship between an entity and its attributes.…

Q: MySql Workbench CREATE TABLE students (   id INT PRIMARY KEY,   first_name VARCHAR(50),   last_name…

A: As per Bartleby's rules, we can answer the first 3 subparts of a question I have answered Q 1, 2 3…

Q: Develop a simplified SQL query Display schedule_id, source, destination and travel_time which has…

A: Required:    Write  SQL query to display schedule_id, source, destination, and travel_time which has…