checkyourwork_Exam3_Review

checkyourwork_Exam3_Review - Product Table Primary Key Same...

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

View Full Document Right Arrow Icon
EXAM #3 - REVIEW Check Your Work 1 CSA 148
Background image of page 1

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

View Full DocumentRight Arrow Icon
Exam #3 - Review Form: ContractInfo. CSA 148 2
Background image of page 2
Exam #3 - Review Report: Contracts (In Print-Preview) CSA 148 3
Background image of page 3

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

View Full DocumentRight Arrow Icon
Exam #3 - Review Refer to image in the 148Exam 3 Review for solutions to most tasks. CSA 148 4 Relationships
Background image of page 4
Exam #3 -- Review Q8_ContactClients Descriptive Query CSA 148 5 Refer to AC119 for the comparison operators (such as Between).
Background image of page 5

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

View Full DocumentRight Arrow Icon
Exam #3 -- Review Q9_ClientAmountAndTime Descriptive Query CSA 148 6 Note the Column Labels. All rows adjusted to fit Total Effort column formatting set to Fixed and 1 decimal.
Background image of page 6
Exam #3 -- Review Store Table Primary Key Generally not an “Auto Number” for a master table like this. Could have had address fields, phone number, etc.
Background image of page 7

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

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

Unformatted text preview: Product Table Primary Key Same comment as for Store. Quantity would NOT be appropriate, should just describe products (color, weight, size, etc.) CSA 148 7 Exam #3 -- Review Inventory Table Primary Key In this case a Sequence ID is convenient. Quantity is an important field per the reason for the database. Table must include the Store and Product IDs so the association between Stores and Products can be made. Relationships Two relationships would be created. CSA 148 8 Exam #3 -- Review Sample Data In the Inventory Table, the Store ID and the Product IDs must match the IDs in the Store and Product tables. CSA 148 9...
View Full Document

Page1 / 9

checkyourwork_Exam3_Review - Product Table Primary Key Same...

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

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