Functional Dependency in DBMS and Addressing Modes in GATE Computer Science Engineering Syllabus

by -21 views
Dependency

GATE Computer Science Engineering Syllabus is released annually by the GATE authorities on their official website. The syllabus is vast, and candidates must know every topic in detail to score a good rank. If you are a GATE CSE candidate, check the updated GATE syllabus for CSE 2023 before starting your preparation. The GATE 2023 syllabus will be released by the authorities on the official website very soon. The General Aptitude (GA) syllabus will hold 15% weightage, while the Computer Science (CS) endures 85% weightage.

Here, this article will discuss Functional Dependency in DBMS and Addressing Modes from GATE Computer Science Engineering Syllabus.

Functional Dependency in DBMS

Functional Dependency in DBMS is denoted as X → Y, where X is a set of attributes that determines the Y value. The attribute  X is called Determinant, while Y is called Dependent. It is mainly used to express relations among database entities mathematically. For examinations like GATE, it is crucial to understand these advanced concepts in the Functional Dependency in DBMS (or Relational Database System).

Here X and Y will be the primary and dependent non-key attributes, respectively. It shows that the primary key attribute X is functionally dependent on the non-key attribute Y. Therefore, the functional dependency of column Y on column X is symbolised as X → Y.

Types of Functional Dependency

There are four major types of Functional Dependencies:

  • Trivial Functional Dependencies
  • Non-Trivial Functional Dependencies
  • Completely Non-Trivial Functional Dependencies

Addressing Modes

Addressing Mode helps specify how a particular instruction represents the effective address of an operand. Some Addressing Modes allow you to efficiently reference a wide range of areas, such as a linear array of addresses with a list of addresses. Addressing Modes describe an efficient and flexible way to define complex effective addresses. 

Programmes are generally written in high-level languages. This is a convenient way for programmers to define variables along with the operations they perform on them. This programme will be compiled later to generate the actual machine code. The machine code contains low-level instructions. The low-level instruction set has operands and opcodes. Addressing mode has nothing to do with the opcode part. Basically, it focuses on the representation of the address of the operand in the instruction.

Addressing Modes Types

The list below shows the various types of Addressing Modes:

  • Implied Mode
  • Immediate Mode
  • Register Mode
  • Register Indirect Mode
  • Autodecrement or the Autoincrement Mode
  • Direct Address Mode
  • Indirect Address Mode
  • Indexed Addressing Mode

 

The discussion above on Functional Dependency in DBMS and Addressing Modes gives you an idea about the two topics in the GATE Syllabus For CSE (Computer Science Engineering). The description provided here is very brief, as the main aim is to give an overview of the topics. Candidates must work hard to understand these topics or any topic in the syllabus, as every topic is equally important. The competition in subjects like CSE in the GATE Exam is very high. Every year, more than 1 lakh students apply for this exam. However, there are many opportunities after clearing GATE, but compared to the number of applicants, it’s still low. Therefore aspirants who wish to get a job at PSU or enrol in M.Tech courses in the best institutions must work hard enough to score the best rank.

Candidates can also enrol in various GATE online programmes. Many online and offline GATE courses have been designed accordingly to help every GATE 2023 aspiring student crack the examination through keen logic and shortcut tricks.

Leave a Reply

Your email address will not be published.