Run a query from the employee table to find the age of the employees and the...
Run a query from the employee table to find the age of the employees and the Day(Ex:Monday) they were born. You may need to update these records if Age is shown as negative. Example: NAME BDATE AGE ------------------------------- ------------------ ---------- Ramesh Narayan Monday 09/15/52 61 Jennifer Wallace Saturday 06/20/31 82
Homework Answers
As it is not specified which day is to be given as a result of the query
Query to find age of employees:
SELECT AGE, NAME FROM
EMPLOYEE_TBL;
Add Answer to:
Run a query from the employee table to find the age of the employees and the...
Q2. Retrieve the names of all employees from the employee table to produce output on CSV...
Q2. Retrieve the names of all employees from the employee table to produce output on CSV format or delimited format with a common delimeter, rather than separete columns. Hint:Put the whole row into a string with a semicolon as the seperator(delimeter) between thecolumns: FORMAT:(fname;minit;lname) Example: EMPLOYEES -------------- James;E;Borg Frank;T;Wong Q3. Write a query to show the employees name from the employee table in this format: first letter of the first name, followed by a dot, a blank, and the full...
Q1: The following question are based on these database tables: EMPLOYEE FNAME MIDINT LNAME SSN BDATE ADDRESS SEX SALARY SUPER_SSN Dept_No James A Borg 123123123 Hous...
Q1: The following question are based on these database tables: EMPLOYEE FNAME MIDINT LNAME SSN BDATE ADDRESS SEX SALARY SUPER_SSN Dept_No James A Borg 123123123 Houston, TX M 55000 Null 1 Franklin S Wong 234234234 Houston, TX M 40000 123123123 5 John Q Smith 345345345 Houston, TX M 30000 234234234 5 Jennifer L Wallace 456456456 Bellaire, TX F 43000 123123123 4 Alicia M Zalaya 567567567 Spring, TX F 25000 456456456 4 Ramesh R Narayan 678678678 Humble, TX M 38000 234234234...
Please provide the relation algebra, the oracle SQL code and the output tuples for the following (Answer #6 only the BONUS question). I have the others actually I have the BONUS, but I want to compar...
Please provide the relation algebra, the oracle SQL code and the
output tuples for the following (Answer #6 only the BONUS
question). I have the others actually I have the BONUS, but I want
to compare with your solution to make sure I did it correctly.
Thank you very much!
LAB exercises 2 Write the Oracle DML query codes for the following questions and take the screen shot of the output. 1. Retrieve the name and address of all employees...
(SELECT pnumber FROM project, department, employee WHERE dnum=dnumber AND mgr_ssn=ssn AND lname='Smith') UNION (SELECT pnumber FROM...
(SELECT pnumber
FROM project, department, employee
WHERE dnum=dnumber AND mgr_ssn=ssn AND lname='Smith')
UNION
(SELECT pnumber
FROM project, works_on, employee
WHERE pnumber=pno AND essn=ssnAND lname='Smith')
Can you draw the relation step by step , how to solve it
?!
Figure 5.6 One possible database state for the COMPANY relational database schema. EMPLOYEE Sex Salary Super ssn Dno B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 3334455555 Ssn Fname Minit Lname John Franklin TWong 333445555 1955-12-08 638 Voss, Houston, TXM40000...
SQL query: Write an SQL query that will output the last name, employee id, hire date and department from the employee table. Pick only those employees whose department ID is specified in the employee...
SQL query: Write an SQL query that will output the last name, employee id, hire date and department from the employee table. Pick only those employees whose department ID is specified in the employee table. If the employee id is 777, name is ABC and hire date is 01-JAN-2016, the output should look as follows - 'Stephen (Employee ID - 777) was hired on the 1st of January, 2016 – Department: 90'. Note - The date should not have preceding...
write the following queris in sql : a) Using nested query , retreive the sependent names...
write the following queris in sql :
a) Using nested query , retreive the sependent names of male
employees whose salary > 30000
b ) list the female employee, who are not managers
EMPLOYEE Fname MinitLname John Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX M 4 Ssn Sex Salary Super sen Dno B Smith 123456789 1965 01-09 731 Fondren, Houston, TX M 30000 13334455 AliciaZelaya 999987777 1968-01-19 3321 Castle, Spring, TXF Jennifer S Wallace 987654321 1941-06-20 291 Berry,...
A company maintains data on their employees in a table called employee. Write a query to find the highest paid employee in each department. The output should contain department_name, employee_name, and salary. Exclude employees with no department from you
A company maintains data on their employees in a table called employee. Write a query to find the highest paid employee in each department. The output should contain department_name, employee_name, and salary. Exclude employees with no department from your result. Input Format: employee table: Column Type employee_no Integer employee_name String department_no Integer salary Integer manager_no Integer department table: Column Type department_no String department_name String
New to DB's Please help! You are designing and creating a database named COMPANY for an HR (Human Resource) Dept of...
New to DB's Please help!
You are designing and creating a database named COMPANY for an HR (Human Resource) Dept of a Software Consulting Company to manage their employees and their assigned work (projects) in the company First Step to Design and Create a Database is Creating an E-R Diagram by Identifying Entities, Attributes and Relationships between any two Entities to Create a Company Database Scheme. 1. Create an E-R Diagram for the Company database from the raw data files...
Oracle SQL Assignment 4 - List the name of supervisor who has more supervisee than other...
Oracle SQL Assignment 4
- List the name of supervisor who has more supervisee than other
supervisors.
The supervisor would be the Mgr_ssn from the Department table.
Each employee from the Employee table has a Super_ssn which would
be their supervisor.
1 to this PC Picture Tools ew Help Acrobat Storyboarding FormatTell me what you want to de Picture Bonde A Bring Send Selection Tent Pictu楩Layout . | | Forward. Backward . Pane Figure 3.6 One possibie database state for...
ules for submission: 1. All problems must be solved using SQL code. The SQL code and...
ules for submission:
1. All problems must be solved using SQL code. The SQL code
and the output of your query should be cut and pasted into your MS
Word file.
a. Output Tables must be screenshot from DBMS
b. Do not create a MS Word (or other application) table and
paste the results into it.
c. With the exception of Problems 4, 5 and 6, all output
should be the result of a single step. Do not paste outputs...
Please provide the relation algebra, the oracle SQL code and the
output tuples for the following (Answer #6 only the BONUS
question). I have the others actually I have the BONUS, but I want
to compare with your solution to make sure I did it correctly.
Thank you very much!
LAB exercises 2 Write the Oracle DML query codes for the following questions and take the screen shot of the output. 1. Retrieve the name and address of all employees...
(SELECT pnumber
FROM project, department, employee
WHERE dnum=dnumber AND mgr_ssn=ssn AND lname='Smith')
UNION
(SELECT pnumber
FROM project, works_on, employee
WHERE pnumber=pno AND essn=ssnAND lname='Smith')
Can you draw the relation step by step , how to solve it
?!
Figure 5.6 One possible database state for the COMPANY relational database schema. EMPLOYEE Sex Salary Super ssn Dno B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 3334455555 Ssn Fname Minit Lname John Franklin TWong 333445555 1955-12-08 638 Voss, Houston, TXM40000...
write the following queris in sql :
a) Using nested query , retreive the sependent names of male
employees whose salary > 30000
b ) list the female employee, who are not managers
EMPLOYEE Fname MinitLname John Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX M 4 Ssn Sex Salary Super sen Dno B Smith 123456789 1965 01-09 731 Fondren, Houston, TX M 30000 13334455 AliciaZelaya 999987777 1968-01-19 3321 Castle, Spring, TXF Jennifer S Wallace 987654321 1941-06-20 291 Berry,...
A company maintains data on their employees in a table called employee. Write a query to find the highest paid employee in each department. The output should contain department_name, employee_name, and salary. Exclude employees with no department from your result. Input Format: employee table: Column Type employee_no Integer employee_name String department_no Integer salary Integer manager_no Integer department table: Column Type department_no String department_name String
New to DB's Please help!
You are designing and creating a database named COMPANY for an HR (Human Resource) Dept of a Software Consulting Company to manage their employees and their assigned work (projects) in the company First Step to Design and Create a Database is Creating an E-R Diagram by Identifying Entities, Attributes and Relationships between any two Entities to Create a Company Database Scheme. 1. Create an E-R Diagram for the Company database from the raw data files...
Oracle SQL Assignment 4
- List the name of supervisor who has more supervisee than other
supervisors.
The supervisor would be the Mgr_ssn from the Department table.
Each employee from the Employee table has a Super_ssn which would
be their supervisor.
1 to this PC Picture Tools ew Help Acrobat Storyboarding FormatTell me what you want to de Picture Bonde A Bring Send Selection Tent Pictu楩Layout . | | Forward. Backward . Pane Figure 3.6 One possibie database state for...
ules for submission:
1. All problems must be solved using SQL code. The SQL code
and the output of your query should be cut and pasted into your MS
Word file.
a. Output Tables must be screenshot from DBMS
b. Do not create a MS Word (or other application) table and
paste the results into it.
c. With the exception of Problems 4, 5 and 6, all output
should be the result of a single step. Do not paste outputs...
Most questions answered within 3 hours.
-
A university administrator working in student housing wants to
determine if the percentage of students residing...
asked 6 minutes ago -
3). Describe human population growth that has occurred in the
past 400 years. Use terms learned...
asked 3 minutes ago -
A
projectile is blue at a target. The distance from the point of
impact to the...
asked 27 minutes ago -
Given a 32 bit processor, with 2 MB of physical RAM split into 512
frames. What...
asked 17 minutes ago -
What were the main rulings in the Supreme Court cases which are
Morgan v. Virginia (1946)...
asked 17 minutes ago -
write a five paragraph essay on how setting,
specifically culture, influences the actions of
the characters...
asked 9 minutes ago -
JAVA
Provide a simple code sample of Merge sort
asked 19 minutes ago -
Discounting cash flows involves:
A. taking the cash discount offered on a trade merchandise
B. estimating...
asked 27 minutes ago -
A solid wood door 1.00 m wide and 2.00 m high is hinged along
one side...
asked 27 minutes ago -
Raleigh Company manufactures two joint products. At the
split-off point, they have sales values of:
Product...
asked 26 minutes ago -
1. Your grandmother has invested $4000 in a mutual fund each
year on your birthday (she...
asked 28 minutes ago -
HELP WITH SAS
Run the following DATA step to create a SAS data set called
ABC_CORP....
asked 41 minutes ago