Develop relationships

Keyboard Shortcuts

Building relationships between tables allows the database to pull associated data from the individual tables. Cardinality denotes the maximum number of records from each table that will be involved in a relationship, and optionality defines the minimum nu

- [Tutor] Now that our fields are organized by subject,…we should have a good understanding…of all the tables that will need to be created…in the database in order to satisfy our mission objectives.…Additional tables will be required…by the DBMS to operate efficiently,…but we'll identify those more thoroughly…in the next chapter.…The next stage is to begin hooking our tables together…in a series of relationships.…To do this, we'll evaluate each of our tables…against every other table,…and ask if there's an association between the entities.…In making this determination,…it's often helpful to try and verbalize the relationship.…

For instance, when comparing the Employees table…to an Invoice table,…you might say that the employee assists with an invoice,…or that an invoice is created by an employee.…If you were to compare the Invoices…with the Line Items table,…you might realize that invoice is made up of line items,…or that a line item appears on an invoice.…These types of sentences often come directly…from their requirements gathering phase…

Resume Transcript Auto-Scroll

Author

Released

9/27/2017

Have you ever opened up a database that someone else built and felt a little lost? Or ever thought of designing your own simple database and been unsure of where to start? Or perhaps you need to work with a team of database professionals and don't know how to speak their language? This course can help you overcome these hurdles.

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.