Answer:
A key field is used to uniquely identify each record for retrieval or manipulation.
Explanation:
In a database there are many, having similar entities. So in order to differentiate each entity from other we need to set a key field among all the field which is always unique for each entity.
For example:
In a database of a company having data about its employees, the key field might be their ID. As some employees can have same names, addresses, phone numbers but cannot have the same ID.
Answer:
The capability to program for a longtime and not burn out and to know a few coding languages as well as have the ability to learn new languages quickly.
Answer:
ICT is the abbreviated form of Information and Communication. It included different technologies like mobile phones, computers, USBs etc.
Following are two precautionary measures which should be observed when using any kind of ICT:
- Use of Antivirus: It can used to protect anything placed inside the technology especially from hacking and viruses which can create many issues.
- Backup Data: Creating a backup of the data stored in the device is important as it can be recalled when the device malfunctions. Backup of the data can be created through using USBs, CDs etc or through cloud storage
Answer:
The two type of electronic components are Active components and passive components
Active components are parts of a circuit that rely on an external power source to control or modify electrical signals. ... - Passive components like resistors, transformers, and diodes don't need an external power source to function. These components use some other property to control the electrical signal.
Answer:
Following are the solution to this question:
Explanation:
Some of the data is missing in the question, which is defined in the attached file. Please find it.
Follows are the formula which is used in the question:
- EmployeeAnalysis Worksheet IF(C5>49,"Certified","Not Certified")
- Transactions Worksheet IF(F10="No","",0.07)
In the first condition, it checks "C5" is greater than 49 if the condition is true, it will give "Certified" otherwise, it will give "Not Certified".
In the second condition, it checks "F10" is equal to "No" if the condition is true, it will give a blank or space otherwise, it will give "0.07".
