PLZ help with the following: Use oracle live sql to change the following commands so that they work with creating the table CREATE TABLE `book`( `num` INT(20) NOT NULL AUTO_INCREMENT, `title` VARCHAR(20), `year` DATE, `subject` VARCHAR(20), `checkedout` DATETIME, `checkedin` DATETIME, PRIMARY KEY (`num`) ); CREATE TABLE `client`( `CID` INT(20) NOT NULL AUTO_INCREMENT, `fname` VARCHAR(25), `lname` VARCHAR(25), `type` VARCHAR(25), `num` INT(20), PRIMARY KEY (`CID`), FOREIGN KEY (`num`) REFERENCES `emp`.`state`(`state_id`) ); CREATE TABLE `author`( `id` INT(10) NOT NULL AUTO_INCREMENT, `year` DATE, `fName` VARCHAR(20), `lname` VARCHAR(20), `num` INT(20), PRIMARY KEY (`id`) ); ALTER TABLE `author` ADD FOREIGN KEY (`num`) REFERENCES `book`(`num`); ALTER TABLE `client` ADD CONSTRAINT `client_ibfk_1` FOREIGN KEY (`num`) REFERENCES `book`(`num`);

PLZ help with the following: change the following sql to oracle sql meaning making run/ work on oralce sql live or oracle sql developper CREATE TABLE BOOK(num INT(20) NOT NULL AUTO_INCREMENT, title VARCHAR(20), year DATE,subject VARCHAR(20), checkedout DATETIME, checkedin DATETIME, PRIMARY KEY (num)); CREATE TABLE Client (CID INT(20) NOT NULL AUTO_INCREMENT, fname VARCHAR(25), lname VARCHAR(25), type VARCHAR(25), num INT(20), PRIMARY KEY (CID), FOREIGN KEY (num) REFERENCES emp.state(state_id)); CREATE TABLE author(id INT(10) NOT NULL AUTO_INCREMENT, year DATE, fName VARCHAR(20), lname VARCHAR(20), num INT(20), PRIMARY KEY (id)); ALTER TABLE author ADD FOREIGN KEY (num) REFERENCES book(num); ALTER TABLE client ADD CONSTRAINT client_ibfk_1 FOREIGN KEY (num) REFERENCES book(num);

Describe the architectural patterns utilised in distributed systems. Discuss the advantages and disadvantages critically!!

scrip for table is provided

Write a PL/SQL Programming block to do below actions 2.Before you work on Quesiton 2 , please create a table because you will be inserting numbers in thisMessages tableCREATE TABLE messages( RESULTS NUMBER)Run below query to see if there is any data :SELECT * FROM MESSAGES

help with sql class Report the names of the professors who work on the most number of projects

The Sqlite.py file contains several very specific queries: select_Query = "select sqlite_version()" delete_query = "DELETE from Database where id = "+str(id) sel = 'SELECT id FROM Database WHERE name == "{0}"'.format(value) insert_query = """INSERT INTO Database (id, name, photo, html) VALUES (?, ?, ?, ?)""" sqlite_select_query = """SELECT * from Database""" table_query = '''CREATE TABLE Database ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, photo text NOT NULL UNIQUE, html text NOT NULL UNIQUE)''' Write a QueryBuilder function. The QueryBuilder builds a generic Query to build ANY Query type (i.e. version, delete, select, insert, select, table). The QueryBuilder parameters require: The type of Query, the input tuple data and then constructs a query string based on the parameters....

Go to the w3schools website’s SQL browser IDE. This is where you canwrite and test your SQL code using their databases. Once you are happywith it, paste your code in a text file named Student.txt and save it in yourtask folder.●くろまる Write the SQL code to create a table called Student. The table structure issummarised in the table below (Note that STU_NUM is the primary key):Attribute Name Data TypeSTU_NUM CHAR(6)STU_SNAME VARCHAR(15)STU_FNAME VARCHAR(15)STU_INITIAL CHAR(1)STU_STARTDATE DATECOURSE_CODE CHAR(3)PROJ_NUM INT(2)●くろまる After you have created the table in question 1, write the SQL code to enterthe first two rows of the table as below:STU_NUMSTU_SNAMESTU_FNAMESTU_INITIALSTU_STARTDATECOURSE_CODEPROJ_NUM01 Snow John E 05-Apr-14 201 602 Stark Arya C 12-Jul-17 305 11●くろまる Assuming all the data in the Student table has been entered as shownbelow, write the SQL code that will list all attributes for a COURSE_CODE of305....

