Can someone please give me some assistance on this? I believe I have most of it done, but I keep getting errors when I attempt to compile it. 

 

TheSTU_ACCOUNTtable stores information about student accounts.STU_ACCOUNT(STUDENT_ID,PASSWORD,LAST_SUCCESSFUL_LOGIN_TIME,LAST_FAILED_LOGIN_TIME,FAILED_PASSWORD_ATTEMPT_COUNT,IS_LOCKED_OUT,LAST_LOCKED_OUT_TIME,LAST_PASSWORD_CHANGED_TIME);STUENT_ID:Primary KeyFAILED_PASSWORD_ATTEMPT_COUNT:the number ofconsecutivefailed password attemptsIS_LOCKED_OUT:'Y'– the account is locked out'N'– the account is not locked outCreate and populate theSTU_ACCOUNTtable as described below.CREATE TABLE stu_account( STUDENT_IDNUMBER PRIMARY KEY,PASSWORDVARCHAR2(30) NOT NULL,LAST_SUCCESSFUL_LOGIN_TIMEDATE,LAST_FAILED_LOGIN_TIMEDATE,FAILED_PASSWORD_ATTEMPT_COUNTNUMBER,IS_LOCKED_OUTCHAR NOT NULLCONSTRAINT ck_stu_account CHECK (IS_LOCKED_OUT IN ('Y','N')),LAST_LOCKED_OUT_TIMEDATE,LAST_PASSWORD_CHANGED_TIMEDATE);/INSERT INTO stu_accountVALUES(82001, '99CpsBTKpN',TO_DATE('02-APR-2015 14:05:08', 'DD-MON-YYYY HH24:MI:SS'),NULL, 0, 'N', NULL, TO_DATE('02-DEC-2014 13:05:08', 'DD-MON-YYYY HH24:MI:SS'));INSERT INTO stu_accountVALUES(82002, 'ZWNWnQJT90', TO_DATE('02-DEC-2014 16:15:01', 'DD-MON-YYYY HH24:MI:SS'),NULL, 0, 'N', NULL, TO_DATE('02-NOV-2014 11:11:18', 'DD-MON-YYYY HH24:MI:SS'));INSERT INTO stu_accountVALUES(82003, 'gc88Wmvpx8', TO_DATE('01-APR-2015 19:15:08', 'DD-MON-YYYY HH24:MI:SS'),TO_DATE('05-MAY-2015 21:45:18', 'DD-MON-YYYY HH24:MI:SS'), 1, 'N', NULL,TO_DATE('30-JAN-2015 23:01:01', 'DD-MON-YYYY HH24:MI:SS'));INSERT INTO stu_accountVALUES(82004, 'KcxweSYg555', TO_DATE('03-JAN-2015 14:12:33', 'DD-MON-YYYY HH24:MI:SS'),TO_DATE('06-MAY-2015 09:12:22', 'DD-MON-YYYY HH24:MI:SS'), 5, 'Y', TO_DATE('06-MAY-2015 09:12:22', 'DD-MON-YYYY HH24:MI:SS'), NULL);INSERT INTO stu_accountVALUES(82005, 'CDYe44BBXd1', TO_DATE('22-MAR-2015 05:22:18', 'DD-MON-YYYY HH24:MI:SS'),NULL, 0, 'N', NULL, NULL);INSERT INTO stu_accountVALUES(82006, 'vhSDHMDg666', TO_DATE('07-FEB-2015 04:00:08', 'DD-MON-YYYY HH24:MI:SS'),NULL, 0, 'N', NULL, TO_DATE('01-FEB-2015 04:35:01', 'DD-MON-YYYY HH24:MI:SS'));COMMIT;Based on theSTU_ACCOUNTtable created in (1), create a procedure to change the password for a givenstudent ID.A password is case-sensitive.A password must be between 8 and 20 characters in length.A password must include at least one uppercase alphabetic character (A-Z), one lowercase

• 1496734919-stu_table.docx

ComputerScienceExpert

(11)

Status NEW Posted 06 Jun 2017 07:06 AM My Price 8.00

-----------

Attachments

file 1496734921-Solutions file 2.docx preview (51 words )

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 -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer