17. Write the SQL statement that will display the following (do not hardcode 'George', 'Lorraine', or any names, in your statement): | Person | Spouse | George | Lorraine
Q: Student Name: Student Number: Write a PL/SQL Program to do the following Your Program should request…
A: Answer is given below-
Q: OB. The function must contain a return statement. Oc.It is similar to the PL/SQL procedure except…
A: Which of the following is not true about the PLSQL functions? OPTION : B
Q: Please develop PL/SQL program that asks for a radius of a circle. After user enters a radius number,…
A: Syntax to implement IF statement: IF condition THEN statements; ELSEIF condition THEN…
Q: Create a PL/SQL Program that asks user to enter 2 numbers, then finds an average of two numbers and…
A: PL/SQL program is : SET SERVEROUTPUT ON;DECLAREv_x NUMBER :=&first;v_y NUMBER…
Q: 5. Use XAMPP Control Panel (My SQL) to answer the following questions. Write SQL queries statement…
A: CODE:- Creating table PROPERTY and inserting values in it:- -- create table PROPERTY CREATE…
Q: Exercise 1: Addresses in Bahrain are identified using three numbers separated using commas and one…
A:
Q: The Midnight Coffee Roastery is running a special on decaf coffee. Write an SQL statement that…
A: GIVEN: The Midnight Coffee Roastery is running a special on decaf coffee. Write an SQL statement…
Q: The system variable that records the select statement that SQL * FORMS most recently used to…
A: Question. The system variable that records the select statement that SQL * FORMS most recently used…
Q: Create a program (using sQL strings) that willinsert one record, increase by 8 % the unit price of…
A: the answer is given below :
Q: 31-Create a SQL statement to Display the number of clients for each CType with having less than 2…
A: Here we need group the CType using GroupBy clause and then use Having clause to select only those…
Q: Given the following table: Student ( id, first_name, last name, address, program, phone), which of…
A: Given the following table: Student ( id,first_name, last_name, address,program,phone)which of the…
Q: Below is a table description and its data. The table is not in Third Normal Form (3NF). Explain why.…
A: A relation is said to be in the third normal form if only if the relation is in both first normal…
Q: Assume that you have a product code that has the following format: XXXXNNN Where X is a character…
A: Below is the detailed PL/SQL program to separate the code into its two parts as shown in the above…
Q: Write a function called queryData() which will search the customerArray and output the following…
A: <!DOCTYPE html><html><body> <p>Jeff Smith is a 17 year old Male from London,…
Q: Using a SET operator, Display all names that are used both as a last name and a first name. Example:…
A: SET operators are special type of operators which are used to combine the result of two queries.…
Q: Person(Name, Age, Phone, Extension) Find all names whose Extension starts with 5 folllowed by any…
A: we want it to start from 5, have exactly one character in the second place, which is denoted by the…
Q: Write a SQL statement that will display the product ID, product name, and category only products…
A: In Step 2, an SQL statement is given that will display the product id, product name, and category…
Q: A(n) ___________________ is used within a simple condition to compare two values. A index B…
A: Answer: Option A: Index is used in arrays to present the position of the array values so this option…
Q: Assume that you have a product code that has the following format: XXXXNNN Where X is a character…
A: Answer :
Q: Orders Columns: order_id (int), order_no (char(30)), customer_name (char(100)) Order_Line Columns:…
A: Given that two tables data . Orders tabel contains : order_id(int), order_no(char(30)),…
Q: Code should be in Python, please 1. Prompt the user for a title for data. Output the title. Ex:…
A:
Q: Write the SQL statements to create database objects. la. Create a table with the details shown…
A: Note: - As per our guidelines we can only answer one question at a time. Please resubmit the other…
Q: I have this condition in sql and php it searches things but when there is space or line break in…
A: THe solution for the above given question is given below:
Q: Exercise 1: Addresses in Bahrain are identified using three numbers separated using commas and one…
A: According to bartleby guidelines we need to solve only the first question, so please repost the…
Q: Which of the following is not part of a standard SQL statement? a. Importable programming libraries…
A: Below is the answer to above question. I hope this will be helpful for you..
Q: Hello I just need help creating test cases for the functions below. examples: assertequal,…
A: Lets go step by step 1) Validate_name() True:- false:- 2)validate_company True:- False:-…
Q: 9.use the data which is given as shown bwlow to Write a SQL statement to display the most expensive…
A: Answer :-- SELECT product_id,product_name,price from product where price = (Select MAX(price) From…
Q: When SQL statements are embedded inside 3GL, we call such a program as a. Nested query b. Nested…
A: This mcq is based on SQL language.
Q: IN SQL ** Write a query sentence to display the names, jobs, dates of appointment and employee…
A: Given Columns to display: name, job, appointmentDate,empNo Condition: First column has to be empNo…
Q: Q2) Read from the user his height and weight and print his BMI (Body Mass Index) using the following…
A: Program Approach: Get the inputs from the user using Console.WriteLine() Read inputs using…
Q: Indicate what relational expressions are false. (Choose all that apply) O "Mary" "54"
A: Comparision of the strings : The comparison of two strings is calculated based on the ASCII letter…
Q: a. Write the SQL statement that will return the following result FName LName Program Students…
A: SELECT FName, LName, PName, (SELECT COUNT(*) FROM Student WHERE Student.PCode = Staff.PCode) AS…
Q: Write a stored Procedure Which shows the Product having maximum Price.
A: Stored Procedure in SQL: A stored procedure is a SQL code that can be saved, so if the code is…
Q: Oracle language Display the employee’s name whose salary is within a range that is specified by…
A: Select FIRST_NAME from EMPLOYEE where SALARY >= 10000 and SALARY < 30000;
Q: Create a SQL statement to display the table structure of the CLIENTS table.
A: Select statement in SQL is used to display a table . It can be used with where clause to display…
Q: Appointments AppointmentID 1 P1 2 P2 PatientID AppointmentTime AppointmentDate TreatmentID DentistID…
A: As per out guidelines, we are supposed to answer only 1st 3 questions. Kindly repost the remaining…
Q: Do the steps below in microsoft SQL server management studio. -create Authors and Books relations.…
A: Note : As you have posted multiple sub-parts, I am answering 1st 3 sub parts according to the…
Q: Write SQL code that will retrieve patients whose appointment months are the same as with a patient…
A: Let the Table name be Hospital, to get the data from the table here we use LIKE and Not like…
Q: Please develop PL/SQL program that asks for a radius of a circle. After user enters a radius number,…
A: Syntax to implement IF statement: IF condition THEN statements; ELSEIF condition THEN…
Q: Which statement is used to create a user-defined data type?a. Declareb. Define c. Structured.…
A: User-defined data type: The data types such as Integer, Double and Decimal are in-built data types…
Q: Next, write a SQL statement to create a single column relational table MESSAGE to store variable…
A: NOTE: I HAVE ONLY GIVEN THE ANSWER FOR FOURTH PART AS ASKED BY YOU, IF YOU WISH TO HAVE ANSWERS FOR…
Q: Databases are used to store different kinds of data such as names, currency, text, graphics, etc.…
A: GIVEN: Databases are used to store different kinds of data such as names, currency, text, graphics,…
Q: Use the table below to find the output PRODUCT ID PRODUCT NAME BRAND UNIT PRICE SUPPLIER ID CATEGORY…
A: Required:
Q: Code should be in Python Prompt the user for a title for data. Output the title. Ex: Enter a…
A: Solution :: As we know all python programming is a interpreted high-level general-purpose…
Q: write SQL code that involve calculation by using if else statement
A: Syntax- IF (Expression ) BEGIN -- if expression is true True Statements; END ELSE BEGIN…
Q: SQL PROGRAM Create a function that takes Celsius temperature and returns a Fahrenheit
A: function is given below:
Q: Cônsider a database with the following tables: v Patient(PatientlD. PatientName, NumberOfVisits) v…
A: SUMMARY: - Hence, we got the output after applying all the queries.
Q: Execute the following statements using MYSQL: 1.Create a Trigger "trigger regno" for the salesman…
A: Answer 1) ---------------------------------(trigger) CREATE TRIGGER regno BEFORE INSERT ON salesman…
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
- For the remaining questions, use the following table of people: people (id (pk), firstname, lastname, spouse_id (fk)) The table was created as: CREATE TABLE people (id INT NOT NULL AUTO INCREMENT PRIMARY KEY, firstname VARCHAR(30), lastname VARCHAR (30), spouse id INT, CONSTRAINT spouse fk FOREIGN KEY (spouse id) REFERENCES people (id)); This is some sample data: Participation Activity 9 +---- | id | firstname | lastname | spouse_id | + 1 | Marty 2 | Jennifer | McFly | Parker | McFly | Tannen | McFly | | 3 | Lorraine 4 | Biff 5 | George NULL | NULL | 5 | NULL | 3 | +----+--You have the following tables: APARTMENTS (ADDRESS, CITY, STATE, RENTER_ID, RENTER_LAST_NAME) RENTERS (RENTER_ID, FIRST_NAME, LAST_NAME) What is the primary key for the APARTMENTS table? (It may be a composite key involving 2 or more fields) What are the foreign keys, if any? What is the primary key for the RENTERS table? What are the foreign keys, if any? What field in RENTERS can be eliminated so that the RENTERS table is normalized?How many patients in the database have been diagnosed with acute bronchitis (ICD9Code = 466) and have a total of 3 or more diagnoses? (diagnosis table; COUNT(*), WHERE, GROUP BY, & HAVING clauses) / Result = 20
- List unique first (first_name) and last names (last_name) of customers (CUSTOMER table) who rented a movie (RENTAL table) between '2011-06-01' and '2012-01-01’ (rental_date). Sort by last_name. The common key is CUSTOMER_ID.Update table product to set the value of column productType equal to the corresponding id value in the table productType. This requires a SELECT * FROM productType: to see what the id value is for each type. For example, in my database a. 1|meat b. 2| seafood c. 3| vegetable d. 4 grain and rice e. 5 bakerySome rows of the STUDENT table are shown below: CODE NAME GPA YEAR 291 ALEX 3.1 2 938 MICHELE 2.3 1 931 JHON 3.3 1 182 JOE 3.4 2 190 REY 2.0 2 330 RON 3.9 3 Which best describes the result of the query below? SELECT YEAR, AVG(GPA) FROM STUDENT WHERE GPA > 2.0 GROUP BY YEAR a. The average maximum GPA of all the students in each year. b. The year of the student with the maximum GPA. c. The average GPA of students with a GPA higher than 2.0 each year. d. The average GPA of the students with a GPA higher than 2.0.
- The following table stores details of tutors, students and dates of lectures. The Primary Key is (TutorID, StudentID). TutorID TutorName StudentID StudentName Lecture_date T01 Kong S1052 Salim 10-May-19 T01 Kong S1051 Vikram 5-Jul-19 T02 Smith S1052 Salim 10-May-19 Explain why the above table is not in 2nd Normal Form. Normalize the table to 3rd Normal Form.DROP TABLE IF EXISTS Worker; CREATE TABLE Worker ( ); 0 INSERT ); WORKER_ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FIRST NAME TEXT, LAST NAME TEXT, SALARY INTEGER (15), JOINING DATE DATETIME, DEPARTMENT CHAR (25) INTO Worker (WORKER_ID, FIRST_NAME, LAST_NAME, SALARY, JOINING_DATE, DEPARTMENT) VALUES 'Arora', 100000, '14-02-20 09.00.00', 'HR'), (001, 'Monika', (002, 'Niharika', 'Verma' 80000, '14-06-11 09.00.00', 'Admin'), 'HR'), 'Admin'), Admin'), 'Account'), 'Kumar', 75000, '14-01-20 09.00.00', 'Account') DROP TABLE IF EXISTS Bonus; CREATE TABLE Bonus ( ); (003, 'Vishal' 'Singhal', 300000, '14-02-20 09.00.00', (004, 'Amitabh 'Singh', 500000, '14-02-20 09.00.00', (005, 'Vivek' 'Bhati', 500000, '14-06-11 09.00.00'. (006, 'Vipul', 'Diwan' 200000, '14-06-11 09.00.00', (007, 'Satish' (008, 'Geetika', 'Chauhan', 90000, '14-04-11 09.00.00', 'Admin'); WORKER_REF_ID INTEGER, BONUS AMOUNT INTEGER(10), BONUS_DATE DATETIME, FOREIGN KEY (WORKER_REF_ID) REFERENCES Worker (WORKER_ID) ON DELETE…Considering Vaccination Database, write queries to: Display the Subject CNIC, Name, Contact, Dose1 Center, and Dose2 Center as shown below: CNIC Name Contact Dose1 Center Dose2 Center 22401-6645321-1 Nasir 3409991112 Lachi Kohat 2 14301-6045321-5 Shahab 3409991112 kohat 3 Dara The subjects who have been vaccinated different types in Dose1 and Dose2. For instance, subjects who were vaccinated ‘Sinovac’ in the first dose, while Pfizer in the second dose.How many Viles of each type have been consumed so far. How many subjects are vaccinated from expired viles. Suggest the name of Incharge for the best performance award based on the highest number of subjects vaccinated on a single day
- on this table CREATE TABLE students ( std_id int NOT NULL PRIMARY KEY, f_name VARCHAR2(20), l_name VARCHAR2(20), std_address VARCHAR2(50), tel_no VARCHAR2(15), SEX VARCHAR2(10), birthdate date ); use PL/SQL oracle to solve create A Function getAllData(arg): When Your call your function it should search about an item in your table and returns all data about it. arg is int all data are int and varchar2 and dateSQL ( ORACLE SQL DEVELOPER ) : THIS IS FIRST , SECOND AND THIRD TABLE for the Task 1 to solve : create table author_45( auth_name char(50), gender char(1), age number(3), nationality char(50), PRIMARY KEY (auth_name) ); create table book_45( isbn number(10), title char(50), ver_no number(2), publisher char(50), PRIMARY KEY (isbn) ); create table writtenBy_45( isbn number(10), auth_name char(50), yr_published number(4), price number(3), no_copy number(4), PRIMARY KEY (isbn,auth_name), foreign key (isbn) references book_45, foreign key (auth_name) references author_45 ); insert into author_45 values ('Benoit','F',42,'French'); insert into author_ 45 values ('Antonini','M',33,'Italian'); insert into author_ 45 values ('McAven','F',31,'Australian'); insert into author_ 45 values ('Williams','M',90,'British'); insert into book_45 values (101,'atabases',1,'Possum'); insert into book_45 values (202,'SQL Primer',2,'Hall'); insert into book_45 values…in pl/sql ,use Cursor to get all the records from table job_history for employee_id 121