How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Susan Athena Your Own Question

Susan Athena
Susan Athena, Professional w/Adv. Degree
Category: Homework
Satisfied Customers: 4323
Experience:  10+ yrs teaching & tutoring. AP essay grader. 2 masters degrees. English, IT, business.
Type Your Homework Question Here...
Susan Athena is online now
A new question is answered every 9 seconds

Week 3: Data Changes and SQL Statements Use the database

Customer Question

Week 3: Data Changes and SQL Statements

Use the database and tables from last week’s assignment to write SQL statements and enter records into the eEmployee table for workers identified in the employee files for the administrative offices and the Del Mar store. Check results by selecting all columns from both tables.

Use the database and tables from last week’s assignment to write SQL queries using Between, Like, and Union. Write an SQL query that does the following:

• Joins two tables in the example database and uses BETWEEN to restrict record selection. Use salary to restrict data.

• Joins two tables in the example database and uses BETWEEN to restrict record selection. Use hire dates to restrict data.

• Joins two tables in the example database and uses LIKE to restrict record selection. Use telephone area codes to restrict data.

• Joins two tables in the example database and uses LIKE to restrict record selection. Use age to restrict data.

• Uses the UNION of the two tables to produce a third table.

Use the updated database to write the following queries, using the SQL GROUP statement:

• Select employees’ last names and group them by EEO-1 classification.
• Select employees’ last names and group them by salary.
• Select employees’ last names and group them by salary in their EEO-1 classification.
• Select employees’ last names and group them by salary in job titles, grouped into exempt and non-exempt.

Submit to Assignments Link: SQL statements and results. Put

Week 4 : SQL Reports

Use the database and tables from last week’s assignment to write SQL queries using the SQL SELECT statement.

Note. Select all data from both tables before you perform the following:

• Increase all employees’ salaries with the selected EEO-1 classification by 10 percent.
• Increase all employees’ salaries by 5 percent.
• Choose an employee from the Employee table and delete that employee.


Use the database and tables from last week’s assignment to write SQL statements that do the following:

• Calculate the average salary for all employees.
• Calculate the maximum salaries for exempt and non-exempt employees.
• Calculate the maximum salary for all employees.
• Calculate the minimum salaries for exempt and non-exempt employees.
• Calculate the minimum salary for all employees.

Submit to Assignments Link: SQL statements and results. Put screen prints of your SQL commands executing into a Microsoft Word document along with your SQL commands and submit this document to the Assignments Link.
Submitted: 1 year ago.
Category: Homework
Expert:  Susan Athena replied 1 year ago.
Hi. Thanks for your question.

What database does this refer to? I can assist with either Access or SQL Server.

Can you post the database, please? You can post it to mediafire.com and put the sharing URL here.

Kind regards,
Susan
Customer: replied 1 year ago.

 


Hello


Here I have done from a first week of assignment. I have to used SQL server to show my result . Yes we use SQL server


/* CREATE DATABASE */


USE master
GO


