ERD Entity Relationship Diagram - StudentOfFortune.com

Question

Asked by:

cfischer1979
Rating (74): C-
Questions Asked: 23
Tutorials Posted: 182, earned $2,316.07

$20.00 ERD Entity Relationship Diagram

From Computer-Science: General-CS , General-Questions: General-Academic-Questions
Closed, but you can still post tutorials
Due on May. 08, 2009
Asked on May 05, 2009 at 9:36:38PM

Q:
ERD Entity Relationship Diagram - Visio is the preferred software for the Entity Relationship Diagrams. Your ERD should contain all 11 tables and should clearly flag all Primary keys, foreign keys and cardinality. Your ERD software should show the data types for each field (such as data, number, text etc.
I need Primary Keys only on these topics in the attachments Parts Inventory Purchases, Parts Inventory Issues, Parts Catalogue, Vendors, Parts Purchasing History, Vehicle Maintenance

Attachments:
HuffmanDatabasesEandAFleetTruckMaintenanceRev.pdf (91K)

Attachments:

Available Tutorials to this Question

Posted by:

meghan931
Rating (11): C-
Questions Asked: 4
Tutorials Posted: 131, earned $298.25

$20.00 the answer is quite easy and simple

This tutorial hasn't been purchased yet.
Posted on May. 06, 2009 at 12:24:29AM

A:
Preview: ... n a table. A primary index is automatically created for the primary key. The primary index is used by the database manager for efficient access to table rows, and allows the database manager to enforce the uniqueness of the primary key. (You can also define indexes on non-primary key columns to efficiently access data when processing queries.) If a table does not have a "natural" unique key, or if arrival sequence is the method used to distinguish unique rows, using a time stamp as part of the key can be helpful. Primary keys for some of the sample tables are: Table Key Column Employee table EMPNO Department tabl ...

The full tutorial is about 606 words long .