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

SLP 2 – 25

I need help with my homework assignment!  Module 2 – SLP IT Services and Cloud Computing If Cloud computing is the greatest thing for business since sliced bread, then by extension, it certainly ought to be the greatest thing for education since chalk. In point of fact, a relatively large

Case 2 – 25

Need help please Module 2 – Case IT Services and Cloud Computing Assignment Overview The Case Assignment for this module involves thinking systematically about the IT services movement in general and about cloud computing as a particular instance of that approach. You will start by reviewing a number of sources

SLP 1 – 25

Need help with my homework Module 1 – SLP Web 2.0 and Social Networks The purpose of the Session Long Project in Trident University classes is to give you the opportunity to explore the applicability of the module to your own life, work, and place in space and time, and

Case 1 – 25

I need help with my homework please.  Module 1 – Case Web 2.0 and Social Networks Assignment Overview In this Case Assignment, you are exploring the technological underpinnings of the Internet. The objective of this Case is to better understand the evolution of the Web from Web 1.0 and Web

SP DB

See attached. In your own words, please discuss a cybersecurity policy with which you are familiar. The example can come from work, school, or a business relationship. You can also research organizational policies posted online. Give a brief description of the policy. What is the purpose and value of the

Changes in existing interview question for Info I’m attaching th topic

Topic:   Enhancing Cybersecurity in IoT Networks: A Comprehensive Study on Threat Detection and Mitigation Strategies · Details about the research (Background, methodology, research questions) · ·  The rapid proliferation of IoT devices has opened up new avenues for cyber threats. Securing these devices has become increasingly complicated, as over 75 billion

Active directory automation

Need help to get an assignment done. Requirements are VMware, windows server core (not the full GUI). PowerShell Automation for Active Directory Submission Template Screenshot 1 Onboarding New Users from CSV Single screenshot showing: Script output (e.g. “Created user: jdoe”). Get-ADUser results for those SamAccountNames. Your custom prompt (server name

HIMS 11

  Assignment Instructions:  Using the Patient Healthcare Data in the attached Excel file (attached below), construct a 3-D Clustered Column Chart depicting the three healthcare parameters (weight, height, age), and title this chart ” Patient Healthcare Data” at the top center and show Legend at the bottom. After reviewing the

Governance, Ethics, and Security

 Assume the role of an IT security consultant who has been contacted by a company to provide them with a written code of IT conduct for its employees and a security policy for the firm. In preparation for undertaking this large job, prepare a proposal explaining what topics you will

Cloud-Based Management and Analytics

Final Project Topic: (5 pages research paper) Topic: Data Management and Analytics: Explore how enterprises use cloud-based data management and analytics tools to drive business decisions and gain competitive advantages. Competitive advantages through cloud analytics: Citation: Cooper, A. (2020). How Netflix Uses Big Data and Analytics to Drive Success. Forbes.

Powtoon commercial

see attached file Powtoon Commercial Project Do not pay for anything on this site! Learning animation can be very challenging yet very fun. Navigate to the Powtoon website, click Pricing in the top menu, scroll down, and click FREE Start Now $0 free. Create an account if you do not

HIMS W12D12

 What is Big Data in healthcare? How is it generated in a typical healthcare facility, like a hospital? What two common formats are used, and what are the advantages and disadvantages of each? How is this data used for unraveling hidden trends, strategic planning, and operational decision-making?  What are the

INFA W12D12

  In the discussion this week, you and your peers are asked to consider and discuss information security career pathways relevant to your personal goals and career plans. Where are you currently in your career? What is the next level up or sideways for you in your desired career field?

CASE 4 – 40

i need help please Module 4 – Case Database Systems and Knowledge Base Assignment Overview The Case Assignment for this module considers the emerging and important trend toward what is called “open-source software.” The Background Information contains material regarding this movement; its effect is being felt in many different areas

SLP 4 -40

I need help Module 4 – SLP Database Systems and Knowledge Base Go to  Kaggle.com  and register with any one of your email addresses. Kaggle is a open-source data repository often used in Data Analytics to practice with datasets. Go to this  Kaggle dataset  that has 9,514 movies on Netflix,

Information Systems Book Assignment

IS 373 Book Chapter Review Project Goal: CHAPTER 2 Each student will be assigned one chapter from the following eBook by the instructor. The student should study the chapter carefully and in depth and do extra research to ensure his/her dominance on all of the concepts in the chapter. The

Module 03 Course Project – Network Diagram

Module 03 Content In this Module, you are responsible for completing a network diagram and creating both a Procurement Plan and a Communication Plan. The following item(s) are required in this Module: Network Diagram Utilize the proper diagramming software (e.g. Visio, draw.io, etc.) to detail the key elements of the

Module 03 Course Project – Network Diagram, Procurement Plan and Communication Plan Module 03 Course Project – Network Diagram, Procurement Plan and Communication Plan

Module 03 Project Procurement Plan [Insert Name] Network Administration Capstone Table of Contents Introduction 1 Procurement Management Approach 2 Procurement Definition 2 Type of Contract to be Used 2 Procurement Risks 2 Procurement Risk Management 2 Cost Determination 2 Standardized Procurement Documentation 2 Procurement Constraints 2 Contract Approval Process 2