2 Write a SQL Command to Insert the records in the following tables CUSTOMER88 TABLE: CUST ID CUST NAME INDICATOR DATE OF VISIT CONST FEES MOBILE 93523655 80001 SUHAIL HEADACHE 13-JAN-2018 250.000 80002 MUNA ALI HEART 20-FEB-2018 350.000 92563277 80003 MOHAMMED FEVER 01-MAR-2018 150.000 98745621 SPECIALIST88 TABLE : DOCTOR ID DOCTOR NAME SPECIALIST GSM CUST ID 10001 AHMED ANSARI GENERAL 95623563 80001 10002 MUSA MOHAMED HEART 96586142 80002 10003 FATHIMA AHMED GENERAL 98653245 80003 10004 NOOR MOHAMED ORTHO 96532157 80001 10005 MARWA AHMED ENT 98856232 80003

Q: in pl /sql the commend is like this  create table bb_basketstatus (idstatus number, idbasket…

A: The answer for the given question is as follows.

Q: Based on the following SQL statement: SELECT acct_id, balance FROM Account WHERE balance < 0 AND…

A:

Q: Q2/ write SQL commands to create tables of a Bank database, where these tables will have the…

A:

Q: CREATE SEQUENCE ORD_SEQ Increment by 10 Start with 120 Maxvalue 9999 Nocycle;   CREATE TABLE…

A: Nearby answer is : 1 and 3 for,  1 : An error will occur because you cannot use SYSDATE in the…

Q: Emp.id Name 001 JACK 002 Omar 003 Madeline 004 Macarthur 005 Rafael Job.id ceo dept.man dir.man…

A: First we need to create a table named Employees and store those value in the table. After that run…

Q: i. Using SQL, write the command to insert the values in the Client table. sid Sname address age…

A: refer step 2

Q: based on the information below create a oracle SQL table and insert some values into each table.…

A: CREATE TABLE Publisher (name varchar2(20) NOT NULL, phone number(10) NOT NULL, city varchar2(15)…

Q: Which of the following SQL statements determines how many total customers were referred by other…

A: The statement with COUNT (referred) function counts the rows of non null data that exist in the…

Q: Given the following table TABLE CUSTOMER Column Null? Туре CUS_ID NOT NULL NUMBER NAME VARCHAR2(50)…

A: B. SELECT cus_id "Customer_id", name From customer: It will  show error due to "Customer_id". C.…

Q: Write the SQL statements for the following User table. User_id Name City Order_date Purchase_amount…

A: To create a table in SQL, create table command is used. Ans 1. The required query is: CREATE TABLE…

Q: 2) Create in PL/SQL a stored procedure called 'Del Details' to delete the record of orderedProduct…

A: 1)  Below is the stored procedure to Delete the details from OrderedPRoduct.  we use the create or…

Q: Create a PL/SQL query to display the invoice number, coin name, coin price and delivery notes. In…

A: create the table Bill which contains the following fields, Bill number product price delivery note…

Q: Problem 3: Determine the output SQL> desc courseinfo; Name Null? Туре VARCHAR2 (4) VARCHAR2 (25)…

A: To Find the output for the given query statement.

Q: Create the DONORS table with the following columns:  donor_id ( PRIMARY KEY), donor_name (Not Null),…

A: According to the guidelines, we are supposed to answer the 1st question, please re-upload the other…

Q: Q2/ write SQL commands to create tables of a Bank database, where these tables will have the…

