Requirement 2 Write SQL DROP statements that will drop all the tables. Add these statements to the appropriate location within the script file. Requirement 3 Write SQL CREATE TABLE statements to create all the tables. Add these statements to the appropriate location within the script file. Business rules: ✓ All tables must have primary key constraints matching the requirements of the ERD. ✓ All tables must have appropriate foreign key constraints. ✓ Each foreign key column must have an identical column name, data type and size of the primary key that it refers to. ✓ Add any NOT NULL constraints as dictated by the ERD. ✓ All constraints must be named using naming conventions used in the INF10004 unit. ✓ The following column names, data types and sizes must be used. Wrkid, tskid, yearsservice Wrkname, status, tskdescription Wrkgender, categorytype HourlyRate Number (4) Varchar (30) Varchar (1) Number (5,2) ✓ A check constraint named CK_ALLOCATION_RATE must be created to ensure that the HourlyRate is in the range of 0.00 to 299.99 ✓ A check constraint name CK_WORKER_wrkgender must be created to ensure that the worker gender values must be M or F

Q: ask 16: List the invoice number and invoice date for each invoice that was created for James…

A: The given is database problem where multiple tables are needed to join to get the required result.

Q: Task 7: Create a procedure to add a row to the INVOICES table. CALL ADD_INVOICE('00001',…

A: Name of the procedure - ADD_INVOICE Name of relation - INVOICES Suppose datatype of INVOICE_NUM,…

Q: Task 7: Create a view named INVOICE_TOTAL. It consists of the invoice number and invoice total for…

A: Actually, database is a used to stores the data\information.

Q: Switch to the Melbourne Swim Teams In cell B14, use the INDEX function to display the value in the…

A:

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

Q: Q1) List the products that are supplied by a vendor

A: SQL command is used to create and manipulate data with the help of DDL (data definition language)…

Q: Question 1: Modify the select statement in this section to display the hire_date column in the…

A: SQL which refers to the  domain specific that are used for the language and  in the programming and…

Q: Task 6: Add the following record to the OWNER table: INSERT INTO OWNER VALUES('SA100', 'Sam',…

A: Attached the Procedure to add the following record to the OWNER table:   INSERT INTO OWNER…

Q: Create the UPDATE_INVOICE procedure to change the date of the invoice whose number is stored in…

A: It enables to save query with a name so that it can be executed whenever required rather than…

Q: Create a trigger named trg_cust_charge that will automatically update the CUSTOMER table’s…

A: Create a view named "Atlanta_Charter_Crew_V” that includes the following “For each charter of…

Q: Select one of the following: (only one please) Display painters’ details who exhibit their…

A: It is defined as the collection of information that is organized so that it can be easily accessed,…

Q: Q1) Please write. a query statement from emp table to display deptno 10’s empno, ename, sal, and a…

A: --> As new_sale is increased 15% that means it increases by 115 out of 100% which is 115/100 =…

Q: I have the following SQL Script: CREATE OR REPLACE TRIGGER SCSP_VIEW_UPDATE INSTEAD OF UPDATE ON…

A: We have to create   How to add logic so that blanks and empty strings cannot be used to update…

Q: Oracle 12c: SQL Chapter Two Textbook Assignment Q1 Create a report showing ALL data from the…

A: According to the information given:- We have to write sql query for the following scenario

Q: SQL code Select the idLitCharacters, name, Gender, Creature SubType. You newest author wants a…

A: SOLUTION -two criteria you've specified:Female Pirates:Gender is 'Female'.Creature SubType is…

Q: The Magazine table contains three fields. The Cost field is numeric. The Code and Name fields…

A: SELECT * FROM MagazineWHERE Cost>amt1 AND Cost<amt2;

Q: Create a stored procedure named prc_new_rental to insert new rows in the RENTAL table. The procedure…

A: A stored procedure called prc_new_rental has been developed in response to the request to help with…

Q: True/False 11. The product of two tables is the table created by combining every row in the first…

A: 11.The product of two tables is the table created by combining every row in the first table with…

Q: WEEK 9 SQL ASSIGNMENT   Part I: Complete the following exercise:   Create the following table with…

A: As per our guidelines, we are supposed to answer only 1st three parts. Kindly repost the remaining…

Q: Create the ADD_INVOICE procedure to add rows to the INVOICE table. (

A: A SQL Procedure is created by writing the keyword "CREATE PROCEDURE" then procedure name i.e.,…

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

A: Big Data SQL: Big data SQL or structured query language can be regarded as a base or medium of…

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: The table VideoVisitFact has a single primary key column of VideoVisitKey. The column is numeric.…

A: The table VideoVisitFact has a single primary key column of VideoVisitKey. We need to find query…

Q: When should you use the %ROWTYPE attribute in creating a record variable? Answers: a. when using…

A: Required: when use %ROWTYPE

Q: Create the UPDATE_INVOICE procedure to change the date of the invoice whose number is stored in…

A: We need to create an UPDATE_INVOICE procedure to change the date of the invoice whose number is…

Q: elp understanding / installing phpmyadmin and if i need wamp server aswell and where to copy and…

A: SELECT product_code, product_name, list_price, discount_percent FROM products ORDERBY list_price…

Q: Use SQL to complete the following exercises. Provide SQL screenshots of the resutls of both…

A: 1)CREATE TABLE REP (   REP_ID char(2) PRIMARY KEY,   FIRST_NAME char(20),   LAST_NAME varchar(20),…