8.3 Logical Schema & ER Conversion
This lesson details how to design a logical schema and successfully convert Entity-Relationship (ER) and Enhanced Entity-Relationship (EER) diagrams into relational schemas. Students learn about different database keys, relational instances, domains, and the step-by-step transformation of entities, attributes, and relationships into tabular formats.
ප්රධාන සංකල්ප
- Logical Schema
- A representation of a database structure that maps conceptual entities, relationships, and attributes into logical tables and keys.
- Relational Schema
- The structural design of a relation (table) which specifies its name, attributes, and their associated data types and constraints.
- Relational Instance
- The actual collection of data values stored in a relation at any given moment in time.
- Candidate Key
- A minimal set of attributes that can uniquely identify any tuple in a relation.
- Primary Key
- The specific candidate key chosen by the database designer to uniquely identify each tuple within a relation.
- Alternate Key
- Any candidate key that was not selected to be the primary key of the relation.
- Foreign Key
- An attribute or set of attributes in a relation that matches the primary key of another relation, used to establish and enforce links between data.
- Domain
- The set of all permissible, valid values (defined by type, length, and range) that can be assigned to an attribute.
- ER to Relational Mapping
- The formal process of converting entities, attributes, and relationship types (such as one-to-one, one-to-many, and many-to-many) from an ER diagram into a set of relational tables.
MCQ කට්ටල
MCQ 24විභාගයේදී
- Identifying candidate keys, primary keys, alternate keys, and foreign keys within a given relational schema.
- Mapping an ER or EER diagram into a set of normalized relational tables.
- Specifying domains and appropriate data constraints for relational attributes in written answers.
- Structured questions requiring students to draft relational schemas with underlined primary keys and dashed-underlined foreign keys.