A: Syntax for creating sql tables:-  create table tableName(column_name1 datatype, column_name2…

Q: Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table?…

A: Tables are database objects that contain all the data in a database. In tables the data is logically…

Q: Q2/ The difference between the results of executing the following two SQL commands: delete from…

A: Answer to the given question: delete from Employee: will delete all the tuples from the Employee…

Q: Which line in the following SQL statement raises an error? (refer to the tables in the JustLee Books…

A: In line 3, the error will be raised.

Q: Using the EMP_2 table, write a single SQL command to change the EMP_PCT value to 5.00 for the people…

A: The Error 1175 is specific to SQL Workbench and keeps occurring because safe-update options is set.…

Q: The SQL command CREATE TABLE EMPLOYEE_BACKUP AS SELECT * FROM EMPLOYEE creates a new table named…

A: CREATE TABLE AS Statement: The SQL CREATE TABLE AS statement used to create a table from an…

Q: Create a PL/SQL query to display the combined customer name, coin purchased, coin price and the…

A: SQL Query:   Query Output:

Q: Write the set of SQL commands necessary to insert the data into the CUSTOMER table

A: NAME: CUSTOMER COLUMNS: CUST_NUM, CUST_LNAME, CUST_FNAME, CUST_BALANCE

Q: Write the following SQL queries based on the following relational schema: Student (stdID: char(5),…

A: Ans:- So let’s start solving the problem here I give the complete SQL query of the problem and…

Q: Write a PL/SQL block to select and display the names of all students who scored more than the…

A: Given values, Student_ID Name of Student Marks Obtained Department_ID  1 Asma  78 1 2 Anwar…

Q: 4. Write the SQL code that will save the changes made to the EMP_1 table (if supported by your…

A: Given Information : Table name = EMP_1 Attributes : JOB_CODE EMP_NUM

Q: a. Find all movies with a cost less than or equal to the average moVies cost b. Write a query to…

A: Select Query:          It will retrieve data from the table.         select * from table name;…

Q: Please help with the following: Using oracle sql live or sql developer what sql statements could be…

A: 1.List all the rows in which the prescription dates occur on or after November 14. SELECT * FROM…

Q: 4. Display how many number of year from the date_of _visit as on System Date? 5. Write a SQL Command…

A: Given:

Q: NFO 2303  Database Programming Assignment  : PL/SQL Practice   Note: PL/SQL can be executed in…

A:

Q: 1. SQL Exercise a) Write the SQL Command [//WRITE CODE HERE] name, salary, department [//WRITE CODE…

A: Solution -   A.)  In this problem we need to solve the sql query SQL command --&gt;  Select name,…

Q: 7. Which of the following value will match the condition LIKE '_B_ a. XBY b. 8. с. 183 d. All the…

A: 7. LIKE '_B_' will match with XBY,_B_,1B3 So Correct Option is All the Above    8.  Sql IN keyword…

Q: Use JOINS (inner,  self, left and right, cross and full ) in these tables with sql:

A: SQL INNER JOIN:-The INNER JOIN keyword selects records that have matching values in both…

Q: PLZ help with the following: Use oracle live sql to change the following commands so that they work…

A: To insert records into autoincrement table. Only specify values to column which is not…

Q: how can I write an SQL SELECT Queries for each of the information requests?   List the…

A: Given: how can I write an SQL SELECT Queries for each of the information requests?   List the…

Q: Given the following table: Student ( id, first_name, last_name, address, program, phone), which of…

A: Here there are multiple questions asked so I have given answer of first 3 question so post remaining…

Q: Write an anonymous PL/SQL block that will delete all patients for doctors that works in the Family…

A: Since I don't have access to the database, I am writing the general syntax of deleting the rows from…

Q: 1.Write SQL Command to, display employee id and ob id who gets salary within the range of 4000 and…

A: SELECT keyword is used to display particular columns  BETWEEN is the keyword used to specify the…

Q: Write down the SQL commands for the following queries: a) Find the titles of all courses from your…

A: Find the department id which is CSE department Then filter out the records having same department id…

Q: Write Create Table SQL statements based on the above ERD. All tables must have primary keys. All…

A: Given diagram contains entities Book, Allocation and Author. These entities attributes are: Book-…

Q: Assume you have these tables.. Q) Write in SQL queries to populate the above tables by inserting…

A: Tuple, in SQL is a basically a single row in the relational database table. This row consists of…

Q: d. Create a NewMember table with only using the membership name (Fname and Lname) and membership…

A: Create tables and insert data into it.  Subqueries allow you to write queries that pick data rows…

Q: 1. SQL Exercise a) Write the SQL Command [//WRITE CODE HERE] name, salary, department [//WRITE CODE…

A: In structure query language the Select * statement is used to Select all rows from given table with…

Q: Using this tables.. Write in SQL queries to populate the above tables by inserting minimum 4 tuples…

A: A single row in database is called tuple. To insert multiple row in a table, use INSERT statement…

Q: Write queries in SQL to answer each of the following questions: 1. Find all students in Comp.…

A: SQL is a standard language for storing, manipulating and retrieving data in databases.

Q: use EMP and DEPT tables, in the Live SQL, to perform the following operations. 1- List the…

A: create table dept( deptno number(2,0), dname varchar2(14), loc varchar2(13), constraint pk_dept…

Q: 5. Write a SQL query to find the maximum, minimum, and average salary of the employees. 6. Write an…

A: Given, Table EmployeeDetails: EmpId FullName ManagerId DateOfJoining City 121 John Snow 321…

Q: Write SQL Queries for following Employee table : EMPLOYEE_ID| Name EMAIL HIRE_DATE SALARY DEPARTMENT…

A: Note: Since we only answer up to 3 sub-parts, we’ll answer the first 3. Please resubmit the question…

Q: Write SQL commands for following customer table: CustomerID Cust_Name Age Address Order_amount 101…

A: 1. Write a query to create a customer table containing above columns, whereas customer id as primary…

Q: a. Write the sql command to search for the employees who's hire date are before 2011 b. Write the…

A: As per the guidelines i solved first three sub questions and i considered name of this table is…

Q: PLZ HELP WITH THE FOLLOWING

A: All the highlighted parts are the edited code. There were lot of mistakes in the code   CREATE TABLE…