That would be a one-to-one relationship with the Customer database. In a Sales database where customers purchase products, some customers might receive special discount rates (such as wholesale, retail, tax exempt, etc.), which would require a Discount Rate database. Other types of relationships include One-to-One and Many-to-Many. This type of relational database is called a One-to-Many relationship, which means each driver can have multiple violations or multiple addresses, but the violations and/or addresses databases cannot have multiple drivers. For example, one Slave database might contain all of the individual's driving violations, while another might contain all the previous addresses of the individual drivers.
![free relational database pc free relational database pc](https://cdn.comparitech.com/wp-content/uploads/2019/11/lucidchart-.jpg)
Free relational database pc drivers#
One or more related databases, called Slave, Child, or Detail databases, contain additional information that's related to the individual drivers (identified by the unique key field License Number). This foundational Master database (in this example) contains all the information that's on your driver's license. This unique number is called a Key Field, which is used to connect a flat-file database to other associated databases (called relational databases). Your license contains your name, gender, height, weight, eyes and hair color, address, date of birth, license issue and expiration date, license class.īecause it's possible to have multiple people with the same name, address, gender, and description (like a father and son), driver's licenses all have license numbers.
![free relational database pc free relational database pc](https://www.hyperoffice.com/images/workmap-screenshot-1.png)
The relational database is a combination of the Master spreadsheet table and all of its Slave tables or spreadsheets.įor example, your driver's license is a single record in a flat-file database that resides on a computer at the Department of Motor Vehicles (DMV). One spreadsheet, alone, is a database, but not a relational one.