Please FinishIfSuccessful_Status GA_Status_Icon SAM_Logotruefalse

Please Finish

IfSuccessful_StatusGA_Status_IconSAM_Logo
true
false
IDFirstNameLastNameAssignmentGUIDUserID
falseZaireHaynes{64F49731-53E8-4AE6-8C0F-A0C17B86001A}{64F49731-53E8-4AE6-8C0F-A0C17B86001A}
IDFirstNameLastNameProjectNameSubmissionNumMaxScoreScoreEngineVersion
IDStepNumberDescriptionIfSuccessfulStepScoreStepMaxScoreErrorTextActionNameStepActionOrder
ClientIDClientNameEmployeesContractSignedProjectStartConsultantID
1Biolane Products50002021-07-082021-09-01110345
2Perosis Medical Supplies25002021-07-082021-09-01110347
3Dynava Industries15002021-07-092021-09-01110467
4Locenda Clothing45002021-07-122021-10-01110468
5Scizu Manufacturing40002021-07-152021-10-01110479
6Bellismova Corporation20002021-07-162021-10-01110481
7Skante Corporation25002021-07-232021-10-01110345
8Oyomm Company30002021-07-302021-11-01111222
9Pyrolira Testing Services15502021-08-032021-11-01110481
10Sucoid Corporation25002021-08-052021-11-01111767
11Isoxo Industries30002021-09-012021-11-01111244
12Protolane Energy10002021-09-012021-11-01111289
13Divagen Chemicals16002021-09-022022-01-01111292
14Trumba Automotive18002021-09-022022-01-01114234
15Ainyx Steel22002021-09-032022-01-01111222
ComponentIDClientIDSoftwareCode
11HRIS
22HRIS
33HRIS
44HRIS
55HRIS
66HRIS
77HRIS
88HRIS
99HRIS
1010HRIS
111EMPR
121HRAN
131ICOM
141ONBD
152PMGT
162RECR
172SCRE
182TALM
192EMPR
203EMPR
213HRAN
223ICOM
234ONBD
244RECR
255ONBD
265RECR
276EMPR
286HRAN
306ICOM
316ONBD
326PMGT
336RECR
346SCRE
356TALM
367ONBD
378RECR
388SCRE
398ONBD
409TALM
419HRAN
4210SCRE
ConsultantIDFirstNameLastNameStartDateResideSalary
110345JenetteMastersonUSA65000.0
110347VictorinaHoggCAN70000.0
110349MargueriteHathcockUSA62000.0
110351SidneyOrtizUSA60000.0
110352GlennTestaniFRA54000.0
110453BertHobaughUSA72000.0
110467MelodieTrujilloESP73500.0
110468DomingoBriskerUSA68345.0
110479SueHeywoodUSA49950.0
110481TennilleSteinmetzCAN52750.0
111222RustyHorrocksISL58750.0
111244VeolaCalderUSA59650.0
111267NorrisHuddlestonGBR84500.0
111289TeresaAshalintubbiPOL76550.0
111292YuonneKeleherISL73500.0
111301NormanMccainUSA68750.0
111456DustinNussUSA79000.0
111478JeanneGuardiolaESP75000.0
111499DebbieCoyleUSA66550.0
111767TalithaPriesDEU68000.0
112111LoreanHuieUSA59000.0
112139RozannePettitUSA51000.0
112368GeorgiannMcgraneGBR54000.0
112456BrendaGillUSA72000.0
112567ElfriedaOrtezESP85000.0
112589KeciaTalamantesPOL55000.0
112741LaineCalifanoFRA58000.0
112987TaishaStolleUSA71000.0
113123HettieChoFRA71000.0
113345OzellMouldenUSA75000.0
113456SharilynSipesUSA65000.0
113567DaniloCostCAN80000.0
113678MathildaBonnerUSA54000.0
113789RollandSwinsonUSA60000.0
113890KimikoFeltenEST70000.0
114123LaticiaLewellenUSA73000.0
114234LexieRinerUSA67000.0
114345ElizabethLavalleUSA62500.0
114567JudyfulMeiningerUSA50000.0
CountryCodeCountryName
BGRBulgaria
BLRBelarus
CANCanada
DEUGermany
ESPSpain
ESTEstonia
FRAFrance
GBRUnited Kingdom
ISLIceland
POLPoland
ROURomania
SRBSerbia
USAUnited States
SoftwareCodeComponentNameInstallationFeeMonthlyFee
EMPREmployee Relations¤ 2,500.00¤ 50.00
HRANHR Analytics¤ 8,000.00¤ 50.00
HRISHR Information Software¤ 50,000.00¤ 1,000.00
ICOMTime and Attendance¤ 10,000.00¤ 200.00
ONBDOnboarding¤ 1,000.00¤ 50.00
PMGTPerformance Management¤ 4,000.00¤ 50.00
RECRRecruiting¤ 4,000.00¤ 50.00
SCREScreening¤ 3,000.00¤ 50.00
TALMTalent 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

200 word response 1 reference due 6/8/2024 Franco 2-1: Aligning an IT Security Assessment The Gramm-Leach-Bliley Act (GLBA) was established in 1999 a

200 word response 1 reference due 6/8/2024 Franco 2-1: Aligning an IT Security Assessment The Gramm-Leach-Bliley Act (GLBA) was established in 1999 and was enacted to assist reform the financial industry and address consumer financial privacy concerns (Federal Trade Commission, 2023). GLBA possesses requirements for the Federal Trade Commission and

200 word response 1 reference Due 6/8/2024JacksonDiscussion 2-2: Conducting an IT

200 word response 1 reference Due 6/8/2024 Jackson Discussion 2-2: Conducting an IT Infrastructure Audit for Compliance IT security policies have a high level of importance for a compliance audit. As defined by Fortinet, and IT Security Policy “identifies the rules and procedures for all individuals and using an organization’s

Find videos showing a real-world health system. Then, conduct research for each following items:Provide the title of the video, and the Web link. Then,

Find videos showing a real-world health system. Then, conduct research for each following items: Provide the title of the video, and the Web link. Then, summarize it–including details, features, functions, contents, etc.), stakeholders, markets, and elaborate business value(s) it delivers and/or enables. Imagine you are the owner or the system analyst

300 words due 6/5/50242 referencesDiscussion 2-1: Aligning an IT Security Assessment

300 words due 6/5/5024 2 references Discussion 2-1: Aligning an IT Security Assessment How does the Gramm-Leach-Bliley Act (GLBA) impact information systems security and the need for information systems security practitioners and professionals? If an organization is a financial institution or insurance company that is also publicly traded, what other