Assignment 5

Using this diagram as the conceptual model, develop a logical model based on it. Specify all the integrity constraints in English. The constraints must immediately follow the table that is being constrained. Make sure you use your name and featured stock symbol. DO NOT use the professors name. The form of the logical model is:

TableName(primaryKey, field1, field2, field3)

FOREIGN KEY field2 REFERENCES lookupTableName

Customer customerEmail Order firstName lastName phone shipDate comments zipCode status Product Vendor OrderDetail product_name upples-__ - vendorAddr ineNumber price vendorEmail Change this table name and featured symbol Art-Hendela-CL symbol Consumer Industrial Investment date productiD productiD productiD open Add the other 5 fields ship time payment_terms symbol Customer customerEmail Order firstName lastName phone shipDate comments zipCode status Product Vendor OrderDetail product_name upples-__ - vendorAddr ineNumber price vendorEmail Change this table name and featured symbol Art-Hendela-CL symbol Consumer Industrial Investment date productiD productiD productiD open Add the other 5 fields ship time payment_terms symbol