Lab7_DB2_F09 - Relational Database with Access Lab 6 review...

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

View Full Document Right Arrow Icon
Relational Database with Access • Lab 6 review • Enforce relationship in Access: Enforce relationship in Access: referential integrity • Create: –Queries –Forms 1 Forms –Reports • SQL (Structured Query Language) IE332 F 09 Lab 6 Review: The Distribution Center • The center receives items from vendors on trailers by appointment numbers and keeps a record of all received goods • The center keeps records on each vendor to help decide with which vendor they should renew the contract 2 • Records are also kept regarding all employees’ information for the distribution center • In addition, records are kept to keep track of shipments made by the distribution center IE332 F 09
Background image of page 1

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

View Full DocumentRight Arrow Icon
Entity Relationship Diagram VENDOR EMPLOYEE SHIPPING RECEIVING 1:M M:1 1:M VENDOR and RECEIVING relationship (One-to-many) More than one receiving appointment can be made by the same vendor, but a single receiving appointment can only belong to a single vendor RECEIVING and EMPLOYEE relationship (Many-to-one) More than one receiving appointment can be processed by the same 3 More than one receiving appointment can be processed by the same employee, but a single receiving appointment can only be processed by a single employee EMPLOYEE and SHIPPING relationship (One-to-many) More than one shipment can be processed by the same employee, but a single shipment can only be processed by a single employee IE332 F 09 One-to-Many Relationship One-to-Many Relationship: A professor can have many students, but a student can have only one professor (correct for most classes you are taking) The terms “parent” and “child” are sometimes applied to 4 relations in 1:M relationships. • Parent relations are located on the “one” side of the relationship
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/19/2012 for the course IE 230 taught by Professor Xangi during the Spring '08 term at Purdue University-West Lafayette.

Page1 / 9

Lab7_DB2_F09 - Relational Database with Access Lab 6 review...

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

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