Objective

To define fields and their details for a database

For this assignment you will create field specifications for your art contest database project. Take the list of fields that were finalized in the previous lab and working from that list, complete a spreadsheet, something like what you'll find on page 309-310 of the textbook, for each of the fields in your database. At a minimum you should specify the following for every field in the database:

• Field Name
• Parent Table
• Label
• Specification Type
• Source Specification
• Aliases
• Description
• DataType
  
• Length
• Decimal Places
• Character Support
• Input Mask
• Display Format
• Key type
• Key Structure
• Uniqueness
• Null Support
• Values entered by
• Required Value
• Default Value
• Range of Values