CSC-110 Fundamentals of Database: What is a Database?

Database Concepts

• Complete set of information in a database: Term used is "database."
• Field in a database: Represents a single piece of information within a record, often corresponds to a column in a table.
• Simple type of database: Known as a "flat file database," organizes data in columns and rows.
• Contacts in a mobile phone: Typically stored in a "contact list" or "address book" within a database or app.
• Structure for stored data in a database: Referred to as a "schema," which defines how data is organized.
• Collection of fields in a database: Known as a "record," which represents a single entry in a database.
• Group of records in a relational database model: Term used is "table," where records are organized into rows.
• Raw data representation in databases: Represented as "data types," including numeric, character, alphanumeric, or alphabetic form.
• Unique identifier for a row in a table: Called a "primary key," ensuring each record is uniquely identifiable.
• Information holder of an item in relational databases: Typically referred to as an "entity," representing real-world objects or concepts.
• Unique identifiers for a row: Can be a "primary key" or "composite key" when multiple fields work together to provide uniqueness.
• Group of related fields in relational databases: Known as a "record," where multiple fields are connected and formatted together.
• Records in relational database model: Organized into "tables," comprising rows (records) and columns (fields).