From the course: Designing Highly Scalable and Highly Available SQL Databases
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Identify schemas
From the course: Designing Highly Scalable and Highly Available SQL Databases
Identify schemas
- [Instructor] The idea of a schema is a fundamental concept in database design. And basically a schema is a logical extraction. It's a collection of related database objects. Now in relational databases, when we talk about schemas, we are talking about a lot of different kinds of objects that are used to implement the physical database. So they include things like tables, indexes, sequences, triggers, constraints, and other objects that we create within a relational database. Now, the grouping factor is that all of these entities are from a single business domain. So the next question obviously is, well, what constitutes a domain? Well, first of all, as I mentioned, we're talking about a set of entities. So these are descriptive things. These are the nouns within the business process that we talk about. So things like customers and products and inventory levels. And entities have logical relationships. So customers have…
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.