Find Jobs
Hire Freelancers

sql enter data quary

$2-8 USD / hour

Cerrado
Publicado hace alrededor de 1 año

$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
ID del proyecto: 36194499

Información sobre el proyecto

21 propuestas
Proyecto remoto
Activo hace 1 año

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
21 freelancers están ofertando un promedio de $10 USD /hora por este trabajo
Avatar del usuario
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 en 40 días
4,9 (98 comentarios)
6,0
6,0
Avatar del usuario
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 en 40 días
5,0 (32 comentarios)
5,0
5,0
Avatar del usuario
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 en 40 días
4,1 (96 comentarios)
5,7
5,7
Avatar del usuario
Hi, My name is sumit. I can do this job very well according to your need. I will start immediately. Thanks
$6 USD en 40 días
5,0 (8 comentarios)
4,6
4,6
Avatar del usuario
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 en 40 días
4,9 (46 comentarios)
4,3
4,3
Avatar del usuario
Hi I have checked your requirement and I can help you now. Please contact me via chat. Looking forward your response. Thanks
$5 USD en 40 días
5,0 (15 comentarios)
3,8
3,8
Avatar del usuario
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 en 10 días
5,0 (10 comentarios)
3,7
3,7
Avatar del usuario
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 en 40 días
5,0 (3 comentarios)
3,0
3,0
Avatar del usuario
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 en 40 días
5,0 (2 comentarios)
3,1
3,1
Avatar del usuario
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 en 40 días
5,0 (1 comentario)
2,0
2,0
Avatar del usuario
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 en 40 días
5,0 (2 comentarios)
1,4
1,4
Avatar del usuario
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 en 20 días
5,0 (1 comentario)
1,0
1,0
Avatar del usuario
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 en 37 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 36 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
New Richmond, United States
5,0
1
Forma de pago verificada
Miembro desde nov 10, 2021

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.