Creating an Entity Relationship Diagram (ERD) and associated data dictionary to represent the
Transforming ERD to relational model: tables, keys (constraints), etc.
Creating the database and other supporting structures based on a specific DBMS
DesignA physical database model adds more implementation level details to the design
It is specific to a DBMS productWhat to design?
Designing basic database logical model objects (DBMS specific)
Databases, tables, fields, views
Constraints: primary key, foreign key, uniqueness, referential integrity, default, range
Designing additional physical level objects
Files: storage files, partitions, etc.
Performance: indexes, views, etc.
Functional: triggers, scripts (stored procedures), functions, transactions, etc.
Security: users, roles, permissions, etc.