Skip to main content

SOME IMPORTANT TERMS & DATATYPES OF DATABASE

The working of a Database starts with creation of tables. There are different elements in database package, all of which work together to make the database package function. Each element has a specific role to play. Some of them:-
1. Field Name: A field name is the identifier of a field as it contains the data that is to be stored in that field. It may consist of letters, numbers and special characters.
"It is the name of the column of a table."
2. Field Type: Field type or Data type signifies the type of data which will be entered in a particular field.
3. Properties: Field properties signify the behavior of the field. It helps in keeping the consistency of the data entered by the user.
4. Queries: Queries are the format of requirement of information that can be received on the basis of records stored in a table.
5. Forms: Forms are the layout for the entry of data. They are used as format to let the operatior feed/input data for creating records in a table.
6. Report: Reports are used to get or print the information from the database. They are based on the information found in tables as per the queries.
7. Primary Key: Primary key is the name of a field that uniquely identifies a record in a table. There can be only one(unique) primary key in the table.

DATATYPES IN DATABASE 

A database stores different types of data so a clear distinction has to be made between types of data for proper identification and for the kind of manipulation to be done on data. Data type of the field specifies what type or kind of data is to be stored in a particular field so that the respective kind of operations can be done on that data.
Some common data types are:-
Text: A field of this data type can store text or combination of text and numbers or numbers on which calculations cannot be done.
Numeric: A field of this data type can store numbers from zero to nine(0-9) or its combination on which calculations can be done.
Date/Time: A field of this type of data can store the date and time values.
Auto Number: A field of this data type automatically gets the value when a new record is added is added in a table. One cannot update or change the value of this type of field.
Yes/No: A field of this data type can store'Yes/No' or 'True/False' values. It is also called as Boolean data type.

Comments

Post a Comment

Popular posts from this blog

BASIC STRUCTURE OF A COMPUTER SYSTEM

Computer Function A computer performs action and accomplishes its task in three basic stages namely:- INPUT – Input is the data that is fed into the computer by the user. PROCESS – Processing refers to the series of action by which the computer converts raw data into information. OUTPUT – Output is the result which is termed as information. Input Unit Data and instructions enter a computer through an input unit in a form that depends upon the input device used. Ex- Keyboard, Mouse, Joystick, Scanner etc. CENTRAL PROCESSING UNIT (C.P.U) CPU is also known as the brain of the “Brain of Computer”. As it appears as a hardware component, but it is also a functional component of a computer system. Functional Elements of a CPU        1.        Arithmetic Logic Unit(ALU)        2.        Control Unit(C.U)        3.    ...
Post a Comment
Read more

DEVICES USED IN NETWORK

  1. MODEM: It stands for Modulator- Demodulator. A   modem is a peripheral device which modulates ( convert   digital signals to analog signals) and demodulates( convert   analog signals into digital signals) at the local workstation.   The sending and receiving ends of the communication must   have a modem. Now a days mobile phones have inbuilt   modem devices that help to browse internet.      2. Switch: A network switch is a small hardware device that is used to amplify data signals & create smaller network segment or several subnets of bigger network. It is used to prevent overloading of data in the traffic of a network. It is also responsible for forwarding and transforming data packets between the sub networks.    3. HUB:   A hub is a hardware device which provides common connection point to connect several devices together in a network. It contains multiple ports on which wo...
Post a Comment
Read more

Application OF Computer

Communication : - In the past, people used to communication through letters, telephones etc. The advent of computers has made it possible to share or exchange information in real time (instant). Information can be textual, graphics or visual from any corner of the world in different ways. Like – Email, Online chatting, Video conferencing, FTP (File Transfer Protocol), Telnet, Social Networking. News & Broadcasting : The delivery and reception of news has changed dramatically with the advent of computers. Earlier, Journalists used snail mail, reel-to-reel recorders, dark-room processing for photos and typewriters for composing contents. But now computers have facilitated in Instant Broadcast, Online Newspapers, Online News Channels, etc. Social Networking: Before the advent of computer, people used to interact with friends and relatives in closed groups and meet them during family functions, religious ceremonies and gatherings at local temples, gurudwaras, mosques or church...
Post a Comment
Read more