Computer Science · Class 12 · Computer Networks and Connectivity · Term 1

Relational Model: Tables, Rows, Columns, Domains

Students will understand the fundamental components of the relational model: tables, rows (records), columns (fields), and domains.

• CBSE Learning Outcomes
• CBSE: Database Management - Relational Data Model - Class 12

About This Topic

The relational model forms the foundation of modern databases, using tables to represent data. Each table organises data into rows and columns, where rows are records representing entities like students, and columns are fields holding attributes such as name or roll number. Domains define the data type and range for each column, ensuring consistency, like integers for ages or strings for names.

This structure allows clear representation: a student table might have columns for ID, name, class, with each row as a unique record. Understanding records versus fields is crucial; a record is a complete set of field values for one entity. Students can construct schemas, specifying domains like VARCHAR for names or INT for marks.

Active learning benefits this topic as students actively build tables for real entities, clarifying components and fostering skills in schema design essential for advanced database work.

(Word count: 168)

Key Questions

1. Explain how tables, rows, and columns represent data in a relational database.
2. Differentiate between a record and a field in a database table.
3. Construct a simple table schema for a given real-world entity, including data types/domains.

Learning Objectives

• Design a simple database table schema for a given real-world entity, specifying column names and appropriate data types (domains).
• Compare and contrast the concepts of a record (row) and a field (column) within a relational database table.
• Explain the role of domains in ensuring data integrity and consistency for specific attributes within a table.
• Analyze a given dataset and classify its components into tables, rows, and columns based on the relational model.

Before You Start

Introduction to Data

Why: Students need a basic understanding of what data is and how it can be organised before learning about structured database models.

Basic Computer Literacy

Why: Familiarity with using computers and understanding concepts like files and folders helps in grasping the organisation of data in a database.

Key Vocabulary

Table	A collection of related data entries organised in rows and columns. It represents a specific entity or concept, like 'Students' or 'Courses'.
Row (Record)	A single entry or data item within a table, representing a complete set of information for one instance of the entity. For example, one student's details in a 'Students' table.
Column (Field)	A vertical category within a table that represents a specific attribute or characteristic of the entity. For example, 'Name' or 'Roll Number' in a 'Students' table.
Domain	The set of permissible values or data types that a column can hold. It ensures data consistency, such as 'Integer' for age or 'String' for names.

Watch Out for These Misconceptions

Common Misconception

Rows and columns are interchangeable.

What to Teach Instead

Rows represent complete records (entities); columns define attributes (fields) with specific domains.

Common Misconception

Domains are optional in tables.

What to Teach Instead

Domains specify data types and constraints, ensuring data validity and consistency.

Active Learning Ideas

Table Component Mapping

Provide a real-world entity like 'books'. Students map to table, rows, columns, domains. Share mappings.

15 min·Pairs

Schema Construction Challenge

Design table for 'employees' with columns, data types. Include sample rows. Groups justify choices.

25 min·Small Groups

Record vs Field Debate

List examples; students differentiate records and fields. Discuss domain importance.

20 min·Whole Class

Real-World Connections

• A library's catalog system uses tables to store information about books (title, author, ISBN) and members (name, member ID, contact). Each book or member is a record, and details like 'title' or 'member ID' are fields.
• E-commerce websites like Flipkart or Amazon use relational tables to manage product inventory, customer orders, and user accounts. A 'Products' table would list items with fields such as 'product ID', 'name', 'price', and 'stock quantity'.

Assessment Ideas

Exit Ticket

Provide students with a small table representing employee data (e.g., Employee ID, Name, Department, Salary). Ask them to identify: 1. How many records are present? 2. Name two fields. 3. What is a possible domain for the 'Salary' field?

Quick Check

Present students with a real-world scenario, such as managing student attendance for a school event. Ask them to verbally list the components: What would be the table name? What are 3-4 columns (fields) needed? What would one row (record) represent?

Discussion Prompt

Initiate a class discussion: 'Imagine you are designing a database for a local cricket team. What kind of information would you store? How would you organise this information into tables, rows, and columns? What are some important rules (domains) you would set for each piece of information?'

Frequently Asked Questions

How do tables represent data in relational model?

Tables use rows for records and columns for fields. Each cell holds a value within the column's domain. This grid structure models real-world entities systematically, enabling efficient storage and retrieval as per CBSE standards.

Differentiate record and field.

A record is a row containing all field values for one entity, like a student's full details. A field is a column attribute, such as 'marks'. Understanding this aids in accurate table design.

Why use active learning here?

Active learning through schema building tasks helps students visualise abstract components like rows and domains. It addresses key questions by practising construction, reduces confusion between terms, and prepares for SQL implementation effectively.

Example of constructing a table schema?

For 'students': columns ID (INT, primary), Name (VARCHAR(50)), Age (INT), Class (VARCHAR(10)). Domains ensure proper data entry, preventing errors like text in age field.