Database Key

Database is a repository of any organization data. It takes data save it and provides many types of sophisticated services for record insert, update, delete, backup and many more. Here I am interested to explain many types of key.

Database : Database is a collection of related table.

Table : A Table is a collection of related records.

Record : A record is a collection of related fields

Field : A fields or attribute is a smallest individual unit of table.

NULL : NULL is a systematic approach treat blank value which is not available current but might be appear in future.

Key : Key is use to identified a record between records set.

How to make Gmail Signature and confidential Message

What is Gmail Signature

A signature is a bit of text (such as your contact information or a favorite quote) that’s automatically inserted at the bottom of every message you send. Here's a sample signature:

Functional Dependency and Normalization

Purpose of Normalization

Normalization is a technique for producing a set of suitable relations that support the data requirements of an enterprise.

Characteristics of a suitable set of relations include:

- the minimal number of attributes necessary to support the data requirements of the enterprise;
- attributes with a close logical relationship are found in the same relation;
- minimal redundancy with each attribute represented only once with the important exception of attributes that form all or part of foreign keys.

Data Communication and Networking

Line Configuration

A network is a combination of more than one devices which connect from some medium (wire , wireless) called channel line configuration refer physical communication channel access method . Three types of access method are follows..

• Point to Point
• Multi Point

Point to Point

Communication line is not shared in point to point line configuration. A separate link used to connect each device in network. Advantage of point to point line configure is no congestion. Highly and sophisticate security implementation is possible.

The entire capacity of the channel is reserved for transmission between those two devices. Most point-to-point line configurations use an actual length of wire or cable to connect the two ends, but other options, such as microwave or satellite links, are also possible.

Multipoint 

Multipoint (Multidrop line configuration) Communication link is shared between all connected nodes from the network. Two types of multipoint line configuration are follows

Spatial Sharing: If several devices can share the link simultaneously, its called Spatially shared line configuration

Temporal (Time) Sharing: If users must take turns using the link , then its called Temporally shared or Time Shared Line Configuration