Join Simon Allardice for an in-depth discussion in this video Creating relationships, part of Programming Foundations: Databases.
- I talked about Relationships in the earlier section…on Features of a Relational Database,…but it's time to get more specific.…You're organizing your database into individual tables,…and many of these tables will need to know…about each other.…If you've started by sketching out a rough…Entity Relationship Diagram, you begin by just attempting…to show that some kind of relationship exists…between your entities.…But to get closer to actually building this in a database,…we need to say what these relationships are.…
And while it is common in an ER Diagram to use a phrase…or a verb to describe it, like "contains" or "refers to"…or "belongs to," that's for your benefit.…The database can't describe it that way.…There are only three kinds of Relationship, of Cardinality,…between tables in a relational database,…and one of them dwarfs the others.…There's One-to-One, One-to-Many, and Many-to-Many.…Some people might add a fourth, of None at All.…
But the time to start defining these is yet another example…of how you can keep to a process, an Order,…
Author
Released
9/30/2015- What is a database?
- Why do you need a database?
- Choosing primary keys
- Identifying columns and selecting data types
- Defining relationships: one-to-one, one-to-many, and many-to-many
- Understanding normalization
- Creating queries to create, insert, update, and delete data
- Understanding indexing and stored procedures
- Exploring your database options
Skill Level Appropriate for all
Duration
Views
Related Courses
-
Programming Foundations: Design Patterns
with Elisabeth Robson2h 19m Intermediate
-
Introduction
-
Welcome1m 2s
-
What you need to know1m 14s
-
-
1. Understanding Databases
-
What are databases?7m 41s
-
-
2. Database Fundamentals
-
Defining table relationships5m 33s
-
3. Database Modeling: Tables
-
Planning your database5m 45s
-
Choosing primary keys1m 45s
-
Using composite keys2m 4s
-
4. Database Modeling: Relationships
-
Creating relationships2m 38s
-
-
5. Database Modeling: Optimization
-
First normal form4m 5s
-
Second normal form4m 29s
-
Third normal form4m 34s
-
6. Database Modeling: Querying
-
Creating SQL queries5m 34s
-
Structuring the WHERE clause6m 24s
-
Sorting query results2m 37s
-
Using aggregate functions4m 49s
-
Joining tables6m 54s
-
The data definition language4m 50s
-
-
7. Database Modeling: Indexing and Optimization
-
Understanding indexes9m 24s
-
-
8. Database Options
-
Desktop databases5m 13s
-
NoSQL databases8m 59s
-
-
Conclusion
-
Final thoughts50s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Creating relationships