8.5 Relational Database Model
This lesson introduces the fundamentals of the Relational Database Model (RDBMS) in Sri Lankan Advanced Level ICT. It covers structural elements such as relations, attributes, and tuples, alongside essential relational constraints like primary keys, foreign keys, and unique constraints to ensure data integrity.
ප්රධාන සංකල්ප
- Relation / Table (සම්බන්ධක / වගු)
- A two-dimensional grid structure consisting of rows and columns used to store data about a specific entity.
- Attribute (උපලක්ෂණ / උපලැකි)
- A named column of a relation representing a specific characteristic or property of an entity.
- Tuple / Row (උපලැකියන / පේළි)
- A single row in a relation representing a collection of related data values for a specific instance of an entity.
- Relationship (සම්බන්ධතා)
- An association established between different relations in a database to link relevant data elements.
- NOT NULL Constraint (අභිශූන්ය නොවන සම්බන්ධක)
- A rule ensuring that a specific attribute (column) in a table cannot be left empty or contain null values.
- Unique Constraint (අනන්ය සම්බන්ධක)
- A constraint ensuring that all values in a column or a set of columns are unique and distinct across all tuples in a relation.
- Primary Key Constraint (ප්රාථමික යතුරු සම්බන්ධක)
- An attribute or a combination of attributes that uniquely identifies each tuple in a relation, automatically enforcing uniqueness and NOT NULL rules.
- Foreign Key Constraint (ආගන්තුක යතුරු සම්බන්ධක)
- An attribute in one table that references the primary key in another table, establishing and enforcing link integrity between tables.
- Table Check Constraint (වගු පරීක්ෂා සම්බන්ධක)
- A rule used to limit the value range that can be entered into a specific column or columns based on a logical condition.
MCQ කට්ටල
MCQ 8විභාගයේදී
- Identifying relational schema components such as attributes, tuples, and relations in written questions.
- Selecting appropriate integrity constraints (Primary, Foreign, Unique, Check) for given database scenarios in MCQ questions.
- Explaining database integrity rules and identifying structural errors in faulty database tables.
