The data model serves as a guide for creating the relationships between primary and foreign keys in your database. In SQL Server, the relationships screen allows for drag-and-drop creation of the linkages.
- [Instructor] The next part to creating the database…in SQL Server is to hook our tables together…with relationships.…In order to do that here in SQL Server…we need to find each of the tables we were interested in…inside of the tables folder for our database…and we're going to find the child table…in the relationship.…In this case the first relationship I want to work on…is between customers and invoices…and in this relationship…the invoices table servers as the child table.…Let's go ahead and right click on it…and we'll go up to design.…That will bring us back into the design window…that we were working with a moment ago.…
Then I need to find the relationships button…and normally it's on the toolbar,…but on my screen it's currently off the screen…because of the resolution.…In order to find it I'll press the…downward pointing button here…on the far right hand side of the toolbar…and then we'll find the relationships button here.…It's the icon with the two tables linked with a plus icon.…That'll open up the foreign key relationship screen…
Adam Wilbert covers the basics of relational database design, regardless of whether you use Access, FileMaker, Open Office, or SQL Server. Learn how to prevent data anomalies, gather requirements to plan your design, and develop a conceptual data model—translating your ideas into components like tables, relationships, queries, and views. Plus, learn about logical design considerations that can help you construct a database that is easy to maintain.
- Identify the three rules of relations.
- Summarize the four stages of developing a relational database.
- Describe a strategy one might use to ensure a database remains flexible in terms of the questions a user can ask.
- Explain how to avoid scope creep.
- Recall the characteristics of a Lookup Table.
- Recognize situations in which denormalization would be beneficial.
- Understand the types of relationships modeled by junction tables.
- Define referential integrity.
Skill Level Beginner
1. Relational Database Basics
Relational structures3m 46s
2. Preventing Data Anomalies
3. Gathering Requirements
4. Developing the Conceptual Data Model
5. Normalizing Your Data
6. Logical Design Considerations
7. Developing the Physical Database
- 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.Cancel
Take 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.