sql enter data quary
Budget $2-8 USD / hour
Job Description:
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
21 freelancers are bidding on average $10/hour for this job
Hello, I am an experienced WordPress developer & have worked on 200+ WordPress websites. I have read your requirements and I would like to offer you our services as an experienced web developer. When you assign me the More
Hi, My name is sumit. I can do this job very well according to your need. I will start immediately. Thanks
Hi I have checked your requirement and I can help you now. Please contact me via chat. Looking forward your response. Thanks
Hi I have read all your description of your project. I am professional SQL, PLSQL Programmer. I want to do work on this project In Shaa ALLAH. Please contact me for this project. Thanks. Regards, Muhammad Shoaib
Hello, I am a senior web developer. As a web developer, I have a strong knowledge of DB management . I can run your queries in the database without errors. I think it take only a few hours. If you wanna have a fast and More
Okay I got what you want exactly. As a senior software developer, I am pretty sure I can provide you satisfied result in time. I 'd love to discuss more details with you. Best Regards
Hi, How are u? I have full experience with ✅ MySQL, Query, PHP... ✅. I have worked with these fields for a long time. I can start soon and complete your project with high quality in time. Looking forward to hearing fr More
GREETINGS DEAR CLIENT. I welcome you to my profile, where client satisfaction is 100% guaranteed. I take pride in the quality of my work, and hence be sure to always receive professional and quality services. MASTERS More
I can entry the data for each table you have with the explanation if you want, I have experience and projects with SQL Query.
I type fast in system as well as very much familiar with SQL server database. So I can do this job perfectly. Thanks
HI, I have seven years of experience in MS SQL, I know the MS SQL in and out. I have resolved the many SQL issues over the period so confident about resolving of this issue as well as.