I am trying to get rid of duplicate rows in SQL. This is the current code I'm using. Please help me to write a code to create a new table without the duplicates. Select EmployeeID, Username, FirstName, LastName, RoleName, RoleDescription, Count(*) as '# of Duplicates' From [dbo].[vw_MyAccessInfo] Group by EmployeeID, Username, FirstName, LastName, RoleName,RoleDescription Having Count(*) > 1 Select * from [dbo].[vw_MyAccessInfo] Select distinct * from [dbo].[vw_MyAccessInfo]

Assistance with SQL statements Previous code; CREATE TABLE Lab4program_piershed ( code VARCHAR(5) PRIMARY KEY, name VARCHAR(20), tel VARCHAR(20));CREATE TABLE Lab4course_xxxx ( cid INT PRIMARY KEY, name VARCHAR(20), credits INT, mycode VARCHAR(5), FOREIGN KEY (mycode) REFERENCES Lab4program_xxxx(code)); 1. Insert 3 records into your Lab4program_xxxx table. The code should be "CPS", "TECH", "MATH", or "BIO". Please copy/paste your SQL statements with the output message in the text that shows you successfully insert 3 records to your table. 2. Insert 4 records into your Lab4course_xxxx table with at least 2 different mycode. Please copy/paste your SQL statements with the output message in the text that shows you successfully insert 4 records to your table.

HOW TO FIX THIS CODE IN ORACLE SQL ?CREATE OR REPLACE PROCEDURE CONVERT_VAL(V1 VARCHAR,V2 VARCHAR,AMT NUMBER) IS val VARCHAR2(100); val1 VARCHAR2(2); val2 varchar2(2); amount number; DECLARE meter NUMBER := 0; Cem NUMBER := 0; BEGIN val1:=v1; val2:=v2; amount:=amt; Select case when val1!=val2 then case when lower(val1)='km' meter := km * 1000; Cem := meter * 100; dbms_output.Put_line('The value of KM NUMBER KM to meters is: ' ||meter); dbms_output.Put_line('The value of KM NUMBER KM to centimeters is: ' ||cem); when lower(val1)='m' dbms_output.Put_line('The value of M NUMBER M to KM is: ' ||KM); dbms_output.Put_line('The value of M NUMBER M to centimeters is: ' ||cem); when lower(val1)='Cm' dbms_output.Put_line('The value of M NUMBER CM to KM is: ' ||KM); dbms_output.Put_line('The value of M NUMBER CM to M is: ' ||M); else 'same...

. Write a T-SQL correlated subquery selecting the store code, store name, store ytd sales from the store table where the store code matches the selection result of the max store code from the store table where the store code matches. /* Created with SQL Script Builder v.1.5 */ /* Type of SQL : SQL Server */ CREATE TABLE EMPLOYEE ( EMP_CODE int, EMP_TITLE varchar(4), EMP_LNAME varchar(15), EMP_FNAME varchar(15), EMP_INITIAL varchar(1), EMP_DOB datetime, JOB_CODE varchar(5), STORE_CODE int ); INSERT INTO EMPLOYEE VALUES('1','Mr.','Williamson','John','W','5/21/1964','SEC','3'); INSERT INTO EMPLOYEE VALUES('2','Ms.','Ratula','Nancy','','2/9/1969','MGR','2'); INSERT INTO EMPLOYEE VALUES('3','Ms.','Greenboro','Lottie','R','10/2/1961','GEN','4'); INSERT INTO EMPLOYEE VALUES('4','Mrs.','Rumpersfro','Jennie','S','6/1/1971','GEN','5'); INSERT INTO EMPLOYEE VALUES('5','Mr.','Smith','Robert','L','11/23/1959','GEN','3'); INSERT INTO EMPLOYEE...