From the course: Practical Database Design: Implementing Responsible Data Solutions with SQL Querying
Join today to access over 25,300 courses taught by industry experts.
Scoping the database requirements - SQL Tutorial
From the course: Practical Database Design: Implementing Responsible Data Solutions with SQL Querying
Scoping the database requirements
- [Narrator] Our recap of the entity relationship model tapped into the foundational mechanics of good database design. However, before we proceed with the digital workings of database design, let's take a minute to emphasize the less discussed analog and more tactical aspects. Many in leadership may not have database experience. Often, they hope that the database can serve as the main landing area for the vast majority of the digital parts of their business, but as a data analyst or data engineer, you know that this is far from reality. We need specificity and details to make the data model make sense for the long haul. Identifying entities and relationships tend to be easy, in most cases, after having regular and focused conversations. The relationship cardinalities, on the other hand, are a different story. Your client may not know how they want their business to operate, so they're more fuzzy on those details, but…
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.