From the course: Database Design Fundamentals
Join today to access over 25,500 courses taught by industry experts.
Relational database design basics
From the course: Database Design Fundamentals
Relational database design basics
- [Instructor] The key differences between logical and physical database models is that logical data models define the data elements in their relationships. Focusing on the business requirements, and how the data should be structured. They provide an abstract, high level view of the data without regard for how they will be physically implemented. Logical data models use entity relationship diagrams to represent entities, attributes, and relationships to show the data is related. In contrast, physical data models define the actual implementation details of the database, such as the specific tables, columns, data types, and storage structures. Physical data models are often tailored to the specific database management system or management system type, and focusing on optimizing performance and storage for that system. The logical model or entity relationship diagram is done first by the business analysts and data…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.