Purchase Solution

MS acess: Setting up the keys

Not what you're looking for?

Ask Custom Question

I need help setting up keys and relationships with the attached database. Please post your recommendations as a new MS Access file as well as a text explanation for the reasons.

Attachments
Purchase this Solution
Solution Summary

This posting contains solution to following database question in MS Access.

Solution Preview

Please see the attached file.

PRIMARY KEYS
The rule for assigning primary key is that it should uniquely identify each record in the table.
Table: DRIVER
Primary key: Driver Identification_NO
Reason: This table contains the details of drivers. Driver Identification_NO field would be sufficient to uniquely identify each entry in the table as each driver has a unique identification no.

Table: DRIVER LOG
Primary key: Segment_ID, Driver_ID, Start_date and Start_time
Reason: None of the fields or combination of fields in this table would be able to uniquely identify each record. This is ...

Purchase this Solution
Free BrainMass Quizzes
C++ Operators

This quiz tests a student's knowledge about C++ operators.

Javscript Basics

Quiz on basics of javascript programming language.

C# variables and classes

This quiz contains questions about C# classes and variables.

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.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

View More Free Quizzes
Related BrainMass Solutions

  • Driver Log Tables for Huffman trucking

    Regards, This posting contains the basic database in MS Acess for Huffman trucking

  • Creating keys and relationships in database

    119254 Create the keys and relationships between tables Using MS Access, I need to create the keys and relationships between the tables for the Driver LOG attached.

  • technical instructions

    The setting up your remote control and operation section are concise except that the instructions are sometimes ambiguous.

  • Note on Phil's diet plant

    Phil reveals 7 keys to losing weight, in which you'll focus on eating habits, impulse eating, nutrition, setting up an exercise program and, finally, setting up a support system.

  • ERD using MySQL modeling tool

    Use MS Visio to draw an entity-relationship diagram (ERD) for the JustLee Book database (reference the structure of the database in Figure in the Ppt presentation attached).

  • MS Access database

    76100 MS Access database (See attached file for full problem description) --- Implement the database in MS access with Relationships, tables, keys, indexes and a view(query) that duplicated the spreadsheet and list all functional dependencies and

  • Philanthropic Program: Implementation

    Setting up a successful strategic philanthropic program is in essence, very similar to setting up a strategic business plan: one must put in writing the steps one intends to take, and the mission of the program.

  • Creating Tables with SQL Server

    Apply the primary keys to the tables.)Create database and two tables (Employee & Job_Title). Both of these tables should have primary and/or foreign keys in them.

  • Examples of 1-N, N-1, and N-N relationships

    Describe the three types of relationships and explain your examples. For each example, name the entities and attributes, select the primary and foreign keys, and present it in the common shorthand method.

View More Related Solutions