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.
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 ...
Solution Summary
How to maintain referential integrity of the database is achieved.
... then application will be responsible to maintain referential integrity of the ... having foreign key relationship and referential integrity is maintained in by ...
... For more information on maintaining accurate table relationships, see Referential Integrity. ... to implement it in a way that makes it easy to maintain. ...
... model, is the process of arranging data into logical, organized groups of objects that can easily be maintained. ...Referential integrity simply means ...
... data quality, check data integrity, and maintain data relationships and referential integrity. ... A stored query, database view, or a database stored ...
... uses the Pinehill database to maintain information about the ... data that she was maintaining in another ... Select the Enforce Referential Integrity option and the ...
... In addition, referential integrity is more of a chore ... Logical database design, also referred to as the logical ... groups of objects that can easily be maintained. ...
... You'll help him maintain the Payments database by ... Records table in the PlusPays database (located in ... Select the referential integrity option and both cascade ...
... add one or more records to any single table in a relational database. ... in the references table would also have to be deleted to maintain referential integrity. ...
... The Dynamic Performance Tables Throughout its operation, Oracle maintains a set ... added to the refresh group so as to maintain referential integrity. ...
