Q.(A) Ms. Veda created a table named Sports in a MySQL database, containing columns Game_id, P_Age and G_name. After creating the table, she realized that the attribute, Category has to be added. Help her to write a command to add the Category column. Thereafter, write the command to insert the following record in the table: Game_id: G42 P_Age: Above 18 G_name: Chess Category: Senior

Table Creation: The Art of Organising Information

Think of the last time you tried to find a specific contact in your phone. If all your contacts were just listed in one long, unbroken list — no groups, no alphabetical order, no search — you would have to scroll through every single name to find the one you need. That is the problem that table creation solves.

In everyday life, we create tables all the time without thinking about it. A timetable for your classes, a cricket scorecard, a menu with prices — each of these is a table. The instinct to arrange information into rows and columns is natural because it makes comparison and retrieval fast. Table creation, in the context of your studies, is simply the deliberate, systematic act of doing this with data so that it becomes meaningful and usable.

What Exactly Is a Table?

A table is a structured arrangement of data in rows and columns. Each row typically represents one complete record or observation — for example, one student, one month, one product. Each column represents a particular characteristic or variable of that record — for example, name, marks, price, date.

The power of a table lies in its ability to show relationships at a glance. When data is scattered in a paragraph, you have to read and mentally compare. When it is in a table, your eye can move vertically down a column or horizontally across a row, spotting patterns, extremes, and gaps instantly.

The Core Elements of a Table

Every proper table has a few essential parts. Understanding these will help you both read tables and create your own.

• Title: A clear, concise heading that tells the reader what the table contains. It should answer the questions: what, where, and when. For example, "Monthly Sales of ABC Ltd., April–September 2023" is far better than just "Sales Data."
• Column Headings (Captions): These label each column and describe the type of data it holds. They must be precise — "Revenue (in ₹ lakh)" is clearer than just "Revenue."
• Row Headings (Stubs): These label each row, usually on the leftmost column. They identify what each row represents — for instance, the names of months, products, or regions.
• Body of the Table: The actual data cells where numbers or text entries sit. This is the heart of the table.
• Source Note: A line below the table stating where the data came from. This is crucial for credibility, especially in exam answers and project work.
• Footnotes (if needed): Any clarification about a specific entry — for example, an asterisk explaining that a figure is an estimate.

Why Table Creation Matters for You

In your exams and assignments, you will often be asked to present raw data in tabular form. This is not busywork. The examiner wants to see that you can:

1. Identify the key variables in a given set of information.
2. Classify and group data logically.
3. Present it without ambiguity so that anyone reading can understand it immediately.

A well-created table can turn a confusing jumble of numbers into a clear story. For instance, if you are given the population figures of five states over three census years, a table lets you see at once which state grew fastest, which declined, and how each compares to the others. Without the table, you would have to hold all those numbers in your head. …

The Show Database Statement: A First Look

Imagine you walk into a large library. Before you can pick a book, you need to know what shelves exist, what sections are available, and what the library even holds. You wouldn't start searching for a specific title without first knowing the layout. That is exactly what the Show Database statement does — it gives you the layout of the library before you begin any real work.

In the world of databases, a database is like that entire library. It is a structured collection of data, organised into tables (like shelves), each holding related information. But when you first connect to a database server — say, MySQL or PostgreSQL — you are not automatically inside any one database. You are standing at the entrance, and you need to ask: "What databases are available here?" The Show Database statement is that question.

The Precise Meaning

The Show Database statement is a command used in database management systems (DBMS) to list all the databases that exist on the server you are connected to. It does not create, modify, or delete anything. It simply displays the names of every database the server currently holds, much like a directory listing shows you all the folders in a drive.

Why It Matters

You might wonder: why do I need to see a list of databases? Can't I just start working? Here is why this statement is essential, especially for someone managing data.

First, orientation. When you log into a server, you may have access to multiple databases — one for sales, one for inventory, one for customer records. Without the Show Database command, you would be guessing which one to use. It gives you a clear map.

Second, permission awareness. Not every user sees every database. A junior employee might only see two databases, while a database administrator sees ten. The Show Database statement reveals what you are allowed to access. If a database you expect to see is missing, it may mean your permissions are limited — or that the database does not exist at all.

Third, verification. After creating a new database, you run the Show Database command to confirm it was actually created. It is a quick sanity check, like checking that a new folder appears in your file explorer after you create it.

How It Works in Practice …