Table and it's operations


Table and it's operations


Table/Entity

To represent this information one can use DBMS modeling. In a DBMS a group of similar information or data which is of interest to an organization is called an Entity. Entity information is stored in an object called Table. For example, a client is considered an entity. Information about the client entity can be stored in a client_master table. A table is really a two dimensional matrix that consists of rows and columns.

Attributes/Columns/Fields




Each entity can have a number of characteristics. A client can have characteristics like name, address, telephone number, fax number, balance due etc. The characteristics of an entity are called Attributes. The values for these characteristics are called Attribute Values.
When entity information is stored in a table, the attributes associates with the entity are stored in the table columns / table fields. The client_master table can have columns like name, address, telephone_number, fax_number, bal due in with the user can store attributes values like "Datamatics", "Vindhya Valley", "614572", "6122897", "2200.00".
Thus information in the client_master table will be

Name
Address
Telephone
Number
Fax Number
Balance 
Due
Datamatics
Vindhya Valley
614572
6122897
2200.00
THE DATA TYPES THAT A CELL CAN HOLD

Data Type
Description
CHAR(size)
:
This data type is used to store character string values of fixed length. The size in brackets determines the number of characters(i.e. the size) this data type can hold is 255 characters.
VARCHAR(size) / VARCHAR2(size)
:
The data type used to store variable length alphanumeric data. The maximum this data type can hold is 2000 characters.
NUMBER(P, S)
:
The NUMBER data type is used to store numbers (fixed or floating point). Numbers of virtually any magnitude maybe stored up to 38 digits of precision. Number as large as 9.99*10 to the power of 124, i.e. I followed by 125 zeros can be stored.
DATE
:
This data type is used to represent date and time. The standard format is DD-MM-YY as in 20-MAY-99.
LONG
:
This data type is used to store variable length character strings containing up to 2GB. LONG data can be used to store arrays of binary data in ASCII format. LONG values cannot be indexed, and the normal character functions such as SUBSTR cannot be applied to LONG values.
RAW/ LONG RAW
:
The RAW /LONG RAW data types is used to store binary data, such as digitized picture or image. Data loaded into columns of these data types are stored without any further conversion. RAW data type can contain up to 2GB. Values stored in columns having LONG RAW data type cannot be indexed.

Comments

Post a Comment

Popular posts from this blog

Rumors of women’s hair cutting in India

Image
Rumors of women’s hair cutting in India This time a rumor is moving around India that hair of women cutting by unknown. First a matter came from Punjab. This was first time so people have not taken it seriously. After this there are more than five cases registered in police stations. In Delhi also it happened after 2 days. There were 3 women reported about this matter. After this, in five states are under of this rumor. Reasons behind this It is not clear this time that what happening with the women’s hair. Because no one able to see anyone to cut. Some people are assuming that any “evil “soul is wondering. This type of perception is to strong in rural areas. There is a big topic for media so television is also focused on this matter. Police says that they cannot say anything about this matter. Victim’s point of view A woman says that when she was sleeping it may be happened. She did not see anyone to cut her hair. She was sleeping in her room. It was very su
Read more

President of India

Image
Today new president of India   Now Mr. Ramnath Kovind is the 14th president of India. Today he take quoth for presidency. The Mr. Pranav da will former president. In this occasion Mr. Kovind told something about poorness in India. Why not after all he also belonged  to a poor family in his childhood. He always remembering his struggled time. One thing was different that he remembered this time suffering families. Indians are hopeful that he will extra work to fight these problems in India. Take a look at Mr. Ramnath Kovind carrier. It is not easy to describe his work in words but i am trying- 1. Mr. Ramnath Kovind born at 1 October 1945 in Paraukh village in Kanpur. 2. Mr. Ramnath Kovind's father Maikulal was very poor. 3. Mr. Ramnath Kovind have 5 brothers and 2 sisters.president is youngest in all. 4.  He is graduate in law from college in Kanpur. 5. He passed civil services exam in third attempt but he did not join. 6.Mr. Kovind was advocate in 1971 wi
Read more

Java interview question answer

1. What is java? Java is a OOP based computer programming language.  2. Explain, what is the difference between private, protected, and public in java? These java keywords are for following privileges to component such as variables and methods. Public: All classes can be access Private: Can be access only the class to which belongs Protected: Can be access to the class to which they belongs and any subclasses. 3. What are access specifiers in java? Access specifiers are keywords that determine the type of access to the member of a class.  There are four types of specifiers in java (a) Public, (b) Private, (c) Protected, and (d) Defaults. 4. What's the difference between normal methods and constructors? Constructors cannot return a value and must have the same name as the class. Constructors are only called once while normal methods could be called many times and it can return a value or can be void (it is your choice).  5. It is possible to call on
Read more