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

ARITHMETIC OPERATIONS ON BINARY NUMBER

Binary arithmetic is simpler to learn because binary number system deals with only two digits - 0 and 1. Binary number perform all arithmetic operation such as Addition, Substraction, Multiplication and compliment as in decimal number system. Binary Addition The addition table for binary arithmetic consist of only the following four entries: 0+0=0 0+1=1 1+0=1 1+1=0 , plus a carry of 1 to the next column.     1011        + 1100    10111     1100    + 1100     11000 Binary Substraction There are three ways to do substraction between binary numbers:- 1. Simple Substraction 2. Substraction using 1's Complement 3. Substraction using 2's Complement Simple Substraction: The complete table of binary substraction is as follows: 0-0=0 0-1=1, borrow 1 from next column 1-0=1 1-1=0    1101 - 0101   1000     1001   - 0111    0...
Post a Comment
Read more

Media Of Communication Part 2

Unguided Media Unguided media transport electromagnetic wave without using a physical connection. This type of communication referred as wireless communication. We can divided wireless transmission in :-   1. Radio Wave:- Electromagnetic   waves ranging in frequencies between 3KHz and 1GHz are normally called radio wave.   On radio wave connectivity used communication used Bluetooth, Wi-Fi, etc.     Bluetooth :- It is a wireless network connectivity that enables to connect or transfer data between devices over a short range the physical range of connection up to 100 meter. Ex- Mobile phone, barcode scanning, portable speaker, wireless keyboard, mouse etc.      Wi-Fi (Wireless Fidelity):- Wi-Fi is a network of wireless connection. Wi-Fi network establish by radio frequency like Bluetooth, but has more power, resulting a strong connection.    ·   Wi-Fi is also called wireless Ethernet. It has connectivity range up...
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