Project 4 - Description: 4. Physical Elements Data Type:...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Using the final table list you created previously, select the Primary Keys for each table in your list for both Access  and MySQL. Then, select one of the tables and complete field specifications for each field. Download and use the  field specifications sheet . 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. Then write two queries 1. List each customer with all their orders. 2. List each product with its price, how much has been ordered and what is the sales total for that item. You  will need to populate you tables with sample data. 3. Field Specifications General Elements Field Name: Specification Type: Unique Generic Replica Parent Table Source Specification: Label: Shared by: Alias(es):
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Description: 4. Physical Elements Data Type: Character Support: Letters (A-Z) Keyboard (. , / $ # %) Numbers (0-9) Special Characters Length: Decimal Places: Input Mask: Display Format: 5. Logical Elements Key Types: Non Primary Foreign Alternate Edit Rule: Enter Now, Edits Allowed Enter Now, Edits Not Allowed Enter Later, Edits Allowed Enter Later, Edits Not Allowed Not Determined At This Time Key Structure: Simple Composite Uniqueness: Non-Unique Unique Null Support: Nulls Allowed No Nulls Values Entered By: User System Required Value: No Yes Default Value: Range of Values: Comparisons Allowed: Same Field All = > > = < < = Other Fields All = > > = < < = Value Expression All = > > = < < = Operations Allowed: Same Field All + - X Concatenation Other Fields All + - X Concatenation Value Expression All + - X Concatenation...
View Full Document

This note was uploaded on 07/10/2011 for the course ITOC 231 taught by Professor Shah during the Summer '11 term at AIU Online.

Page1 / 2

Project 4 - Description: 4. Physical Elements Data Type:...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online