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

Concurrency Control

  There are times when a database is accessed by many users across the enterprise. Transaction logs can help maintain concurrency in a multiuser platform. Describe at least two business scenarios where “commit” and “rollback” would be required. Describe how these functions would be essential for business continuity and concurrency

Healthcare Industry Solutions: Transforming Patient Care and Operational Efficiency

Healthcare industry solutions refer to a wide range of technologies, tools, and strategies designed to improve the way healthcare organizations operate and deliver patient care. These solutions combine software, digital platforms, data analytics, medical devices, and process innovations to address challenges in hospitals, clinics, pharmaceutical companies, insurance providers, and the

Comprehensive SharePoint and Teams Migration Solutions

   Modern businesses depend on collaboration and document platforms to stay productive, and moving these systems during a tenant migration is often complex. CloudBik’s Teams to Teams Migration offers an effective way to transfer Teams environments, including chats, channels, and files, without impacting end-users. At the same time, the SharePoint

Why Businesses Need Tenant to Tenant Migration

   The need for Tenant to Tenant Migration is growing as many companies go through mergers, acquisitions, or restructuring. Having data in two separate tenants can create confusion and extra work for IT teams. Moving everything into one tenant gives users a simple and unified experience. The OneDrive Migration Tool

Easy Data Transfer from Google to Office 365

  Many businesses choose Microsoft 365 over Google Workspace because it connects better with apps like Excel, Teams, and Outlook. But during migration, the main worry is losing data or breaking folder structures. The migrate from Google Workspace to Office 365 blog explains how to transfer emails, calendars, and files safely

HIS-D40-C

I have a question about Health Information System, who can help with questions?

HIS-B39-C

My questions are about Health IS. Who can help with these questions?

Advanced SQL and PL/SQL

  Extracting and interpreting data can be very valuable to an organization. Describe the importance of using sub queries in a database system. Provide at least two business case scenarios to support your response.

creating

Create a Visual Origin Story In Module 1 you are to complete the team-building exercise ” Visual Origin Story: Adventures in collaborative storytelling .” This exercise is from the book:  Murdoch-Kitt, K. M., & Emans, D. J. (2020). Intercultural collaboration by design drawing from differences, distances, and disciplines through visual

HIS-553-A

I have a question about Health Information Systems. Who is willing to help?

Case 4 – 90

I need help please Module 4 – Case Managing Complex IT Organizational Change and Capstone Paper Assignment Overview The Impact of Various Internal and External Organizational “Environments” on IT Management The ability to understand various elements within and outside your topic organization and the extent to which they affect information

SLP 4 – 90

PLEASE HELP Module 4 – SLP Managing Complex IT Organizational Change and Capstone Paper The continuing professional development of IT personnel is a key managerial responsibility. In this light, reflect on a subordinate and prepare a somewhat detailed and actionable professional development plan which would be intended for use in

Logical and Physical Design

  In order to ensure optimal database performance, the logical and physical design should consider the user requirements thoroughly. Suppose you have been hired to transform a conceptual model into a logical model for a sales database. Describe the specific steps that you must perform in order to appropriately construct

tERRORISM I

SEE ATTACHED. 2 Response to natural and man-made disasters have changed quite significantly since the implementation of the National Incident Management System (NIMS). Provide an example of a recent natural disaster or terrorist attack that has occurred in your region in the last 10 years. In what ways do you

Case 2 – 90

I need help please Module 2 – Case Architecting the IT Governance Plan Assignment Overview The Capstone course is a summary of your learning from all previous MSITM coursework. Thus, it has some suggested recent materials in IT governance along with writing/Capstone Case guides, or other materials directly provided by

SLP 2 – 90

Please Help Module 2 – SLP Architecting the IT Governance Plan As a consultant to, or manager of, an IT unit within your selected organization, you must be keenly aware of challenges facing your selected organization. This assignment asks you to identify, intellectually discuss, and broadly report on at least

Planning the DBLC

  The development of a database requires thorough methodology that ensures quality within the solution. Imagine you have been contracted to develop a finance database that will help an organization track monthly expenditures by departments. Discuss the various activities that you would have to achieve each phase, using the DBLC.