About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:

Accounting,Algebra See all

Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all

Teaching Since:	Jul 2017
Last Sign in:	313 Weeks Ago, 6 Days Ago
Questions Answered:	15833
Tutorials Posted:	15827

Education

MBA,PHD, Juris Doctor
Strayer,Devery,Harvard University
Mar-1995 - Mar-2002

Experience

Manager Planning
WalMart
Mar-2001 - Feb-2009

Category > Computer Science Posted 04 Dec 2017 My Price 10.00

learned in the in-class activity complete the below tasks

Please review document and complete, forward any questions

SQL Project

Assignment:

Using what you learned in the in-class activity complete the below tasks on your own.

Task #1: Create the 3 below tables:

Employee

EmployeeName	Address	Telephone	Degree	Age
Lynn_Davis	Omaha	555-1234	MS-MIS	26
Monica_McElhaney	Nebraska_City	555-5678	MS-MIS	21
Ann_Walker	Blair	555-9012	MBA	24
Cappy_O’Johns	Lincoln	555-3456	CIS	20

ReportFrequency

Day	ReportName	EmployeeName	NumOfCopies
Monday	Assets	Lynn_Davis	20
Monday	Productivity	Lynn_Davis	15
Monday	Variance	Lynn_Davis	50
Monday	ProfitAndLoss	Monica_McElhaney	50
Tuesday	Assets	Lynn_Davis	20
Tuesday	Productivity	Ann_Walker	15
Tuesday	Variance	Ann_Walker	20
Tuesday	ProfitAndLoss	Monica_McElhaney	20
Wednesday	Assets	Ann_Walker	20
Wednesday	Productivity	Ann_Walker	15
Wednesday	Variance	Monica_McElhaney	20
Wednesday	ProfitAndLoss	Lynn_Davis	20
Thursday	Assets	Ann_Walker	20
Thursday	Productivity	Ann_Walker	15
Thursday	Variance	Monica_McElhaney	20
Thursday	ProfitAndLoss	Lynn_Davis	20
Friday	Assets	Lynn_Davis	20
Friday	Productivity	Monica_McElhaney	15
Friday	Variance	Monica_McElhaney	30
Friday	ProfitAndLoss	Ann_Walker	50

WeeklyReports

ReportName	Information	Report_Size	Division
Assets	Equipment	500	AssetControl
Productivity	Lines_Of_Code	10	Programming
Variance	Income	50	Finance
ProfitAndLoss	Income	410	Accounting

Task #2: In Access, write SQL queries to do the following (do not use the Wizard within Access):

List the ages and telephone numbers of all employees.
List the names of all employees older than 22.
List the reports requiring more than 30 copies to be produced.
List the reports that have more than 100 pages.
List the names of employees who run Productivity Reports.
List the names and degrees of employees who run Profit and Loss Reports (P&Ls)
List the names and degrees of employees who run reports with income information.
Change Lynn_Davis’s phone number to 827-0000
Insert a new employee record: Gale_Smith, Bellevue, 293-2000, Ph.D., 30 (use SQL).
Delete the record you just inserted (use SQL).

Task #3: Copy and paste your SQL syntax (your code) into a word document and email as an attachment to monica.mcelhaney@bellevue.edu (databases do not email well due to security issues and I would not be able to open the majority of them if the database was sent by email).

DUE: The end of Week 6.

Attachments:

1512392533-SQL project - to post 1.doc

Answers

SophiaPretty

(5)

Status NEW Posted 04 Dec 2017 01:12 PM My Price 10.00

----------- ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)

Buy Answer

Hire Dedicated Virtual Team / Business Solution for SMEs.