Kapalı

create table for below sql query

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.

Beceriler: SQL

Daha fazlasını gör: sql create table schema, sql query create matrix report, sql query tree structure table, php, mysql, sql query check child table, sql query filter table, convert oracle create table script sql, csv create table sql, sql query parents table, sql server create table graphically cnet dbo, sql query find child parent items table, sql create table csv file, sql parent child table tree query

İşveren Hakkında:
( 1 değerlendirme ) Springfield, United States

Proje NO: #16764445

Bu iş için 34 freelancer ortalamada $28 teklif veriyor

ref2

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(19 Değerlendirme)
4.1
danale72

I can do this now See my project history for references. All the best Alex

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(12 Değerlendirme)
4.0
VangHaleena17

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
3.6
zallim

HI there please check my portfolio I have gone through your project details, i can do that job [login to view URL] me

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
3.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(4 Değerlendirme)
2.8
djpeka

Hello, as a professional programmer, I'm up for the task .

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
2.9
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(4 Değerlendirme)
3.0
AbdulBasitAli045

Hey i am a Professional Developer and have a experience of that field kindly inbox for more details thanks

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(6 Değerlendirme)
2.7
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(1 Yorum)
2.1
sweetykantha04

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.

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
2.2
puneethshanth

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 ne Daha Fazla

in %bids___i_period_sub_35% gün içinde25%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
2.4
rohitagarberg

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(6 Değerlendirme)
2.3
itbarduga

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(3 Değerlendirme)
2.1
atacan

Hello, I can do this for you. You want E-R diagram, table creation scripts and SQL queries of questions. Am I right?

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
1.9
cybergemtech

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
2.0
in %bids___i_period_sub_35% gün içinde25%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
0.4
tuvvkstn

Hi. I am Tu. This is simple task and i can do it for you quickly. Hope to work with u.

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
chodaykarthik

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 P Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
nourhelmy2003

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 .

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
harisali49

A proposal has not yet been provided

in %bids___i_period_sub_35% gün içinde45%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0