CREATE TABLE Author $($ Aut$\_$id INT PRIMARY KEY, Name VARCHAR$(255)$ NOT NULL$)$;CREATE TABLE Category $($ Cat$\_$number INT PRIMARY KEY, Amount INT NOT NULL$)$;CREATE TABLE Publisher $($ Pub$\_$id INT PRIMARY KEY, Name VARCHAR$(255)$ NOT NULL, Address VARCHAR$(255)$$)$;CREATE TABLE Books $($ ISBN INT PRIMARY KEY, Title VARCHAR$(255)$ NOT NULL, Price DECIMAL$(10,2),$ Borrowed$\_$amount INT, Aut$\_$id INT, FOREIGN KEY $($Aut$\_$id$)$ REFERENCES Author$($Aut$\_$id$)$$)$;CREATE TABLE Member $($ User$\_$id INT PRIMARY KEY, Address VARCHAR$(255),$ Phone VARCHAR$(10),$ Mail VARCHAR$(255)$$)$;CREATE TABLE Personnel $($ Per$\_$id INT PRIMARY KEY, Name VARCHAR$(255),$ Password VARCHAR$(255)$$)$;I am trying to create a table for Oracle Database with SQL based on the ER diagram here and this is my code. Do I have any shortcomings? If so$,$ can you share the correct code?

 

Transcribed Image Text:

ISSN Price Title Books Writes M M User id Address Brows NNN Mail Phone no (First name) 1 Member Name Se Borrowed by (Last name 7 Due date M R Retum date Controls Name Name Author Sorted N Ka A3 Published by per_id P N Aut_id N Password Personnel S Cat_number Category Amount Address Publisher Name Pub_id ISSN Price Title Books Writes M M User id Address Brows NNN Mail Phone no (First name) 1 Member Name Se Borrowed by (Last name 7 Due date M R Retum date Controls Name Name Author Sorted N Ka A3 Published by per_id P N Aut_id N Password Personnel S Cat_number Category Amount Address Publisher Name Pub_id