[工学]Oracle建模教材DataModelingLes07_map.pptVIP

Mapping the Entity Model Overview Why use design modeling? Introduction to the components: Tables Columns Constraints Basic Mapping Complex mapping Why Create a Data Design Model? Closer to the implementation solution Facilitates discussion Ideal model can be adapted to an RDBMS model Sound basis for physical database design Presenting Tables Transformation Process Terminology Mapping General Naming Topics Decide on a convention for: Table names Special characters (%, *, #, -, space, …) Table short names Column names Primary and Unique Key Constraint names Foreign Key Constraint names Foreign