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

Computer Generations

 Computer Generations   Computers have evolved over time through different generations, each marked by significant technological advancements and changes in design and architecture. These generations are often categorized based on the underlying hardware and the key developments that distinguish one Generation from another. Let's explore the main computer generations: First Generation Computers    The First Generation of computers refers to the initial period of electronic computing, characterized by the use of vacuum tubes as the primary electronic component. This Generation spans the 1940s and 1950s and is marked by groundbreaking developments in computer technology.  Examples of First-Generation Computers:  o ENIAC (Electronic Numerical Integrator and Computer): Completed in 1945, ENIAC was one of the first electronic general-purpose computers. It was designed to calculate artillery firing tables for the United States Army during World War ...
1 comment
Read more

Computer Basic

  The word “computer” comes from the word “compute”, which means to calculate”. Charles Babbage is known as the ' Father of computer' .  A computer often referred to as a “data processor” because it can store, process, and retrieve data whenever desired.  The activity of processing data using a computer is called data processing.    Data processing consists of three sub activities:- (1)          Capturing input data (2)          Manipulating the data and (3)          Managing output results. Data : - Data is raw material used as input to data processing. Data can be anything like numerical, non-numerical or a mixture of both. Information : - Information is processed data obtained as output of data processing. Computer: - A computer is an electronic device which performs numerical calculation and logical calculation at hig...
7 comments
Read more

Office Package and Features of Office Package

Most of the official jobs today are dependent on computers. Computer helps in accomplishing different types of official tasks with the help of 'Office Package'. With the help of 'Office Package ' to accomplish basic tasks like typing and composing letters, doing calculations and comparisons, manipulation data and generating multiple types of reports, making presentation for demonstration, seminars etc.   For example: MS Office, OpenOffice, etc. Office package includes the following applications: 1. Word Processor:  A word processor is a type of application software that enables to create a documents by enabling to type text, insert page number, header, footer, edit, modify , and to take print or save documents in soft copy for future use.   2. Spreadsheet:   A spreadsheet package is an application software that stores data in an organized way and help to  analyse, calculate, compare the data or values. It also enables to present information in graphs, pie c...
Post a Comment
Read more