Designing a New Database with ER/Studio Data Architect

Data Architecture vs. Database Design

And this set of videos, we're going to show how idea data architecture can be used to design a new database. So we've got three videos in the first video, we're going to show how we can take a set of business requirements and create a logical data model. So the objective here is to take those high-level ideas for a data assets create a conceptual model from it, refine that conceptual model into a logical model, moving towards third normal form. And then from that, we're going to then create a physical data model from it. So allow us to create and deploy a design for our database. Once we forward engineered for the first pass, the database, then new requirements will crop up. So we need to be able to manage change.

So in the third set of videos, we're going to show you how we can take ideas, requests for change. We'll then take them through a process. And then we deploy those changes to the database.