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 ...
2 comments
Read more

Programming in "C"

 Introduction   C is a general-purpose programming language that was developed in the early 1970s by Dennis Ritchie at Bell Laboratories. It has since become one of the most widely used programming languages and has influenced the development of many other languages, including C++, Java, and C#. C is known for its efficiency, flexibility, and low-level programming capabilities. It is commonly used for system programming, embedded systems, and developing operating systems. C is also a popular choice for developing applications that require high performance, such as game engines and scientific simulations.   Here are some key features and concepts of C programming:   Syntax: C has a relatively simple syntax compared to some other programming languages. It uses a combination of keywords, variables, data types, operators, and control structures to write programs.  Variables and Data Types: You declare variables to store data in C. Various d...
Post a Comment
Read more

History of Language "C"

  History of C      The history of C programming dates back to the early 1970s when Dennis Ritchie created it at Bell Laboratories. Here's a brief timeline of the major milestones in the history of C:  1969: The development of C began as a successor to the B programming language, which Ken Thompson created. Dennis Ritchie wanted to improve upon B's capabilities and efficiency.  1972: The C programming language was developed primarily to support the development of the Unix operating system. Ken Thompson and Dennis Ritchie rewrote Unix in C, which helped in porting the operating system to different computer architectures easily. 1978: The first edition of "The C Programming Language," also known as the "K&R C," was published. Brian Kernighan and Dennis Ritchie wrote it, becoming the authoritative reference for C programming. 1983: The American National Standards Institute (ANSI) formed a committee to establish a standard for the C language. The ...
Post a Comment
Read more