Purchase Solution

Relationships Related to Databases

Not what you're looking for?

Ask Custom Question

Describe the relationships related to databases for Huffman Trucking Driver's Log :

1. One to one
2. One to many
3. Many to many

Purchase this Solution

Solution Summary

Various types of relationships in connection to databases are described.

Solution Preview

Relational Databases:
A database is a structured collection of tables with related data. Database consists of set of structured records which is stored in computer systems. This structure can be achieved by organizing data into database model. The relational database model is most commonly used today.

One-to-One Relationships:
A one-to-one relationship between the tables of the relational database occurs when both tables can have one record on either side of the relationship. Each primary key value relates to only one record in the related table. Most one-to-one relationships are forced by business rules and don't flow naturally from the data.

In the case of Huffman's database, it consists of two tables
- Which represents information about the drivers employed by the company
- Which represents information contained in the paper Driver's Daily Log that each driver maintains

Huffman Trucking Driver's Log Table Fields:
The tables are given below:
Driver Information:

This table represents information about the drivers employed by the company.

Name
Employee ID Number
Home Address
Home Telephone Number
Mobile Telephone Number
License Number
License Expiration Date
Emergency Contact Name
Emergency ...

Purchase this Solution


Free BrainMass Quizzes
Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.