{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Candy LoversLASTPART

Candy LoversLASTPART - Candy Lovers Inc Group Members Group...

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

View Full Document Right Arrow Icon
Candy Lovers, Inc. Group Members : Group Leader: Jennifer Duenas Group Color: Blue Group Section: 5 Working Title of the Application Project : Inventory Control and Tracking Date Due: May 1, 2008 Table Definitions: 1. Employee Table
Background image of page 1

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

View Full Document Right Arrow Icon
- This table has all the information of all employees. Fields: - EID (Employee Identification Number), Data Type: Number, Field Size: Double - ELastName (Employee’s Last Name), Data Type: Text, Field Size: 50 - EFirstName (Employee’s First Name), Data Type: Text, Field Size: 50 - EAddress (Employee’s Address), Data Type: Text, Field Size: 50 - ECity (Employee’s City), Data Type: Text, Field Size: 50 - EState (Employee’s State), Data Type: Text, Field Size: 5 - EZipCode (Employee’s Zip Code), Data Type: Number, Field Size: Double - EPhone (Employee’s Phone Number), Data Type: Number, Field Size: Double - Wages (Employee Wages), Data Type: Currency, Field Size: ---- - Title (Employee’s Title), Data Type: Text, Field Size: 50 - HWWeekly (Employee Hours Worked Weekly), Data Type: Long Integer, Field Size: Long Integer 2. Inventory Purchases Table
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.

{[ snackBarMessage ]}