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
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 work, stay assured the work will be done fast enough & of superior quality
Thanks
Mahesh Kumar
Hi there! Let me help you out...
I can help you to write the SQL Script to insert the data into these tables.
I know 500-level things about Microsoft SQL Server. I have 7+ years of exceptional knowledge and experience in both SQL Server Prod & Dev environments.
Please feel free to ask for adjustment if my Bid Amount or Hourly Rate does not suit your budget.
Warm regards,
Kundan Bihari (Freelance, SQL Server Consultant.)
Hii,
How are you??
I can work on this project so please come on chat and able to do data entery using php mysql same as you want so please ping me !
As a matter of my experience, I've already been built the kind of website before.
Our skill set -
Website designing - Photoshop/Adobe Muse/illustrator.
Front end development - Bootstrap/HTML/CSS/JavaScript/J-query/Foundation and other HTML framework.
PHP - custom PHP/frameworks of PHP like RUBY ON RAILS, YII, codeignitor.
CMS like WordPress, Joomla, Magento, Woo-commerce.
WE CAN START IMMEDIATELY!!!
I can assure you --> Great communication, Fast turn around time, High quality, Excellent support, Any time availability on demand, Honest relationship.
Thanks and Regards,
Hi!,
I’ve carefully checked your requirements and really interested in this job.I am ready to start work immediately.I am indivisual software developer having 9 + years exp in Php,Laravel,Codiegnator,CakePhp and wp,I have completed many web based project in all areas like education,real estate,insurance,ecommerce. etc.
I read Project details.
Please contact me to discuss more regarding this project.
Hopefully you will give me a chance for prove myself.
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 perfect result, don't hesitate to reply to me.
I will be here waiting for you.
Best regards.
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 there!!
I'm interested in working on your project ("sql data entry") since it matches my expertise in SQL and database administration.
I have great skills and experience on working with SQL queries thus I can effectively complete your task as required.
I'm available to start your project right away
Feel free to contact me for further discussion.
Thanks
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 from you soon.
Thank you!
Greeting!!!
I reviewed your requirement and I understand it correctly. I will complete this within your time and budget. I am Certified Data Scientist, Analyst Professional, A passionate, hands-on professional, I have over 8+ years experience in Database development covering multiple technologies like oracle, mysql,sql plsql.
I would like to work in this project. I will continue to work with you till you satisfy with my work.
See you soon.
Thanks and Regards
Kundlik R
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 HOLDER & CERTIFIED DEVELOPER IN THE REQUIRED FIELD.
EXPERT IN NAMED REQUIRED SKILLS.
Dear Client, I have KEENLY gone through the project details as given in your project description. Being in possession of all CLEARLY STATED required skills ((PHP, SQL, MySQL, Database Programming and Software Architecture)) as this is my area of professional specialisation having completed all academic certifications and developed adequate experience in this field; I hereby humbly request you to consider my bid for professional and quality services at affordable rates.
NO TIMELINE & QUALITY EXCUSES||| UNLIMITED REVISION||| FULL TIME SUPPORT FOR ENQUIRIES.
Message me we discuss more about the project and get into action.
Incase the project is deleted hire me directly through the link;
https://www.freelancer.com/u/josephmuindenzio
THANK-YOU & WELCOME
Hi,
I'm a full-stack developer and have experience working with SQL based databases a lot also I did a lot of similar kind of work with another client. So, I think I would be the best fit for the project. Shall we connect over a call for further discussion?
Thanks,
Kumaran P
Hi, I'm a very professional person with 10 years of experience working on T-SQL. I have knowledge for queries, stored procedures, triggers, functions, views, etc. My most recent experience was a month ago developing a set of web services where I had to create a full database and objects SQL to read from the web services (which I developed myself in C#).
I'd love to have the chance to participate in this project. Please contact me.
Regards.
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.