Explore BrainMass

Explore BrainMass

    maintain referential integrity of the database

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Using the final table list you created for Learning Event 3, select the Primary Keys for each table in your list. Then, select one of your tables and complete field specifications for each field. Use the field specifications sheet located on page 286 (Figure 9-1) of your textbook.

    Note: Your field specifications sheet does not have to have the same format as the one in your text. Just be sure to provide the same information.

    © BrainMass Inc. brainmass.com March 4, 2021, 7:27 pm ad1c9bdddf


    Solution Preview

    Primary key: Customer ID. In case there is no customer ID, then use customers name and address.

    Primary key: Product ID(Product name). In case there is no product ID, then use product name, provided that each product has a different name.

    Suppliers: Primary key: Supplier ID. In case there is no supplier ID, then use supplier's name and address.
    Orders: Order ID.

    Primary key: event locating, description date and product number.

    Field specification for Events table:

    General Elements:
    Field Name: location spec type: generic
    parent table: events source spec: none
    Label: location
    Shared by: none
    Alias: none
    Description: a ...

    Solution Summary

    How to maintain referential integrity of the database is achieved.