Lab 6 - Lab 06 Answer Key 1. Below is the membership...

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

View Full Document Right Arrow Icon
Lab 06 Answer Key 1. Below is the membership application for the Canton Falls Computer Club. Until now the club has been keeping their membership information on 3x5 cards. Now they want to design an information system, probably a small database application, to store the membership information. What attributes can you identify from this card, and what data type would you use for each? Answers will vary. One solution would be: LastName Text 30 FirstName Text 30 Address Text 50 City Text 25 St Text 2 Zip Text 10 DayPhone Text 10 EveningPhone Text 10 Email Text 75 NumComputers Byte ContributionAmt Currency IntWeb Yes/No IntMac Yes/No IntWindows Yes/No IntProgramming Yes/No IntLinux Yes/No IntNetworking Yes/No MembershipDate DateTime
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. You have been asked to design a database to track data from Bender’s Auto Body Customer Satisfaction Survey (shown below). Create a list of the attributes needed for tracking this data and the data type for each attribute. For text attributes, estimate the
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/30/2012 for the course CNIT 180 taught by Professor Victorbarlow during the Spring '12 term at Purdue University-West Lafayette.

Page1 / 4

Lab 6 - Lab 06 Answer Key 1. Below is the membership...

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