Database Management System and SQL
Database Management System and SQL
  • Database Management System and SQL
  • Database
    • Introduction to Database
      • Definition
      • File System
      • Different types of Database
      • Uses of DBMS
      • Basic Terms in Database
      • Query Language
    • View of Data
      • Data Abstraction
      • Schema & Instance
      • Data Models
    • Database Architecture
      • DBMS Tier Architecture
      • Three Schema Architecture
      • Data Independence
    • Relational Database Management System (RDBMS)
      • Entity-Relationship (ER) Model
      • Attributes
      • Keys
      • Relationship
    • Functional Dependencies
    • Normalization
  • MySQL
    • Terminology
    • Database Statements
    • Table
      • Data Type
      • Create
      • Show
      • Describe
      • Drop
      • Alter
      • Auto Increment
      • Index
    • Insert
    • Select
      • Condition
      • Aggregate Functions
      • Join
    • View
    • Delete
    • Update
    • MySQL Constraints
      • NOT NULL
      • DEFAULT
      • CHECK
      • UNIQUE
      • PRIMARY KEY
      • FOREIGN KEY
Powered by GitBook
On this page
  • Types of Attributes
  • Simple Attribute
  • Composite Attribute
  • Stored Attribute
  • Derived Attribute
  • Single-valued Attribute
  • Multi-valued Attribute
  • Key Attribute

Was this helpful?

  1. Database
  2. Relational Database Management System (RDBMS)

Attributes

Attributes are the data for a particular Entity.

Types of Attributes

  • Simple Attribute

  • Composite Attribute

  • Stored Attribute

  • Derived Attribute

  • Single-valued Attribute

  • Multi-valued Attribute

  • Key Attribute

  • Attribute Domain

Simple Attribute

  • Simple attributes are atomic and cannot be broken down further pieces.

Composite Attribute

  • A composite attribute is made up of more than one simple attribute.

Stored Attribute

  • Attribute directly stored in the database.

Derived Attribute

  • Derived attribute is not directly present in the database, it is derived using other attributes.

Single-valued Attribute

  • Single valued attribute has only one possible value in the database for an Entity.

Multi-valued Attribute

  • Multi valued attribute has two or more possible value in the database for an Entity.

Key Attribute

  • The key attribute is used to represent the main characteristics of an entity. It represents a primary key.

PreviousEntity-Relationship (ER) ModelNextKeys

Last updated 1 year ago

Was this helpful?