Posts

What is a file organization?which type are expression of file organization.

What is a file organization? Which is type of expression are file organization? What is a file organization? A database is a collection of interrelated records.The mechanism used to represent and store the record in a file is called the file organization. File organization technique may be of following types:- ✍️ Heap (Pile)file organization:-                  The record are stored in available blank block as they arrive,i.e.records can be placed anywhere in the file where there is space for the records. ✍️  Sequencial file organization:-                   The records are stored in sequencial order of key field.A sequencial file could be stored on a sequencial storage device such as  magnetic tape. ✍️ Indexed sequencial file organization:-                    A retrieval of a record from a sequencial file requires on average access to half ...

The column constraints apply to the single column within a single base table are the syntax

Column constraints apply to the single column within a single base table are the syntax column - name {data - type | domain} [DEFAULT {literal| niladic -functiona | NULL] [column -constraint - definition - list] Here the'column constraint -definition -list' specifies the column constraint. A column_constraint definition can be any of the following:- ➡️NOT NULL ➡️PRIMARY KEY or UNIQUE ➡️A 'references definition' ➡️A 'CHECK constraint' definition The RDBMS automatically evaluates the check constraints expression whenever an SQL INSERT, UPDATE or DELETE statement is executed.If the evaluation of the CHECK constraint is true,then the update is allowed otherwise the data in the table remain unaltered. CREATE TABLE EMPLOYEE         (EPNO NUMERIC (4) NOT NULL,         EMPID CHAR (3),         NAME CHAR (30) NOT NULL, DEPTID CHAR (2) NOT NULL WITH DEFAULT, BONUS NUMERIC (6,2) NOT NULL, CHECK (BONUS BETWEEN 4000.00 AND 10000.00),   ...

The analysis of faults in power system

They can be used in the analysis of faults in power system Consider a short section of a transmission line in which phase a is grounded.The fault as occurring on a short stub line,built out from the line at the fault point.               Assuming that the power system consists of linear elements the whole system can be reduced to a single generator with an equivalent internal impedance by using Thevenin's theorem.The emfs Ea1, Ea2 ,Ea0 are the symmetrical components of the open circuit voltage to ground before the fault occurred. The prefault Volta are balanced and therefore,                   Ea1 =Ea                    Ea2 = 0 And            Ea0 = 0 The impedance Z1, Z2 and Z0 are the positive, negative and zero sequence impedance viewed from the fault point. Procedure for fault calculation:- ✍️Zero sequence impedance diagram is...

Write ✍️ the explanation are Histogram Processing

Write ✍️ the explanation are Histogram Processing. The histogram of a digital image with intensity level in the range [0,1,-1] is a discrete function given by                 h(rk)= nk Where,           rk= kth intensity value           nk = no. Of pixel in the image having intensity level rk. h(rk)= histogram So, we have L number of intensity in the image when we get the number of pixel having an intensity value rk and if we plot their number of pixels having different intensity value of these pixels then the plot we get is known as histogram. What is a restoration technique? ➡️ Image filtering:-                                It is used to recover the image from the degraded image i.e. by applying inverse filtering we can estimate fourier transform of original image F(u,v) from the degraded image G(u,v)     ...

What is Mask processing? Explain it.

Explain the image enhancement technique. It is a technique to process an image to enhance certain features of the image.So, that the results is were suitable than the original image. There are two technique of image enhancement:- ➡️ Spatial domain technique:-       https://technicaleduarkujur.blogspot.com/2020/12/blog-post.html                  This technique works an image plane itself i.e., this technique tries to directly manipulate the pixel in the image. ➡️ Frequency domain technique:-                          In this technique operation are performed on the Fourier transform of an image rather than on the image itself i.e.,first we take Fourier transform. What is Mask processing? explain it. It is another kind of spatial domain operation where neighbourhood size is larger than 1.i.e. 3×3, 5×5 etc.                 ...

Relational database design

Relational database design are the best system analysis. One should be able to specify how entities within a given entity set and relationships within a given relationship set are distinguished.There are some subset of attributes of a relational schema R present with the property that no two tuples in any relation instance r of R should have the same combination of values for these attributes. Closure of a Set of functional Dependencies We say that such functional Dependencies are logically implied by F.           Suppose we are given a relation schema R=(A,B,C,G,H,I) and the set of functional Dependencies                        A ➡️ B                        A ➡️ C                      CG ➡️ H                      CG ➡️ I    ...

Network theorem are the best point about network analysis

Network theorem are the best point about network analysis ✍️Maxwell's Mesh current method:- In this method Kirchhoff's voltage is applied to a network to write mesh equation in terms of mesh current. ✍️Nodal analysis:- Nodal analysis essential aims at choosing a reference node in the network and then finding the unknown voltage at the independent nodes w.r.t. reference node. ✍️Superposition theorem:- This theorem is called superposition becouse we superpose or algebraically add the components (current or voltage)due to each independent source acting alone to obtain the total current in or voltage across a circuit elements. ✍️Thevenin's theorem:- Any linear bilateral network having terminals A and B can be replaced by a single source of e.m.f.Vth in series with a single resistance Rth. १)The emf Vth is the voltage obtained across terminals A and B with load,if any removed i.e.it is open-circuited voltage between terminals A and B. २)The resistance Rth is the resistance of th...