Find Jobs
Hire Freelancers

sql enter data quary

$2-8 USD / hour

Suljettu
Julkaistu noin vuosi sitten

$2-8 USD / hour

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
Projektin tunnus (ID): 36194499

Tietoa projektista

21 ehdotukset
Etäprojekti
Aktiivinen vuosi sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
21 freelancerit tarjoavat keskimäärin $10 USD/tunti tätä projektia
Käyttäjän avatar
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
$6 USD 40 päivässä
4,9 (98 arvostelua)
6,0
6,0
Käyttäjän avatar
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.)
$30 USD 40 päivässä
5,0 (32 arvostelua)
5,0
5,0
Käyttäjän avatar
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,
$5 USD 40 päivässä
4,1 (96 arvostelua)
5,7
5,7
Käyttäjän avatar
Hi, My name is sumit. I can do this job very well according to your need. I will start immediately. Thanks
$6 USD 40 päivässä
5,0 (8 arvostelua)
4,6
4,6
Käyttäjän avatar
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
$3 USD 40 päivässä
4,9 (46 arvostelua)
4,3
4,3
Käyttäjän avatar
Hi I have checked your requirement and I can help you now. Please contact me via chat. Looking forward your response. Thanks
$5 USD 40 päivässä
5,0 (15 arvostelua)
3,8
3,8
Käyttäjän avatar
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
$12 USD 10 päivässä
5,0 (10 arvostelua)
3,7
3,7
Käyttäjän avatar
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.
$8 USD 40 päivässä
5,0 (3 arvostelua)
3,0
3,0
Käyttäjän avatar
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
$5 USD 40 päivässä
5,0 (2 arvostelua)
3,1
3,1
Käyttäjän avatar
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
$4 USD 40 päivässä
5,0 (1 arvostelu)
2,0
2,0
Käyttäjän avatar
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!
$3 USD 40 päivässä
5,0 (2 arvostelua)
1,4
1,4
Käyttäjän avatar
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
$8 USD 20 päivässä
5,0 (1 arvostelu)
1,0
1,0
Käyttäjän avatar
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
$50 USD 37 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
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
$7 USD 1 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
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.
$5 USD 40 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
I can entry the data for each table you have with the explanation if you want, I have experience and projects with SQL Query.
$9 USD 2 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
I type fast in system as well as very much familiar with SQL server database. So I can do this job perfectly. Thanks
$5 USD 40 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
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.
$5 USD 36 päivässä
0,0 (0 arvostelua)
0,0
0,0

Tietoja asiakkaasta

Maan UNITED STATES lippu
New Richmond, United States
5,0
1
Maksutapa vahvistettu
Liittynyt marrask. 10, 2021

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.