In Progress

SQL project Database

SQL database has 3 simple relations

and 8 SQL commands

Note that the following things must be taken into account:

1. The creation date of any Branch should be less or equal to its start date.

2. An Employee can be the head of the same Branch many times but at different dates and a Branch could be headed by only one Employee at a time.

3. The Loss field represents the amount of money (in Saudi Riyals) lost by the Branch when it was headed by the corresponding Employee. This field should be a number greater or equal to zero.

4. The default value associated with the field C_Start_Date will be the current system (use the function sysdate).

Write SQL commands to:

1) Create the above tables and their different constraints. Each foreign key constraint should allow the deletion of the children if the parent is to be deleted. Populate the tables with enough data- Hint: try to insert records in such a way to allow you to verify the answer of you query

2) For the employee(s) who got the lowest loss, increase their salary with 1% of the average on all employee salaries.

3) Give the employee ID for the employees who started at least one branch administration during the year 2012 and didn’t start any branch administration during the year 2013.

4) Give the Branch ID, its creation date and the employee full-name, SSN and the number of times this employee administrated that branch without a loss.

5) Give all the information of the employees with a salary less than 8000SR, 30 years old or more and who haven’t be head of any branch. The list will be displayed in an ascending order of the SSN.

6) Give the branch ID and its start date along with the employee full-name for the employees who headed that branch exactly twice.

7) Give the employee SSN, the full-name and the birthdate of the employees who headed at least all the branches headed by the employee Mohamed between 2000 and 2013.

8) Create a view named Branch_Summary which gives, for each company created after 2000 the following information: The branch ID, its start date, its maximum loss, its minimum loss and the number of different heads that administrated it.

Skills: MySQL, PHP, Software Architecture

See more: salaries, named query, current salary, sql less than, php less than or equal to, database creation software, sql database administration, sql commands, saudi id, salary software, query creation, mohamed, increase value of project, database employee, sql created, sql different, list ascending, foreign key, populate database, create tables sql 2012, simple project database php, insert sql, heads list, create sql database, employee time database

About the Employer:
( 3 reviews ) riyadh, Saudi Arabia

Project ID: #4464713

Awarded to:

dobreiiita

happy to help you out on the project !!

$50 USD in 1 day
(43 Reviews)
5.1

12 freelancers are bidding on average $142 for this job

rinsadsl

please refer to my private message

$154 USD in 3 days
(206 Reviews)
6.8
html5css3php5

Hi sql expert here..

$236 USD in 3 days
(16 Reviews)
4.0
mrintelligence

Look for LIVE DEMO in PMB for exactly similar Business Requirement

$199 USD in 6 days
(6 Reviews)
3.9
rakib062

Hi, I am working as a Database designer and developer for 7+ years using sql server, oracle, mysql and ms access.I have working knowledge of designing and implementing database schema and writing efficient query, sto More

$110 USD in 2 days
(5 Reviews)
3.9
annaijobs

Hi, I take this opportunity to introduce myself. My name is Jeni and I am the BusinessDevelopment Executive of annaijobs. Understanding: 1. To work on SQL project database. The quote would be 206 USD and 8 bu More

$206 USD in 8 days
(5 Reviews)
3.6
SurfrazAhmad

I am Ready to Start on this

$71 USD in 3 days
(3 Reviews)
3.1
linguangsui

sir, nice to meet you. please check me pmb. wait your response.

$264 USD in 7 days
(2 Reviews)
3.0
PerfectSquare

Hi I am oracle professional, I have 7 years of oracle/PL Sql experience. I can do this very easily. Looking for your positive reply please Thanks

$99 USD in 2 days
(5 Reviews)
2.1
doinab

I am a SQL expert with a lot of experience, I can do this project right now, I have good recommendations and I am ready to start today.

$70 USD in 3 days
(2 Reviews)
1.7
rexy12

Hi, I have extensive database administration experience.

$154 USD in 3 days
(0 Reviews)
0.0
shain22

I can do this please see pm

$94 USD in 10 days
(0 Reviews)
0.0