sql enter data quary
Budget: $2 – $8 USD
This is the first one i create
inset into borrower (BORROWERID, BORRORFIRSTNAME, BORROWER,LASTNAME, STREETADDRESS, CITY, STATE,ZIP VALUES(1,BOB, aggot' , '2222 main s, street', 'st paul', 'mn', 54224)
able: BorrowedItem
CREATE TABLE BorrowedItem (
BorrowedItemID integer NOT NULL,
BorrowedDate date NOT NULL,
DueDate date NOT NULL,
ReturnedDate date NULL,
ItemFine number(10,2) NOT NULL,
ReturnCondition varchar2(30) NULL,
ItemID integer NOT NULL,
BorrowerID integer NOT NULL,
CONSTRAINT check_1 CHECK (DueDate > BorrowedDate),
CONSTRAINT BorrowedItem_pk PRIMARY KEY (BorrowedItemID)
) ;
-- Table: Borrower
CREATE TABLE Borrower (
BorrowerID integer NOT NULL,
BorrowerFiirstName varchar2(30) NOT NULL,
BorrowerLastName varchar2(30) NOT NULL,
StreetAddress varchar2(50) NOT NULL,
City varchar2(50) NOT NULL,
State char(2) NOT NULL,
ZipCode varchar2(10) NOT NULL,
CONSTRAINT Borrower_pk PRIMARY KEY (BorrowerID)
) ;
-- Table: Item
CREATE TABLE Item (
ItemID integer NOT NULL,
ItemTitle varchar2(50) NOT NULL,
ItemDescription varchar2(100) NOT NULL,
ItemPrice number(10,2) NOT NULL,
AquiredDate date NOT NULL,
CONSTRAINT check_2 CHECK (ItemPrice > 0),
CONSTRAINT Item_pk PRIMARY KEY (ItemID)
) ;
CREATE INDEX Item_idx_1
on Item
(ItemTitle ASC)
;
-- foreign keys
-- Reference: BorrowerItem_Borrower (table: BorrowedItem)
ALTER TABLE BorrowedItem ADD CONSTRAINT BorrowerItem_Borrower
FOREIGN KEY (BorrowerID)
REFERENCES Borrower (BorrowerID)
ON DELETE SET NULL;
-- Reference: BorrowerItem_Item (table: BorrowedItem)
ALTER TABLE BorrowedItem ADD CONSTRAINT BorrowerItem_Item
FOREIGN KEY (ItemID)
REFERENCES Item (ItemID)
ON DELETE SET NULL;
-- End of file.)
what to work on enters data for the three tables (three records each)
need the scrips to run it
inset into borrower (BORROWERID, BORRORFIRSTNAME, BORROWER,LASTNAME, STREETADDRESS, CITY, STATE,ZIP VALUES(1,BOB, aggot' , '2222 main s, street', 'st paul', 'mn', 54224)
able: BorrowedItem
CREATE TABLE BorrowedItem (
BorrowedItemID integer NOT NULL,
BorrowedDate date NOT NULL,
DueDate date NOT NULL,
ReturnedDate date NULL,
ItemFine number(10,2) NOT NULL,
ReturnCondition varchar2(30) NULL,
ItemID integer NOT NULL,
BorrowerID integer NOT NULL,
CONSTRAINT check_1 CHECK (DueDate > BorrowedDate),
CONSTRAINT BorrowedItem_pk PRIMARY KEY (BorrowedItemID)
) ;
-- Table: Borrower
CREATE TABLE Borrower (
BorrowerID integer NOT NULL,
BorrowerFiirstName varchar2(30) NOT NULL,
BorrowerLastName varchar2(30) NOT NULL,
StreetAddress varchar2(50) NOT NULL,
City varchar2(50) NOT NULL,
State char(2) NOT NULL,
ZipCode varchar2(10) NOT NULL,
CONSTRAINT Borrower_pk PRIMARY KEY (BorrowerID)
) ;
-- Table: Item
CREATE TABLE Item (
ItemID integer NOT NULL,
ItemTitle varchar2(50) NOT NULL,
ItemDescription varchar2(100) NOT NULL,
ItemPrice number(10,2) NOT NULL,
AquiredDate date NOT NULL,
CONSTRAINT check_2 CHECK (ItemPrice > 0),
CONSTRAINT Item_pk PRIMARY KEY (ItemID)
) ;
CREATE INDEX Item_idx_1
on Item
(ItemTitle ASC)
;
-- foreign keys
-- Reference: BorrowerItem_Borrower (table: BorrowedItem)
ALTER TABLE BorrowedItem ADD CONSTRAINT BorrowerItem_Borrower
FOREIGN KEY (BorrowerID)
REFERENCES Borrower (BorrowerID)
ON DELETE SET NULL;
-- Reference: BorrowerItem_Item (table: BorrowedItem)
ALTER TABLE BorrowedItem ADD CONSTRAINT BorrowerItem_Item
FOREIGN KEY (ItemID)
REFERENCES Item (ItemID)
ON DELETE SET NULL;
-- End of file.)
what to work on enters data for the three tables (three records each)
need the scrips to run it