Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Information Systems Access Assignment

Please Finish

IfSuccessful_Status GA_Status_Icon SAM_Logo
true
false
ID FirstName LastName AssignmentGUID UserID
false Zaire Haynes {64F49731-53E8-4AE6-8C0F-A0C17B86001A} {64F49731-53E8-4AE6-8C0F-A0C17B86001A}
ID FirstName LastName ProjectName SubmissionNum MaxScore Score EngineVersion
ID StepNumber Description IfSuccessful StepScore StepMaxScore ErrorText ActionName StepActionOrder
ClientID ClientName Employees ContractSigned ProjectStart ConsultantID
1 Biolane Products 5000 2021-07-08 2021-09-01 110345
2 Perosis Medical Supplies 2500 2021-07-08 2021-09-01 110347
3 Dynava Industries 1500 2021-07-09 2021-09-01 110467
4 Locenda Clothing 4500 2021-07-12 2021-10-01 110468
5 Scizu Manufacturing 4000 2021-07-15 2021-10-01 110479
6 Bellismova Corporation 2000 2021-07-16 2021-10-01 110481
7 Skante Corporation 2500 2021-07-23 2021-10-01 110345
8 Oyomm Company 3000 2021-07-30 2021-11-01 111222
9 Pyrolira Testing Services 1550 2021-08-03 2021-11-01 110481
10 Sucoid Corporation 2500 2021-08-05 2021-11-01 111767
11 Isoxo Industries 3000 2021-09-01 2021-11-01 111244
12 Protolane Energy 1000 2021-09-01 2021-11-01 111289
13 Divagen Chemicals 1600 2021-09-02 2022-01-01 111292
14 Trumba Automotive 1800 2021-09-02 2022-01-01 114234
15 Ainyx Steel 2200 2021-09-03 2022-01-01 111222
ComponentID ClientID SoftwareCode
1 1 HRIS
2 2 HRIS
3 3 HRIS
4 4 HRIS
5 5 HRIS
6 6 HRIS
7 7 HRIS
8 8 HRIS
9 9 HRIS
10 10 HRIS
11 1 EMPR
12 1 HRAN
13 1 ICOM
14 1 ONBD
15 2 PMGT
16 2 RECR
17 2 SCRE
18 2 TALM
19 2 EMPR
20 3 EMPR
21 3 HRAN
22 3 ICOM
23 4 ONBD
24 4 RECR
25 5 ONBD
26 5 RECR
27 6 EMPR
28 6 HRAN
30 6 ICOM
31 6 ONBD
32 6 PMGT
33 6 RECR
34 6 SCRE
35 6 TALM
36 7 ONBD
37 8 RECR
38 8 SCRE
39 8 ONBD
40 9 TALM
41 9 HRAN
42 10 SCRE
ConsultantID FirstName LastName StartDate Reside Salary
110345 Jenette Masterson USA 65000.0
110347 Victorina Hogg CAN 70000.0
110349 Marguerite Hathcock USA 62000.0
110351 Sidney Ortiz USA 60000.0
110352 Glenn Testani FRA 54000.0
110453 Bert Hobaugh USA 72000.0
110467 Melodie Trujillo ESP 73500.0
110468 Domingo Brisker USA 68345.0
110479 Sue Heywood USA 49950.0
110481 Tennille Steinmetz CAN 52750.0
111222 Rusty Horrocks ISL 58750.0
111244 Veola Calder USA 59650.0
111267 Norris Huddleston GBR 84500.0
111289 Teresa Ashalintubbi POL 76550.0
111292 Yuonne Keleher ISL 73500.0
111301 Norman Mccain USA 68750.0
111456 Dustin Nuss USA 79000.0
111478 Jeanne Guardiola ESP 75000.0
111499 Debbie Coyle USA 66550.0
111767 Talitha Pries DEU 68000.0
112111 Lorean Huie USA 59000.0
112139 Rozanne Pettit USA 51000.0
112368 Georgiann Mcgrane GBR 54000.0
112456 Brenda Gill USA 72000.0
112567 Elfrieda Ortez ESP 85000.0
112589 Kecia Talamantes POL 55000.0
112741 Laine Califano FRA 58000.0
112987 Taisha Stolle USA 71000.0
113123 Hettie Cho FRA 71000.0
113345 Ozell Moulden USA 75000.0
113456 Sharilyn Sipes USA 65000.0
113567 Danilo Cost CAN 80000.0
113678 Mathilda Bonner USA 54000.0
113789 Rolland Swinson USA 60000.0
113890 Kimiko Felten EST 70000.0
114123 Laticia Lewellen USA 73000.0
114234 Lexie Riner USA 67000.0
114345 Elizabeth Lavalle USA 62500.0
114567 Judyful Meininger USA 50000.0
CountryCode CountryName
BGR Bulgaria
BLR Belarus
CAN Canada
DEU Germany
ESP Spain
EST Estonia
FRA France
GBR United Kingdom
ISL Iceland
POL Poland
ROU Romania
SRB Serbia
USA United States
SoftwareCode ComponentName InstallationFee MonthlyFee
EMPR Employee Relations ¤ 2,500.00 ¤ 50.00
HRAN HR Analytics ¤ 8,000.00 ¤ 50.00
HRIS HR Information Software ¤ 50,000.00 ¤ 1,000.00
ICOM Time and Attendance ¤ 10,000.00 ¤ 200.00
ONBD Onboarding ¤ 1,000.00 ¤ 50.00
PMGT Performance Management ¤ 4,000.00 ¤ 50.00
RECR Recruiting ¤ 4,000.00 ¤ 50.00
SCRE Screening ¤ 3,000.00 ¤ 50.00
TALM Talent Management ¤ 2,000.00 ¤ 50.00
SELECT DISTINCTROW *
FROM Client;
SELECT DISTINCTROW *
FROM Consultant;
SELECT DISTINCTROW *
FROM Consultant;
SELECT DISTINCTROW *
FROM Country;
SELECT DISTINCTROW *
FROM Consultant;
SELECT DISTINCTROW *
FROM Country;
SELECT [FirstName] & ” ” & [LastName] AS StudentName, [_GradingReport].ProjectName, “Submission #” & [SubmissionNum] AS SubmissionCt, [_GradingReport].Score, [_GradingReport].MaxScore, “Score is: ” & [Score] & ” out of ” & [MaxScore] AS Grade, [_GradingReportSteps].[StepNumber] & “. ” & [Description] AS Step, [_GradingReportSteps].[StepScore] & “/” & [_GradingReportSteps].[StepMaxScore] AS StepGrade, [_GradingReportSteps].ActionName, IIf([ifsuccessful]=True,Null,[ErrorText]) AS Feedback, [_GradingReportSteps].IfSuccessful, [_GradingIcons].GA_Status_Icon, [_GradingReportSteps].StepNumber, [_GradingReportSteps].StepActionOrder, [_GradingReportSteps].ID, [_GradingIcons].SAM_Logo, [_GradingReportSteps].Description, [_GradingReport].EngineVersion
FROM _GradingReport, _GradingIcons INNER JOIN _GradingReportSteps ON [_GradingIcons].[IfSuccessful_Status] = [_GradingReportSteps].IfSuccessful;
SELECT SoftwareComponent.ComponentName, Client.ClientName, SoftwareComponent.InstallationFee, SoftwareComponent.Monthlyfee
FROM SoftwareComponent INNER JOIN (Client INNER JOIN ClientSoftware ON Client.ClientID = ClientSoftware.ClientID) ON SoftwareComponent.SoftwareCode = ClientSoftware.SoftwareCode;
SELECT Client.ClientName, ClientSoftware.SoftwareCode, SoftwareComponent.ComponentName
FROM SoftwareComponent INNER JOIN (Client INNER JOIN ClientSoftware ON Client.ClientID = ClientSoftware.ClientID) ON SoftwareComponent.SoftwareCode = ClientSoftware.SoftwareCode;

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

