What is Database Modeling and Design?

Database Modeling and Design involves designing data models using Entity Relationship Diagrams (ERDs) and Data Dictionaries, and building the database the models represent. The data model is part of the conceptual design process. The data model focuses on what data should be stored in the database. The data model is used to design the relational tables. Data modeling is preceeded by planning and analysis. As information is collected, data objects are identified and classified, assigned names, and defined using terms familiar to the end-users. The objects are then modeled and analyzed using an ER diagram.

An effective data model completely and accurately represents the data requirements of the end users. It is simple enough to be understood by the end user yet detailed enough to be used by a database designer to build the database. The model eliminates redundant data, it is independent of any hardware and software constraints, and can be adapted to changing requirements with a minimum of effort. If you are new to databases, you should definitely study Data Modeling and Design before you deal with vendor-specific database software. A database created without knowledge of foundational concepts is like a house built with no blueprints. It is almost impossible to maintain or extend.

  Database Modeling and Design Training Courses

The following Database Modeling and Design training courses are available from Blue Star Learning...

DMD - Database Modeling and Design