From the course: Practical Database Design: Implementing Responsible Data Solutions with SQL Querying
Join today to access over 24,700 courses taught by industry experts.
Identifying data integrity requirements - SQL Tutorial
From the course: Practical Database Design: Implementing Responsible Data Solutions with SQL Querying
Identifying data integrity requirements
- [Lecturer] Our conceptual database model gives us a great overview of how business rules show up in the data model and how they're connected to each other. What we've created so far is a great visual, but it's not ready to be implemented within a database management system or DBMS. One more element is missing, the attributes for each entity. Attributes are classified in two ways. Number one, attributes that describe the characteristics of that entity. And number two, attributes that describe the relationship between two entities. Every entity must have at least one attribute called the primary key to uniquely identify an instance of that entity. There are typically other attributes that are related to that attribute too. Each Brainiac has a first name, last name, email, password, and last login, and is uniquely identified by their username. No two usernames can be the same, so username is the primary key. The friend, follower, post, and direct message entities need attributes that…
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.