Find Jobs
Hire Freelancers

create table for below sql query

$10-30 USD

Closed
Posted about 6 years ago

$10-30 USD

Paid on delivery
A small accounting firm wants a simple HR application that will help it to keep track of its employees, their positions, office locations, salary scales, and which company vehicles their employees drive. The application must keep track of all the positions at the firm, the employees filling these positions, the offices for these positions which may have more than one employee, the salary scales for these positions, and the company vehicles assigned to these positions. Hint: There are seven tables in the solution. For each entity, there is a table. Take a look at the last sentence for 5 entities. when there are many to many relationships, we need bridge tables. Submit the HR database ERD, SQL to create and populate tables and answers to these queries: 1. Show all employees with vehicles, locations, positions, and salary 2. Show all for employee with highest salary 3. Show all for employees with 'A' in their first name. 4. Show how many employees 5. Show average salary.
Project ID: 16764445

About the project

31 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
31 freelancers are bidding on average $27 USD for this job
User Avatar
Hi, I have read your job description. I can definitely do it. I have done many projects using Codeigniter, php, wordpress etc. I can give you the exact what you want.
$50 USD in 3 days
5.0 (4 reviews)
4.5
4.5
User Avatar
Hi I have 15+ years of experience in developing applications on oracle database. I have bachelor degree in cs, 25 oracle certified trainings and web app dev certificate from University in Chicago. I will be glad to work for you on this project. You can check my profile, I already completed many similar tasks, all of them with 5 stars. Regards
$35 USD in 1 day
4.8 (20 reviews)
4.5
4.5
User Avatar
Hey i am a Professional Developer and have a experience of that field kindly inbox for more details thanks
$19 USD in 1 day
4.7 (40 reviews)
4.4
4.4
User Avatar
I can do this now See my project history for references. All the best Alex
$30 USD in 1 day
5.0 (12 reviews)
4.0
4.0
User Avatar
hi sir, i will create the table creation scripts and insert scripts to populate data and will make the erd and will give queries for all 5 points, ready to start now and will create in 6 hours. thanks
$30 USD in 1 day
5.0 (17 reviews)
3.7
3.7
User Avatar
Hello You want to do as follow: small accounting firm wants a simple HR application that will help it to keep track of its employees, their positions, office locations, salary scales, and which company vehicles their employees drive. The application must keep track of all the positions at the firm, the employees filling these positions, the offices for these positions which may have more than one employee, the salary scales for these positions, and the company vehicles assigned to these positions. Hint: There are seven tables in the solution. For each entity, there is a table. Take a look at the last sentence for 5 entities. when there are many to many relationships, we need bridge tables. Submit the HR database ERD, SQL to create and populate tables and answers to these queries: 1. Show all employees with vehicles, locations, positions, and salary 2. Show all for employee with highest salary 3. Show all for employees with 'A' in their first name. 4. Show how many employees 5. Show average salary. Please send me your contact then, we can discuss about your project with more closely thanks
$25 USD in 1 day
4.4 (1 review)
3.6
3.6
User Avatar
A proposal has not yet been provided
$30 USD in 2 days
5.0 (4 reviews)
2.4
2.4
User Avatar
I possess expert level skills and experience in SQL and I have successfully developed and implemented complex projects for some of the esteemed clients in US and Canada. I believe I can find solutions to all of your needs. Start a conversation with me today and get started to unravel the solutions you need.
$25 USD in 2 days
5.0 (1 review)
2.4
2.4
User Avatar
Hi I can do it, I can do this task for you according to your requirements. Can we discuss in detail? If you have any query please inbox me. Thanks
$15 USD in 1 day
5.0 (2 reviews)
2.0
2.0
User Avatar
Hello, I can do this for you. You want E-R diagram, table creation scripts and SQL queries of questions. Am I right?
$30 USD in 1 day
5.0 (2 reviews)
1.9
1.9
User Avatar
I have worked with an Indian IT giant for over 2 years with experience in writing complicated SQL queries encompassing large number of tables on the Oracle, DB2 and MySQL relational databases. Looking forward to working with you.
$10 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm good in MYSQL query language, did many project in collage related to Database, so i think I can easily finish the job in given time.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
i have thoroughly read the description provided by the client. I will try to fulfill your requirement using SQL. As per given, 7 tables would be required. 5 Master tables (Employees, Position, location, salary scale, Vehicles) and 2 detail tables (i.e. 1 is for employee detail and 2nd is for Position detail w.r.t Salary, location and Vehicle). I have a question regarding salary scale. Which details do you want to maintain in salary scale table like Basic salary, gross salary, benefits etc? Can you please elaborate it more? I will accomplished this project within 1 day or same day. Thanks
$20 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Requirement Gathering and Analysis. Design of System Development. Analysis and design of System Development. Involved in the design and development of database objects (tables, Procedures, Functions, Triggers, and Packages). Development of New Forms and Reports at the client side for their further requirements. Assigning appropriate roles to the end users according to their working hierarchy in both application and database levels. Implementation.
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I just starting work like freelancer and I want get few references on my work. So I can write some scripts for free for you and then we can collaborate on long term base if you want. Martin
$15 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$45 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have experience in SQL for more than 20 years and design more than 100 projects that still work efficiently until now . I hope to co-operate .
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I will complete this project in one day if further explanation then you ask me about this...........
$25 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Springfield, United States
5.0
1
Payment method verified
Member since Apr 23, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.