MS Access and Database

   ✅ A set of possible data values for a specific field or characteristic is called an Attribute. 

   ✅  In a database, a tuple represents a single row or record in a table.

   Explanation:

• A table consists of rows (tuples) and columns (attributes).
• Each tuple contains data values for all attributes of a single entity.

   ✅  Degree is the total number of attributes (columns) in a database table  

   ✅   Cardinality → Total number of tuples (rows) in a relation. 

 The smallest meaningful unit of data in a database is called a Field. 

    ✅  A Byte is the smallest addressable unit of data in computer memory that can represent a single character (like a letter, number,               or  symbol).

   Explanation:

• 1 Byte = 8 Bits
• Each bit is either 0 or 1.
• A byte is used to store one character such as ‘A’, ‘3’, or ‘$’.

        ✅ A Field is a single piece of data or attribute about a person, place, or thing in a database table.

    Explanation:

• A field represents one type of information within a record.
• It is the intersection of a row (record) and a column (attribute).
• A collection of fields forms a record, and a collection of records forms a table.

        ✅ A Record is a collection of related data fields that represent a single entity in a database.

   Explanation:

• Each record contains data about one specific item or person.
• A record is also called a row or tuple in a database table.
• Fields make up a record.

             ✅ A Character is the smallest unit of data that can be read, written, or stored, such as a letter, digit, or symbol.

     Explanation:

• A Character can be any alphabet (A–Z, a–z), number (0–9), or special symbol (!, @, #, etc.).
• Characters are stored in memory using binary codes.
• In computers, each character is represented by one byte (8 bits) in most encoding systems like ASCII.

     Examples of Characters:
            A, b, 7, $, @, ?, #