Question

Write a query to create a Table with the following structure

TABLE: PATIENT

Patient _ID NUMBER

F_NAME CHAR

AGE NUMBER

DISEASE CHAR​

Answer 1

Answer:

ANSWER :-

(a) CREATE TABLE Patient( "PID" Char (4), "PNAME" Varchar (20), "DISEASE" Varchar (40), "FEES" Decimal);

(b) (i) SELECT* FROM Book_issue;

(ii) INSERT INTO Book_issue( "Book ID", "Date of Issue", "Student Name", "Returned") VALUES ('B005', '20-06-2014', 'Preeti', 'Yes');

(iii) UPDATE Book_issue set Student Name='Ankur' where Book ID='B003';

HOPE THIS HELPS YOU!!!!!!!!!!!!!

PLEASE MARK IT AS BRAINLIST!!!!!!!!!

Explanation:

Answer 2

Explanation:

hope it is useful to u

plzZZZZ take as BRAIN least