Please solve the error in the PostgreSQL query. Thank you CREATE TABLE IF NOT EXISTS "basefiles" ( "fileuuid" TEXT, "flocation" TEXT NOT NULL UNIQUE, "scannedby" TEXT DEFAULT 'mdvine',   "scannedwhen" timestamp DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY("fileuuid") ); INSERT INTO basefiles VALUES ('puwr', 'pubty', 'fdf', 10:52); select * from basefiles

write Command to insert data into  this tables create table patients ( patient_id VARCHAR(255),`name` VARCHAR(255),`insurance` DECIMAL(15,2),`date_admitted` DATE,`date_checked_out` DATE,PRIMARY KEY(`patient_id`)); create table doctor (doctor_id VARCHAR(255),name VARCHAR(255),specialization VARCHAR(255),PRIMARY KEY (doctor_id) ); create table `test` (`test_id` VARCHAR(255),`test_name` VARCHAR(255),`test_date` DATE,`test_time` TIME,`result` VARCHAR(255),PRIMARY KEY(`test_id`)); create table doctor_patient( patient_id VARCHAR(255), doctor_id VARCHAR(255),PRIMARY KEY(`patient_id`),FOREIGN KEY(`doctor_id`) REFERENCES doctor(`doctor_id`) ); create table test_log (`test_log_id` varchar(255),`patient_id` VARCHAR(255),`test_id` VARCHAR(255),`doctor_id` VARCHAR(255),`comments` VARCHAR(255),PRIMARY KEY(`test_log_id`),FOREIGN KEY(`test_id`) REFERENCES `test`(`test_id`),FOREIGN KEY(`patient_id`) REFERENCES doctor_patient(`patient_id`),FOREIGN KEY(`doctor_id`) REFERENCES doctor(`doctor_id`));

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`);

Which function does the PRIMARY KEY clause perform in table creation? It ensures that’s non-NULL values can act as unique keys. It ensures that non-NULL values can as candidate keys. It ensures that each value in row is unique. It ensures that each value in the column is unique