Skip to main content

Posts

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: Repo...

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...

Installing Python in own Computer

  Now, we are learning how to install python in our computer. 1. For Installing Python on Windows Operating System Connect the internet and then open any browser. visit  https://www.python.org/  and go to download section and choose windows. and Download the installer File(".exe") for 64 bit system download x64 and for 32 bit system x86 in local computer. Launch the Downloaded package by double click on it. "Open File- Security Warning" Dialog Box appears on the screen. Click on Run Option. Now the Python setup window appears. Check the both checkboxes of install launcher for all users and add python(downloaded version)  to Path. Now Click on "Install Now" option. and wait some time for installing. When the installation will completed "setup was successfull" notice we get now click on Close button to Complete installation process.

Introduction Of Python Programming Language

A set of predefined instructions in logical manner makes up a program.  One of the most important aspects of computer field is to make ‘Programs’.  A program is written in a computer language, like BASIC, ‘C’, ‘C++’, Python, etc.  A computer language consists of codes which are combined in accordance with a predefined syntax, that conveys the instructions to the components (ALU) of CPU. Python has evolved into a very useful language as it is simple and is being used in many fields such as in Robotics, Scientific Purposes (Used by NASA), search Engines (Google), YouTube, Hardware Testing (Being used by Intel, Cisco, HP, etc.), GUI Interface (Popularly used in GIMP), 3D Animation (Maya) etc. Features of Python Programming Language:   The keywords of Python are in simple English. Python library is portable and compatible with all types of Operating System hence it is known as platform independent programming language. Python is an interpreted language i.e. Python interp...

TYPES OF COMPUTER

     Super Computer Supercomputers are the fastest computer and have a large data storage capacity. A supercomputer can execute more than 100 million instruction per second. It has multiple processors which are based on parallel processing architecture for achieving high speed. It is made for some special purpose. It can support more than 1000 users at a time. It is used for Space Research, satellite management, Wheatear forecasting Aerodynamics, and complex computation. Ø First Indian Super Computer “PARAM2000”. Ø The first supercomputer is CDC 6600 (designed by CDC Control Data Corporation in USA). Ø The first five fastest supercomputer of the world are 1.       Summit (US) 2.     Sierra (US) ... 3.     Sunway TaihuLight (China) ... 4.     Tianhe-2 (China) ... 5.      Frontera (US) Ø Speed of Supercomputer is measured in FLOPS. Ø FLOPS (Floating Point O...

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...

CONVERSION BEETWEEN OCTAL AND BINARY BY TWO METHODS

Conversion Octal To Binary : We can Convert Octal number into binary no by two methods:- 1. Convert Octal to Decimal and again Convert Decimal into Binary. Ex-   (256)8=(?)2 Sol.  Convert it in Decimal          (256)8         =2 x8 2  + 5x8 1  + 6 x 8 0         =2x64+5x8+6x1         =128+40+6         = (174) 10           Now Convert it into Binary, 2 174 R 2 87 0 2 43 1 2 21 1 2 10 1 2 5 0 2 2 1 1 0 (174)10=(10101110) 2 2. Convert to Octal to Binary with the help of list. Determine the value of each digit according to the geven list: 0=000 1=001 2=010 3=011 4=100 5=101 6=110 7=111 Steps:- Write  the value of each Digit according...