EXERCISE 6.1: Creating Attributes in ER/Studio
In the previous chapter we assigned entities to submodels, as shown in Table 6.1.
Table 6.1 Assignment of Entities to Submodels
|
Assign to this submodel… |
These entities |
|
Offerings |
Offering Title Electronic Title Print Title Category Conference Seminar Speaker |
|
Conferences |
Conference Speaker |
|
Seminars |
Seminar Speaker |
For this exercise, add the following attributes to each of these entities:
|
Create in this entity… |
These attributes |
|
Offering |
Offering ID Offering Name Offering Price Amount |
|
Title |
ISBN Subtitle Name |
|
Electronic Title |
Title Instant Download Indicator |
|
Print Title |
Title Page Count |
|
Category |
Category Code Category Name |
|
Conference |
Conference Hotel Name Conference Start Date Conference End Date |
|
Seminar |
Seminar Start Date Seminar End Date |
|
Speaker |
Speaker Tax ID Speaker First Name Speaker Last Name |