CREATE DATABASE KudlerFineFoods
ON
( NAME = KudlerFineFoods_dat,
FILENAME = 'D:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\KudlerFineFoods.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
( NAME = 'KudlerFineFoods_log',
FILENAME = 'D:\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\KudlerFineFoods.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )
GO


/* CREATE TABLES */


USE KudlerFineFoods
GO


CREATE TABLE JobTitle
(
JobTitleID int NOT NULL PRIMARY KEY CLUSTERED,
JobTitle nvarchar(50),
EEO1Classification nvarchar(50),
JobDescription nvarchar(200),
ExemptNonExemptStatus nchar(1)
)
GO


CREATE TABLE Employee
(
EmployeeID int IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED,
LastName nvarchar(50),
FirstName nvarchar(50),
Address nvarchar(50),
City nvarchar(30),
State nvarchar(20),
TelephoneAreaCode nvarchar(3),
TelephoneNumber nvarchar(7),
EmployerInformationReportClassification nvarchar(max),
HireDate date,
Salary money,
Gender nchar(1),
Age smallint,
JobTitleID int REFERENCES JobTitle(JobTitleID)
)
GO


/* INSERT JOB TITLES */


INSERT INTO JobTitle(JobTitleID, JobTitle, EEO1Classification, JobDescription, ExemptNonExemptStatus)
VALUES (1, 'Accounting Clerk', 'Office/Clerical', 'Computes, classifies, records, and verifies numerical data for use in maintaining accounting records.', 'N')


INSERT INTO JobTitle(JobTitleID, JobTitle, EEO1Classification, JobDescription, ExemptNonExemptStatus)
VALUES (2, 'Assistant Manager', 'Officials & Managers', 'Supervises and coordinates activities of workers in department of food store. Assists store manager in daily operations of store.', 'E')


INSERT INTO JobTitle(JobTitleID, JobTitle, EEO1Classification, JobDescription, ExemptNonExemptStatus)
VALUES (3, 'Bagger', 'Sales Workers', 'Places customer orders in bags. Performs carryout duties for customers.', 'N')


INSERT INTO JobTitle(JobTitleID, JobTitle, EEO1Classification, JobDescription, ExemptNonExemptStatus)
VALUES (4, 'Cashier', 'Sales Workers', 'Operates cash register to itemize and total customer’s purchases in grocery store.', 'N')


INSERT INTO JobTitle(JobTitleID, JobTitle, EEO1Classification, JobDescription, ExemptNonExemptStatus)
VALUES (5, 'Computer Support Specialist', 'Technician', 'Installs, modifies, and makes minor repairs to personal computer hardware and software systems, and provides technical assistance and training to system users.', 'N')


INSERT INTO JobTitle(JobTitleID, JobTitle, EEO1Classification, JobDescription, ExemptNonExemptStatus)
VALUES (6, 'Director of Finance and Accounting', 'Officials & Managers', 'Plans and directs the finance and accounting activities for Kudler Fine Foods.', 'E')


INSERT INTO JobTitle(JobTitleID, JobTitle, EEO1Classification, JobDescription, ExemptNonExemptStatus)
VALUES (7, 'Retail assistant bakery and pastry', 'Craft Workers (Skilled)', 'Obtains or prepares food items requested by customers in retail food store.', 'N')


INSERT INTO JobTitle(JobTitleID, JobTitle, EEO1Classification, JobDescription, ExemptNonExemptStatus)
VALUES (8, 'Retail assistant butchers and seafood specialists', 'Operatives (Semi skilled)', 'Obtains or prepares food items requested by customers in retail food store.', 'N')


INSERT INTO JobTitle(JobTitleID, JobTitle, EEO1Classification, JobDescription, ExemptNonExemptStatus)
VALUES (9, 'Stocker', 'Office/Clerical', 'Stores, prices and restocks merchandise displays in store.', 'N')
GO


/* INSERT EMPLOYEES */


INSERT INTO Employee(LastName, FirstName, Address, City, State, TelephoneAreaCode, TelephoneNumber, EmployerInformationReportClassification, HireDate, Salary, Gender, Age, JobTitleID)
VALUES('Edelman', 'Glenn', '175 Bishops Lane', 'La Jolla', 'California', 619, (NNN) NNN-NNNN 'Caucasian', '2003-10-07', 10.75, 'M', 64, 4)


INSERT INTO Employee(LastName, FirstName, Address, City, State, TelephoneAreaCode, TelephoneNumber, EmployerInformationReportClassification, HireDate, Salary, Gender, Age, JobTitleID)
VALUES('McMullen', 'Eric', '763 Church St.', 'Lemmgrove', 'California', 619, (NNN) NNN-NNNN 'Caucasian', '2002-11-1', 6.75, 'M', 20, 3)


INSERT INTO Employee(LastName, FirstName, Address, City, State, TelephoneAreaCode, TelephoneNumber, EmployerInformationReportClassification, HireDate, Salary, Gender, Age, JobTitleID)
VALUES('Slentz', 'Raj', '123 Torrey Dr.', 'North Clairmont', 'California', 619, (NNN) NNN-NNNN 'Asian', '2000-06-01', 48000, 'M', 34, 2)


INSERT INTO Employee(LastName, FirstName, Address, City, State, TelephoneAreaCode, TelephoneNumber, EmployerInformationReportClassification, HireDate, Salary, Gender, Age, JobTitleID)
VALUES('Broun', 'Erin', '2045 Parkway - Apt 2B', 'Encinitas', 'California', 760, (NNN) NNN-NNNN 'Caucasian', '2003-03-12', 6.75, 'F', 24, 3)


INSERT INTO Employee(LastName, FirstName, Address, City, State, TelephoneAreaCode, TelephoneNumber, EmployerInformationReportClassification, HireDate, Salary, Gender, Age, JobTitleID)
VALUES('Carpenter', 'Donald', '927 Second St.', 'Encinitas', 'California', 619, (NNN) NNN-NNNN 'African American', '2003-11-01', 7.5, 'M', 18, 9)


INSERT INTO Employee(LastName, FirstName, Address, City, State, TelephoneAreaCode, TelephoneNumber, EmployerInformationReportClassification, HireDate, Salary, Gender, Age, JobTitleID)
VALUES('Esquivez', 'David', '10983 N. Coast Hwy Apt 902', 'Encinitas', 'California', 760, (NNN) NNN-NNNN 'Hispanic', '2003-07-25', 9.25, 'M', 25, 8)


INSERT INTO Employee(LastName, FirstName, Address, City, State, TelephoneAreaCode, TelephoneNumber, EmployerInformationReportClassification, HireDate, Salary, Gender, Age, JobTitleID)
VALUES('Sharp', 'Nancy', '10793 Montecino Rd', 'Ramona', 'California', 858, (NNN) NNN-NNNN 'Caucasian', '2003-07-12', 10.50, 'F', 24, 4)
GO


/* VERIFY RESULTS */


SELECT *
FROM Employee E
INNER JOIN JobTitle J
ON E.JobTitleID = J.JobTitleID


 

Expert:  Susan Athena replied 1 year ago.
Thanks for that. I'm making sure I can create the database tables. Please stand by.

Kind regards,
Susan
Customer: replied 1 year ago.
Hello
Ok , Thanks
Expert:  Susan Athena replied 1 year ago.
THIS ANSWER IS LOCKED!

You need to spend $3 to view this post. Add Funds to your account and buy credits.
Susan Athena, Professional w/Adv. Degree
Category: Homework
Satisfied Customers: 4323
Experience: 10+ yrs teaching & tutoring. AP essay grader. 2 masters degrees. English, IT, business.
Susan Athena and 10 other Homework Specialists are ready to help you
Customer: replied 1 year ago.

Thanks for your hard work if I have any question can I ask

Expert:  Susan Athena replied 1 year ago.
Yes, of course! Feel free to follow up with questions about this topic.

Kind regards,
Susan
Customer: replied 1 year ago.

Hello Susan


what you done that was great job thanks . Please last thing can you help how to "Create account number query" and how to test query


Test query.

Expert:  Susan Athena replied 1 year ago.
Yes, of course. This is a new question, though, not a followup on the existing one. Can you please start a new question and put "For Susan" at the beginning?

Thank you!
Susan
Customer: replied 1 year ago.

This question got little cut off I don`t have a change to ask earlier

Customer: replied 1 year ago.

But I have a new question I want ask


 

Expert:  Susan Athena replied 1 year ago.
I'm happy to help out. if you have a new question, please just click here to start a new topic and put "For Susan" at the beginning.

Thank you!
Customer: replied 1 year ago.

Hello Susan


I do have this question before i have done purchase i just want to make if you help to be done



submit a 12 -- 15 slide PowerPoint presentation, prepared to be presented to an executive audience, presenting your team’s design and solution for the Chart of Accounts needs of Kudler Fine Foods. Make sure that your team defines the benefits of your solution and justify the recommendations that you make for your solution.



  • Normalize the data in the Chart of Account spreadsheet and add appropriate tables for your solution.

  • Insert test data from the spreadsheet into your tables. 10 – 15 rows per table will be sufficient to test and demonstrate your solution and your queries.

  • Create SQL database Chart of Accounts report.

  • Test Chart of Accounts report.

  • Submit query, screen shots and Chart of Accounts report for grading.

Expert:  Susan Athena replied 1 year ago.
Hi. Thanks for your question. I'm not sure about the accounting part of this. Perhaps another expert will be able to assist if you post it as a new question.

Kind regards,
Susan
Customer: replied 1 year ago.

Ok thanks

Expert:  Susan Athena replied 1 year ago.
You're welcome.

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
< Last | Next >
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
  • He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here. Diane Dallas, TX
 
 
 

Meet The Experts:

 
 
 
  • Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    4520
    More than 5000 online tutoring sessions.
< Last | Next >
  • http://ww2.justanswer.com/uploads/BU/BusinessTutor/2012-2-2_115741_Kouki2.64x64.jpg Manal Elkhoshkhany's Avatar

    Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    4520
    More than 5000 online tutoring sessions.
  • http://ww2.justanswer.com/uploads/LI/lindaus/2012-6-10_04811_IMG20120609164157.64x64.jpg Linda_us's Avatar

    Linda_us

    Finance, Accounts & Homework Tutor

    Satisfied Customers:

    3121
    Post Graduate Diploma in Management (MBA)
  • http://ww2.justanswer.com/uploads/ComputersGuru/2010-02-13_051118_Photo41.JPG LogicPro's Avatar

    LogicPro

    Engineer

    Satisfied Customers:

    3035
    Expert in Java C++ C C# VB Javascript Design SQL HTML
  • http://ww2.justanswer.com/uploads/lanis/2009-4-1_233717_phput9xef_c1pm.jpg Lani S.'s Avatar

    Lani S.

    Tutor

    Satisfied Customers:

    2457
    Registered Nurse, Internet Researcher, Private Tutor
  • http://ww2.justanswer.com/uploads/chooser77/2009-08-18_162025_Chris.jpg Chris M.'s Avatar

    Chris M.

    M.S.W. Social Work

    Satisfied Customers:

    2341
    Master's Degree, strong math and writing skills, experience in one-on-one tutoring (college English)
  • http://ww2.justanswer.com/uploads/JawaadAhmed/2009-6-27_12137_SIs_SHadi.jpg F. Naz's Avatar

    F. Naz

    Chartered Accountant

    Satisfied Customers:

    1975
    Experience with chartered accountancy
  • http://ww2.justanswer.com/uploads/JK/jkcpa/2011-1-16_182614_jkcpa.64x64.jpg Bizhelp's Avatar

    Bizhelp

    CPA

    Satisfied Customers:

    1873
    Bachelors Degree and CPA with Accounting work experience