DBMS, Number Systems & Shortcuts: Concepts and Conversions
This section tests three different skills together: the basic terms of a database, the conversion of numbers between the binary, octal, decimal and hexadecimal systems, and the common keyboard shortcuts of a computer. Each part is fact based, so short and clear revision secures almost full marks.
This deep-study note covers the basic terms of a DBMS, the number systems and their conversions, the units of data and the keyboard shortcuts, the question patterns, a solving method, the traps examiners set and a preparation plan. After reading it, a candidate should be able to answer a database, conversion or shortcut question without hesitation.
Basic Terms
- Data: raw facts and figures that have little meaning on their own.
- Database: an organised collection of related data stored so that it can be searched and updated easily.
- DBMS: database management system, the software that creates and manages a database, such as MySQL or Oracle.
- RDBMS: a relational database management system, which stores data in tables that are linked by keys.
- Table: a set of rows and columns that stores data about one subject.
- Record: one complete row of a table, describing one entity.
- Field: one column of a table, holding one attribute of every record.
- Primary key: a field that uniquely identifies each record of a table.
- Foreign key: a field that links one table to the primary key of another.
- SQL: structured query language, used to create, read, update and delete data.
- Query: a request for data from a database.
- Number system: a way of writing numbers by using a fixed set of digits, called its base.
- Bit: a binary digit, either 0 or 1, the smallest unit of data.
- Byte: a group of eight bits.
Core Concepts and Rules
- A DBMS is software, while a database is the organised collection of data that the DBMS manages.
- A primary key is unique and cannot be empty, and a foreign key links two tables.
- SQL statements include SELECT, INSERT, UPDATE, DELETE, CREATE and DROP.
- The decimal system has base 10, binary base 2, octal base 8 and hexadecimal base 16.
- To convert decimal to binary, divide again and again by two and read the remainders upwards.
- To convert binary to decimal, add the place values where the digit is one.
- Octal groups binary bits in threes and hexadecimal groups them in fours.
- In hexadecimal the digits A to F stand for 10 to 15.
- The table of data units is 8 bits = 1 byte, 1024 bytes = 1 KB, 1024 KB = 1 MB, 1024 MB = 1 GB and 1024 GB = 1 TB.
- Ctrl+C copies, Ctrl+V pastes, Ctrl+Z undoes and Ctrl+S saves.
Database Concepts
A database stores related data in an organised way so that the same data need not be kept in many places. A DBMS is the software that creates the database and lets a user store, search, update and delete data, with examples such as MySQL, Oracle, SQL Server and MS Access. When the data is kept in tables that are linked by keys, the system is called a relational database management system. In a table each row is a record, each column is a field, and a primary key uniquely identifies every row, while a foreign key in one table points to the primary key of another and joins the two. Structured query language, SQL, is the standard language used to work with such tables, and its main statements are SELECT to read, INSERT to add, UPDATE to change and DELETE to remove data, along with CREATE and DROP to make or delete a table. Normalisation is the process of organising tables to reduce repetition and errors.
Number Systems and Conversions
A number system is named by its base, which is the number of different digits it uses. The decimal system uses ten digits from 0 to 9, the binary system uses two digits 0 and 1, the octal system uses eight digits from 0 to 7, and the hexadecimal system uses sixteen symbols, the digits 0 to 9 and the letters A to F for ten to fifteen. To convert a decimal number into binary, divide it by two again and again, write down each remainder and then read the remainders from the last to the first. To convert binary into decimal, multiply each bit by its place value, which doubles from right to left, and add the results. Octal and hexadecimal are useful because they are short forms of binary: three binary bits make one octal digit and four binary bits make one hexadecimal digit. The largest place value of a number is called the most significant digit and the smallest the least significant digit.
Data Units and Keyboard Shortcuts
The smallest unit of data is a bit, which is a single 0 or 1, and eight bits make one byte, which can store one character. The larger units rise in steps of 1024: 1024 bytes make one kilobyte, 1024 kilobytes one megabyte, 1024 megabytes one gigabyte, 1024 gigabytes one terabyte and 1024 terabytes one petabyte. A nibble is four bits, or half a byte. Keyboard shortcuts save time and are asked directly: Ctrl+C copies, Ctrl+X cuts, Ctrl+V pastes, Ctrl+Z undoes, Ctrl+Y redoes, Ctrl+A selects all, Ctrl+S saves, Ctrl+P prints, Ctrl+F finds, Ctrl+B makes text bold, Ctrl+I italics and Ctrl+U underline. Alt+F4 closes a window, Alt+Tab switches between open windows, and F5 refreshes a page or window.
Types of Questions Asked
The most common pattern asks for a conversion, such as the binary form of a decimal number. The second asks a definition, such as what a primary key is. The third asks a full form, such as DBMS, SQL or RDBMS. The fourth asks the number of bytes in a kilobyte or the bits in a byte. The fifth asks the shortcut for an action. Direct conversions and definitions take most of the marks.
Steps to Solve a DBMS or Number Question
First, read the question and see whether it asks for a database term, a conversion, a unit or a shortcut. Second, if it is a conversion, fix the bases involved and apply the divide or place-value rule. Third, if it is a definition, recall the exact one-line meaning and its key condition, such as unique for a primary key. Fourth, if it is a unit, remember the base of 1024 and the order of the units. Fifth, if it is a shortcut, picture the key and the action. Finally, check the result once, because a single wrong remainder or place value changes the whole answer.
Examination Trends
In Assam recruitment papers decimal-to-binary conversions, the table of data units, the definitions of primary key, foreign key and DBMS, the full forms of SQL and RDBMS and the common keyboard shortcuts appear most often, followed by octal and hexadecimal conversions and SQL statements. Questions are short and single fact based, so steady revision is enough. The same conversions and definitions repeat with small changes, which makes this section quick to secure.
Common Mistakes to Avoid
- Do not read the remainders in the wrong order; read the decimal-to-binary result from the last remainder to the first.
- Do not confuse a primary key with a foreign key; only the primary key is unique.
- Do not call a database and a DBMS the same; one is data and the other is software.
- Do not use 1000 for the data units; computer memory uses 1024.
- Do not forget that octal groups bits in threes and hexadecimal in fours.
- Do not mix up the shortcut keys, such as Ctrl+Z for undo and Ctrl+Y for redo.
How to Prepare This Topic
Make a three-column table of the number systems with their base and their digits, and practise ten conversions every day in each direction. Next write the data-unit ladder from bit to petabyte with the value 1024 at each step. Then write the database terms, such as table, record, field, primary key and foreign key, with a one-line meaning each. Finally, write the twenty most common keyboard shortcuts with their actions.
Attempt twenty questions a day and keep a register of the conversions, definitions and shortcuts you got wrong, because the same items recur. Practise decimal-to-binary conversions aloud, reading the remainders in the correct order, since the order is the most common trap. In the last week revise only the tables and the register, and the section will be ready.
Quick Revision Tips
- Decimal base 10, binary base 2, octal base 8, hexadecimal base 16.
- Decimal to binary: divide by two and read the remainders upwards.
- 8 bits = 1 byte, 1024 bytes = 1 KB, 1024 KB = 1 MB.
- A primary key is unique; a foreign key links tables.
- Ctrl+Z undo, Ctrl+Y redo, Ctrl+S save, Ctrl+C copy.
Final Revision Note
On the last day, revise the number-system table, the data-unit ladder, the database terms and the shortcut list, then attempt a timed set of twenty questions. For every wrong answer, write the exact item that was missed. These questions reward clear rules, and a candidate who has them answers fast and gains easy marks.
Frequently Asked Questions
What is a primary key?
A primary key is a field that uniquely identifies each record of a table and cannot be empty.
What is the binary form of the decimal number 10?
The decimal number 10 is written as 1010 in binary.
How many bytes are there in one kilobyte?
There are 1024 bytes in one kilobyte, because computer memory rises in steps of 1024.
What does SQL stand for and what is it used for?
SQL stands for structured query language, and it is used to create, read, update and delete data in a database.
Which keys are used to undo and redo an action?
Ctrl+Z is used to undo an action and Ctrl+Y is used to redo it.