maintain referential integrity of the database
Not what you're looking for?
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.
Purchase this Solution
Solution Summary
How to maintain referential integrity of the database is achieved.
Solution Preview
Customer:
Primary key: Customer ID. In case there is no customer ID, then use customers name and address.
Products:
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.
Events:
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 ...
Purchase this Solution
Free BrainMass Quizzes
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.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
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.
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: 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.