WebCT-chapter05sols

WebCT-chapter05sols - Answers to Chapter 5 Problems 1 Answers to Chapter 5 Problems 1 Customer CustNo CustFirstName CustLastName CustCity CustState

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

View Full Document Right Arrow Icon
2/23/2011 Answers to Chapter 5 Problems 1 Answers to Chapter 5 Problems 1. Customer CustNo CustFirstName CustLastName CustCity CustState CustZip CustBal Order OrdNo OrdDate OrdName OrdCity OrdState OrdZip Places All data types should be variable length character strings (VARCHAR) except for CustNo, OrdNo, and OrdDate. CustNo and OrdNo should be INTEGER. OrdDate can be either DATE or TIMESTAMP (include time and date). 2. Customer CustNo CustFirstName CustLastName CustCity CustState CustZip CustBal Order OrdNo OrdDate OrdName OrdCity OrdState OrdZip Places Employee EmpNo EmpFirstName EmpLastName EmpPhone EmpEMail EmpDeptName EmpCommRate Takes
Background image of page 1

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

View Full DocumentRight Arrow Icon
2/23/2011 Answers to Chapter 5 Problems All data types should be variable length character strings (VARCHAR) except for EmpNo and EmpCommRate. EmpNo should be INTEGER, and EmpCommRate should be DECIMAL. 3. Customer CustNo CustFirstName CustLastName CustCity CustState CustZip CustBal Order OrdNo OrdDate OrdName OrdCity OrdState OrdZip Places Employee EmpNo EmpFirstName EmpLastName EmpPhone EmpEMail EmpDeptName EmpCommRate Takes Manages 2
Background image of page 2
2/23/2011 Answers to Chapter 5 Problems 4. Customer CustNo CustFirstName CustLastName CustCity CustState CustZip CustBal Order OrdNo OrdDate OrdName OrdCity OrdState OrdZip Places Employee EmpNo EmpFirstName EmpLastName EmpPhone EmpEMail EmpDeptName EmpCommRate Takes Manages Product ProdNo ProdName ProdQOH ProdPrice ProdNextShipDate Contains Qty 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
Answers to Chapter 5 Problems 5. Customer CustNo CustFirstName CustLastName CustCity CustState CustZip CustBal Order OrdNo OrdDate OrdName OrdCity OrdState OrdZip Places Employee EmpNo EmpFirstName EmpLastName EmpPhone EmpEMail EmpDeptName EmpCommRate Takes Manages Product ProdNo ProdName ProdQOH ProdPrice ProdNextShipDate ProdOrd Qty
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/21/2011 for the course MIS 310 taught by Professor Staff during the Spring '08 term at George Mason.

Page1 / 14

WebCT-chapter05sols - Answers to Chapter 5 Problems 1 Answers to Chapter 5 Problems 1 Customer CustNo CustFirstName CustLastName CustCity CustState

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

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