Question No. 44Under the e-Shram portal, workers will be issued an e-Shram card containing a _________ digit unique number.

Develop a job card (10marks)

Question:EXON (PVT) Ltd. Sri Lanka provides Specialized Software Engineers for other Companies ontemporary basis to work for their projects. Worked time of EXON Software Engineers atother companies are recorded in the following table NICN (National Identity Card Number) isused in EXON to identify their Software Engineers Uniquely.(Table given)NICN,"Contract No",Hours,"Employee Name","Company ID","Company Location"892660522V,"IT 2014",27,A.Janith,"IT 001",Kandy880944993V,"IT 2014",84,T.Tharaka,"IT 001",Kandy842564347V,"IT 1995",42,C.Asela,"IT 120",Colombo892660522V,"IT 1995",42,A.Janith,"IT 120",Colombo1. What is Normalization?2. Define 1st Normal Form, 2nd Normal Form and 3rd Normal Form3. To which normal form this table belongs to4. Identify the Primary key of this relation and justify your selection5. Identify Fully Functional Dependencies and Partial Dependencies on the Primary Key6. Normalise the above mentioned table to 2nd Normal Form7. Identify the Transitive Dependencies on above 2nd Normal Form tables8. Normalise above mentioned tables to 3rd Normal Form9. Design an ER diagram for 3rd Normal Form.(Note: Illustrate the tables in DBML (Database Manipulation Language) and display thePrimary Key and Foreign Key in all the relations)Additional GuidelinesStudent should design a normalized ER diagram according to the following guideline1. Student has to convert a given Un-normalized data structure to its third normal form.2. Each process/ step of normalization should be described.3. Design a normalized ER diagram.

Question 9A security professional is asked to issue a keycard to a new employee. Which domain does this scenario relate to?1 pointCommunication and network securityIdentity and access managementSecurity and risk managementSecurity assessment and testing

Imagine that you are working at Income Tax Department, and you have been assigned the task of determining whether a given PAN card number is valid or not. If it is not valid, you should inform the user which character at position "x" is not valid. In this case, "x" corresponds to the index of the first invalid character.To qualify as a valid PAN number, it must meet the following conditions. 1.    It should be ten characters long.2.    The first five characters should be any upper-case alphabets.3.    The next four-characters should be any number from 0 to 9.4.    The last character should be any upper-case alphabet.5.    It should not contain any white spaces.Input:StringOutput:Valid or Noty at position x is not-valid (if not-valid)Eg: Input:BNZAA2318JOutput: ValidEg: Input:2NZAA2318JOutput: Not2 at position 0 is not-valid

Question 9A security professional is asked to issue a keycard to a new employee. Which domain does this scenario relate to?1 pointCommunication and network securityIdentity and access managementSecurity assessment and testingSecurity and risk management