Skip to main content

Posts

Showing posts with the label ict

ICT in space?

Space Exploration Knowledge of space in the 20th century is not possible without the use of information and communication technology. By capturing, processing and storing data, it is possible to quickly learn about starlight falling on the surface, space, other planets and Earth. In September 1962, US President Kennedy made an appeal to students and faculty at Rice University for American research into space. Man wanted to go to the moon not because it was easy, but because it was challenging. Man traveled to the moon by proving the power and capability of man. Information technology was still being used when Galileo was looking at the stars, moon and planets through a telescope. When space travel was first ventured into, not much was possible without the help of IT. Space flights move at such high speeds that it is impossible for humans to calculate their positions. Let's say the rocket is traveling at 30,000 km/hr in space. The speed, trajectory, fuel, temperature, direction etc....

Basic concepts of data security and authentication

 Basic Concept on Data Security & Authentication Entity Level Security The security system is greatly strengthened by database authorization. Even then, security breaches do occur. Various unauthorized persons breach security through database misuse and accidents. But this is not desirable at all in case of database. Therefore, a security method called encryption is used in the database management system to further strengthen the security system. Data Recovery Database data is lost when the computer system fails or crashes due to any reason. The process by which this lost data can be recovered is called data recovery. Failures are of various types, namely-  (i) Transaction Failure (ii) Logical Error (iii) System Error  (iv) System Crash (v) Disk Failure Authorization Authorization is a process by which database security can be controlled. A database user can have different types of authorizations. This is dependent on database security. When the query processor transl...

What are the fundamental operations of SQL?

Fundamental Operation of SQL SQL in data definition Data is defined or defined using SQL through the CREATE statement. An example is given below CREATE TABLE Employee() Emp_No NUMBER (5) NOT NULL Name CHAR (20) Skill CHAR (20) pay_rate NUMBER (10, 2); Explanation of the statement: (i) A table named Employee can be created through this SQL. The table will have four fields named Emp_No, Name, Skill and Pay_rate. (ii) Emp_No field will be NUMBER type data and this field will never be empty as it is declared as NOT NULL. (iii) Name field will be Character tight data and its length will be 20. (iv) The Skill field will be Character tight data and its length will be 20. (v) Pay_rate field will be NUMBER data type and its length will be 10 and 2 digits after decimal. Now let's say we want to add a new field to this table. Then type the following command: ALTER TABLE Employee ADD Phone_No NUMBER (10); Now type the following command to delete the Employee table. DROP TABLE Employee. SQL in ...

What are the types of programming languages?

Computers can only understand machine language. If a program is written in another language, the computer converts it into machine language with the help of a suitable translator (assembler, compiler, interpreter) before execution. Programming languages ​​are again divided into different levels on the basis of program composition features: 1. Low Level Language   -Machine Language, Assembly Language 2. Mid Level Language -C, Forth, Dbase, WordStar 3. High Level Language -Fortran, Basic, Pascal, Cobol, C, C++, Visual Basic, Java, Oracle, Python 4. Very High Level Language (4GL) -SQL, Oracle 5. Natural Language - Human language