w6_2_Database%201_chp6 - Product.Reorder level...

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

View Full Document Right Arrow Icon
IE 332: Computing in IE 2/17/2010 Ji Soo Yi yij@purdue.edu Database 1 Database 1
Background image of page 1

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

View Full DocumentRight Arrow Icon
Review Review Problems with the traditional file environment Primary Key vs. Foreign Key Normalization? A
Background image of page 2
Announcements Announcements Exam 1 Re-grading Request Due: 2/19/2010
Background image of page 3

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

View Full DocumentRight Arrow Icon
Lessons from Session C Lessons from Session C ??
Background image of page 4
Lessons from Session C Lessons from Session C My impressions. .. It’s generally easy to follow the given tutorial. However, it takes time. Solving three problems about “Northwind Traders” was easy, but the third one was tricky.
Background image of page 5

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

View Full DocumentRight Arrow Icon
FAQs FAQs I updated the database using the form, but they are not shown in my table? I don’t know how to solve the last question. .. “Which is the best-selling product?”
Background image of page 6
FAQ 1 FAQ 1 I updated the database using the form, but they are not shown in my table?
Background image of page 7

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

View Full DocumentRight Arrow Icon
FAQ 2 FAQ 2 “Which is the best-selling product?” Context. .. Product.Unit Price Product.Units on Order
Background image of page 8
Background image of page 9

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

View Full DocumentRight Arrow Icon
Background image of page 10
Background image of page 11

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

View Full DocumentRight Arrow Icon
Background image of page 12
Background image of page 13

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

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

Unformatted text preview: Product.Reorder level Product.Units on Stock Entity-Relationship Entity-Relationship Diagram Diagram ring and dash A has zero or one B dash and dash A has exactly one B ring and crow's foot A has zero or more B dash and crow's foot A has one or more B A A A A B B B B Entity-Relationship Diagram Model Entity-Relationship Diagram Model A Scenario A Scenario A publishing company produces scientific books on various subjects. A Scenario A Scenario A publishing company produces scientific books on various subjects. In this company, a book is written by a single author, but an author tend to write multiple books for this company. A Scenario A Scenario A publishing company produces scientific books on various subjects. The company changed the policy, so the books could be written by multiple authors. TipShow? TipShow?...
View Full Document

This document was uploaded on 09/19/2010.

Page1 / 14

w6_2_Database%201_chp6 - Product.Reorder level...

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

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