Home | | Computer Science 12th Std | Database Structure

Computer Science - Database Structure | 12th Computer Science : Chapter 11 : Database concepts and MySql : Database Concepts

Chapter: 12th Computer Science : Chapter 11 : Database concepts and MySql : Database Concepts

Database Structure

Table is the entire collection of related data in one table, referred to as a File or Table where the data is organized as row and column.

Database Structure

Table is the entire collection of related data in one table, referred to as a File or Table where the data is organized as row and column.

Each row in a table represents a record, which is a set of data for each database entry.

Each table column represents a Field, which groups each piece or item of data among the records into specific categories or types of data. Eg. StuNo., StuName, StuAge, StuClass, StuSec.

A Table is known as a RELATION

A Row is known as a TUPLE

A column is known as an ATTRIBUTE




 

Tags : Computer Science , 12th Computer Science : Chapter 11 : Database concepts and MySql : Database Concepts
Study Material, Lecturing Notes, Assignment, Reference, Wiki description explanation, brief detail
12th Computer Science : Chapter 11 : Database concepts and MySql : Database Concepts : Database Structure | Computer Science


Privacy Policy, Terms and Conditions, DMCA Policy and Compliant

Copyright © 2018-2023 BrainKart.com; All Rights Reserved. Developed by Therithal info, Chennai.