Conceptual Database Overview

-

Conceptual Database Overview: -

  • A database is an organised collection of structured data stored securely and permanently.
  • It allows the user to create, insert, update, and delete the data.
  • In a relational database, tables, fields, and records are the fundamental building blocks used to organise and store information.
  • A database acts as a digital filing cabinet, where tables are the individual folders, records are the documents inside those folders, and fields are the specific pieces of information on each document.

 

1) Table: -

  • A table is a collection of related data that is organized in a structured format of rows and columns.
  • Each table represents a single entity type (e.g., Student, Employee, Customers, Products, Orders).
  • Each table has a unique name and is defined by the fields in it.
  • This separation helps maintain data integrity and makes it easier to manage and query information.
  • For example, a database for a school might have separate tables for Students, Courses, and Teachers.

 

 

2) Fields: -

  • Fields are also known as columns or attributes.
  • Fields represent a single attribute or characteristic of the entity.
  • Each field represents a specific type of information about the entity.
  • For Example, the Students table contains fields that might include StudentID, Name, group, and totalMarks.
  • Each field has a unique name in table and it is assigned a specific data type, such as text, numbers, or dates, which tells the kind of data it can hold.

 

3) Records: -

  • A record is also referred to as a 'row' or 'tuple'.
  • A record is a single entry within a table. It contains a complete set of values for each of the fields in the table.
  • Using the Students table example, a single record would represent one student. This record would include a value for StudentID, a value for Name, a value for Marks, and so on, for that specific student.
  • Example: In the Students table → (101, "Rohit", 35, "BCOM CA") is a record.

  

Popular posts from this blog

operators in c programming

-
Image
v Operators: - An operator is a symbol that tells or intimates to the compiler to perform specific calculations or manipulations on one or more operands. Operators are essential for performing computations and making decisions in programs.   a + b is an operation a & b are operands + is an operator   Based on number of operands involved: 1.      Unary operators: - unary operators can be applied on only one operator. Example: -   ++ , -- , - (unary minus) , sizeof , ~ (compliment) , ! (not).   2.      Binary operators: - binary operators can be applied on two operands. Example: -   + , -,   * , / , etc.   3.    Ternary operators: - Ternary operator can be applied on three operands. Example: -   ?: (ternary conditional operator).   C supports several operators, can be classified into following...
Read more

Variables in c

-
Image
  Variables: - A variable is a data name or an identifier which stores a value that can be changed during the program execution.  Every variable might belong to any of the data types, like int, float, char, etc.  The name of a variable can be composed of letters, digits, and the underscore character. It must begin with either a letter or an underscore.  Variables are case-sensitive because uppercase and lowercase letters are distinct. C programming language also allows defining various other types of variables, like numeric array, character array, pointer, Structure, Union, Enumeration and etc.               Example: - sum, height, _value Declaring a variable in C: - Variable declaration means telling the compiler about the name and type of a variable before using it in the program. Variable declaration is the process of reserving a memory location and defining the type of data that will be stored in that locatio...
Read more

Cloud Storage and Local Storage: Applications in Business

-
  Cloud Storage and  Local Storage: Applications in Business: -   Local Storage: - Local storage refers to storing data such as text, audio, video, graphics, animation, special characters, constants, mathematical expressions and numeric data on physical devices in our computer or other electronic devices. Local storage in business refers to storing business data such as customer contact information, sales records, financial statements, employee data, market research, operational metrics, raw information like customer feedback.  It can also stores the structured data, such as in spreadsheets, or unstructured, like text from surveys or social media post on physical devices like hard drives, SSDs, or company servers within the organization’s premises.  The business owns and manages the storage hardware.  Local storage provides faster access to large files, which is helpful for tasks like video editing, 3D rendering, and engineering design projects. It o...
Read more