Showing posts from February 11, 2024
Binary Tree Traversal 1) Traversal is the process of visiting every node at least once 2)Visiting a node involves doing some processing at that node, but when describing a traversal strategy, we need not concern ourselves with what that processing…
Closure of a functional dependency It refers to the set of functional dependencies that can be inferred from a given set of functional dependencies. It is the process of finding all the functional dependencies that can be derived from the original s…
Properties of Functional Dependency in DBMS 1.Reflexivity: If A is a set of attributes and B is a subset of A, then the functional dependency A → B holds true. For example, { Employee_Id, Name } → Name is valid. 2. Augmentation: If a functional dep…
Views in SQL View can be created by selecting the fields from one or more tables present in the database. It can be either have specific records based on certain condition or all the records of a table. Like table in SQL view also contains rows and c…
Second-Order Partial Derivatives By differentiating a function z = f(x, y) twice , we get its second-order derivatives. These derivatives are usually denoted by: Examples : 1. If f( x, y) = x cos y + y e^ x , then find ∂f/ ∂x , ∂f/ ∂y , ∂^ 2f / ∂x…
Key is used to uniquely identify any record present in the table. A DBMS Key can be an attribute or a set of attributes which helps to identify a record of a table. For Example : Types of key: Primary key Candidate key Super Key Foreign key Alterna…
Different types of commands in SQL : 1)DDL - Data Definition Language 2)DML - Data Manipulation Language 3)DCL - Data Control Language 4)TCL - Transaction Control Language 5)DQL - Data Query Language 1)DDL - Data Definition Language DDL Command used…
How to find partial derivatives? --> 1 ) If z = f(x, y) is a function of two real variables x and y, then partial derivative of z w.r.to x is denoted by and is the ordinary derivative of z w.r.to x by keeping y constant/fixed. 2)Similarly partia…
Q)which of the following are subset of vector subspace ...? Q) which of the following subset are linearly independent ...?
