අන්තර්ගතයට යන්න
mcqdinethlive

Unit 8, Database Management

8.1 Introduction to Databases

This lesson introduces the foundational concepts of data and information, highlighting the transition from unstructured to structured data. It defines databases and explores various database models, including flat file, hierarchical, network, relational, and object-relational models, emphasizing their characteristics and advantages.

ප්‍රධාන සංකල්ප

Data (දත්ත)
Raw, unorganized facts and figures that lack context and require processing to become meaningful.
Information (තොරතුරු)
Processed, structured, and organized data that is meaningful, useful, and presented within a specific context.
Flat File System (ඒක ගොනු පද්ධතිය)
A database model where data is stored in a single, two-dimensional plain text file or table without relational links between files.
Hierarchical Model (ධූරාවලි ආකෘතිය)
A database model where data is organized in a tree-like structure with parent-child relationships, where each child record has only one parent.
Network Model (ජාල ආකෘතිය)
An advancement of the hierarchical model where child records can have multiple parent records, representing many-to-many relationships.
Relational Model (සම්බන්ධක ආකෘතිය)
A database model that organizes data into one or more tables (relations) of columns and rows, with a unique key identifying each row.
Object-Relational Model (වස්තු-සම්බන්ධක ආකෘතිය)
A database model that combines the elements of a relational database with the features of object-oriented programming, supporting objects, classes, and inheritance.

MCQ කට්ටල

MCQ 8

විභාගයේදී

  • Distinguishing between data and information with practical examples
  • Comparing different database models based on their structural characteristics
  • Identifying advantages and disadvantages of flat files vs. relational databases in structured questions