III

see attached. You are an IT consultant hired by ABC Tech Solutions, a small but growing technology firm specializing in software development. The firm has recently expanded its operations and is looking to ensure its IT infrastructure is secure and compliant with industry standards. As part of your engagement, you

How does an online port scanner check for open ports?

 I want to understand how an online port scanner works. How can it detect whether specific ports on my IP address are open or closed? Are there any tools that show both open ports and my public IP address in one place? 

CASE 3 – 80

I need your help please Module 3 – Case Creating Value Assignment Overview The Case Assignment for this module is about understanding the development of IT strategies that support and are supported by business strategy in a global economy. Given the large amount of investment in IT, companies need to

SLP 3 – 80

Please help me Module 3 – SLP Creating Value Read or listen to these resources on Dr. Michael Porter’s competitive strategies.  Porter, M. E. and Mauborgne, K. R., HBR’s 10 must reads on strategy. Ascent Hu. Audio book. Go to Library Access. In Additional Library Resources, select Skillsoft Books. In

Make, Buy, or Modify

  As a project manager, you may be given the choice to either a) build your system from scratch; b) buy an existing system; or c) buy an existing system and modify it. With regards to each option, explain the make or buy decision you would take. Justify your response.

Cloud

See attached Case Analysis #1 – Cloud Computing Choose a case study or story of a cloud sourcing event or project in an organization. Find an article online.. Then do a brief analysis of the project or services being sourced in the cloud.  Focus on the type of cloud service SaaS,

