At the end of the discussion of each relation I list the SQL create statements needed to create the tables necessary to represent the relation. The statement looks something like the following:
create table A ( a_id type, a_name type, <a_other> primary key (a_id));
The interpretation of this is
- The table is called A
- There are two columns, a_id and a_name, of indeterminate type
- There are zero or more columns (<a_other>) about the A entity
- The primary key is a_id
Return to the ER to SQL page.