From the course: Learning Relational Databases

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Draft the initial data model

Draft the initial data model

From the course: Learning Relational Databases

Start my 1-month free trial

Draft the initial data model

“

- [Instructor] At this point, you should have a good foundation in understanding how to start taking the field list of items that you've discovered through the requirements gathering phase and be able to begin grouping them into the tables that we'll need for the relational database management system. This will serve as the first draft of your data model. You've seen some techniques for exploring the table relationships to each other and how to bring in additional tables that will make the database run smoothly. So go ahead and start organizing your tables into a data model and begin to think about the relationships between the various entities that'll make up your final database. But don't get too hung up about making it perfect at this stage. The important part is to start getting the design down on paper so that you can take a step back and see the bigger picture. We'll continue to refine the layout of the relationships in the next chapter as we run through a process called…

Contents