In transmission media is the way the systems are connected to route data signals in a network.The telecommunication links are classified into two categories −Guided media (wired)Unguided media (wireless).Both guided and unguided are used for short distance (LANs, MANs) as well as long distance (WANs) communication.Let us discuss Guided transmission ... Read More

ProblemDrawing of ER model of university database application considering the constraints −A university has many departments.Each department has multiple instructors (one person is HOD). Here the HOD refers to the head of department.An instructor belongs to only one department.Each department offers multiple courses, each subject is taught by a single ... Read More

Data independence is the ability to modify the scheme without affecting the programs and the application to be rewritten. Data is separated from the programs, so that the changes made to the data will not affect the program execution and the application.We know the main purpose of the three levels ... Read More

A database administrator (DBA) is a person or group in charge of implementing DBMS in an organization. The DBA job requires a high degree of technical expertise. DBA consists of a team of people rather than just one person.The primary role of Database administrator is as follows −Database designPerformance issuesDatabase ... Read More

BCNF (Boyce Codd Normal Form) is the advanced version of 3NF. A table is in BCNF if every functional dependency X->Y, X is the super key of the table. For BCNF, the table should be in 3NF, and for every FD. LHS is super key.ExampleConsider a relation R with attributes ... Read More

The Turing Machine (TM) is the machine level equivalent to a digital computer.It was suggested by the mathematician Turing in the year 1930 and has become the most widely used model of computation in computability and complexity theory.The model consists of an input and output. The input is given in ... Read More

DFA is the short form for the deterministic finite automata and NFA is for the Non-deterministic finite automata. Now, let us understand in detail about these two finite automata.DFAA Deterministic Finite automata is a five-tuple automata. Following is the definition of DFA −M=(Q, Σ, δ, q0, F)Where, Q : Finite ... Read More

The main operation performed by operating system is to carries out is the allocation of resources and services, such as allocation of the following −MemoryDevicesProcessorsInformationThe operating system includes programs that are helpful to manage these resources, such as a traffic controller, a scheduler, memory management module, I/O programs, and a ... Read More

Computer architecture can be defined as a set of rules and methods that describe the functionality, management and implementation of computers. To be precise, it is nothing but rules by which a system performs and operates.Sub-divisionsComputer Architecture can be divided into mainly three categories, which are as follows −Instruction set ... Read More

The three-schema architecture divides the database into three-level used to create a separation between the physical database and the user application. In simple terms, this architecture hides the details of physical storage from the user.The database administrator (DBA) responsible is to change the structure of database storage without affecting the ... Read More