II

see attached. • Your initial post should be at least 200 words in length. Imagine that you have been promoted to the position of an IT manager in a mid-sized firm, SecureFunds Inc, which specializes in financial services and has recently undergone significant growth and adapted to the new conditions

Managing Risks

 Identify and discuss the common sources of risk for IT software development projects. What will be your plan to manage them? Justify your response. 

Communications

  Explain why you agree or disagree with some of the suggestions covered this week for improving project communications, such as creating a communications management plan, stakeholder analysis, or performance reports for IT software development projects. Justify your response. What other suggestions do you have?

Case 2 – 80

I need help  Module 2 – Case Information Technology Planning Assignment Overview Strategic planning is a process exercise where it is important to gather whatever strategic collateral the rest of the company has generated to understand what the CEO and board hope to do in the future through the enterprise-level

SLP 2 – 80

Please help me with my assignment Module 2 – SLP Information Technology Planning Xerox is a firm that has dominated the copier business. As the market for copiers continues to shrink, how will Xerox survive? Research the current business environment for Xerox by using Fortune.com and Forbes.com, etc. In your

PowerPoint

 The Baypoint Group (TBG) needs your help with a presentation for Academic Computing Services (ACS), a nationwide organization that assists colleges and universities with technology issues. ACS needs more information about the differences between the IEEE 802.11a and IEEE 802.11g standards so that their salespeople will be better equipped to

Journal VIII

see attached. 2 Identify a task that you would need to perform in your current career or future career, and explain in detail how you would apply the knowledge you have learned in this course to succeed at performing the task in a real-world scenario. Your submission should be in

SLP 1 – 80

I need help on my assignment  Module 1 – SLP Strategy and Strategic Planning Review this  comprehensive review of strategic planning . The website is the brain-child of Dr. Ross A. Wirth, who has extensive experience in management consulting. However, the website is about general strategic planning, rather than IT

Case 1 – 80

I need help please.  Module 1 – Case Strategy and Strategic Planning Assignment Overview The Case for this module starts us off by looking at why IT strategy matters.  Please view the following video: Please note that this link will open in a new window and may require activation of

Improving Quality

  You are committed to improving the quality of developing software applications. Identify and discuss three recommendations for improving quality in IT software development projects. Justify your response.

Macfee subscription

  [1-888-226-6629] How Do i Cancel M C A F e e Subscription & Get a R E F U N D  To cancel your M C A F E E subscription and request a refund, call [1-888-226-6629]. A support agent will help verify your account, [1-888-226-6629] process the cancellation,

How do i cancel McAfee subscription and get a refund?

 To cancel your McAfee subscription 1-888-226-6629 and request a refund, log in to your account at mcafee.com, go to My Account > Subscriptions, select your active plan, and turn off auto-renewal. To request a refund, visit the Support section or call 1-888-226-6629. McAfee’s customer support 1-888-226-6629 is available 24/7 to