Modeling and relationships - Oracle PL SQL Course - Lesson 11 | SQL courses

Duration: 16:47 min

Summary: The modeling of entities, attributes and relationships is a very important task that everyone that work with databases must know how to perform. This video explain the basics of conceptual, logical and physical database modeling based on the sample HR database schema provided by Oracle. The process begin by the gathering of requirements phase that include data needs analysis, interviews and observation of existing system. Then, the next step is the conceptual modeling where the entities that should be on the final model are defined. The logical and the physical database modeling phases are also discussed on the video that focus on the practical aspects of the model creation.