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 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 high speed and produces information that are expressible in numerical as well as in logical form. Computer Stands For       C = Common
Read more

Character Set and Tokens in Python

-
Image
  Character Set : Character Set in Python consist of  valid characters such as alphabets, digits or special characters that are recognized by the library of Python Language. Alphabets:                         A,B,......Y,Z or a,b,.......y,z. Digits:                               0,1,2,3,4,5,6,7,8,9 Special Character:      ~!@#$%^&*()_+{}[];:'"\,./<> etc. White spaces    :             Blank space, new line, etc. Token: The smallest individual unit in a program is referred as 'Token'. It is also called Lexical Element or Lexical Unit. It can be categorized as: 1. Keywords : Keywords are the reserved words that has specific function in a program. These words are used while writing program to get desired output. The keywords are executed  as its purpose/action is already explained inside the language interpreter. All Keywords are written in lower case. Keywords are also called 'Reserved Words'. There are 33 keywords in Python. 2. Identifiers : Identi
Read more

DATABASE INTRODUCTION

-
Database : A database is an organized collection of related information in which facts are properly arranged and stored.  A database is made up of a basic unit called “Table”.  A table is made of different ‘Fields’ and ‘Records’.  Record : Collection of organized data or related facts is called Record.  Field : A field is a collection of same data types.  DBMS (Database Management System): A database Management System is a tool for managing and manipulating information of a database.  The main Functions of a DBMS is:  Creating Database.   Adding Records.  Modifying Records.  Displaying Records.   Storing Records.   Deleting Records.   Generating Reports.   Printing Reports.  Some Example of DBMS: MS Access, My-SQL,etc.  Features of DBMS: DBMS ensures data security. DBMS facilitates the sharing of data among different database. DBMS controls data inconsistency to a large extent. DBMS reduces the data redundancy to a large context. Data Consistency : Data consistency means that if any c
Read more