How to translate ER Model to Relational Model.ppt

How to translate ER Model to Relational Model By: Jung T. Chang CS 157A T/Th Morning Section Review - Concepts Relational Model is made up of tables A row of table = a relational instance/tuple A column of table = an attribute A table = a schema/relation Cardinality = number of rows Degree = number of columns Review - Example From ER Model to Relational Model So… how do we convert an ER diagram into a table?? Simple!! Basic Ideas: Build a table for each entity set Build a table for each relationship set if necessary (more on this later) Make a column in the table for each attribute in the entity set Indivisibility Rule and Ordering Rule Primary Key Example – Strong Entity Set Representation of Weak Entity Set Weak Entity Set Cannot exists alone To build a table/schema for weak entity set Construct a table with one column for each attribute in the weak entity set Remember to include discriminator Augment one extra column on the right side of the table, put in there the primary key of the Strong Entity Set (the entity set that the weak entity set is depending on) Primary Key of the weak entity set = Discriminator + foreign key Example – Weak Entity Set Representation of Relationship Set --This is a little more complicated-- Unary/Binary Relationship set Depends on the cardinality and participation of the relationship Two possible approaches N-ary (multiple) Relationship set Primary Key Issue Identifying Relationship No relational model representation necessary Representing Relationship SetUnary/Binary Relationship For one-to-one relationship w/out total participation Build a table with two columns, one column for each participating entity set’s primary key. Add successive columns, one for each descriptive attributes of the relationship set (if any). For one-to-one relationship with one entity set having total participation Augment one extra column on the right side of the table of the entity set with tota