Threesuns

Email

Contact

All Semesters

Semesters

All Courses

Courses

Database Design

CSYS2643

3 credits

Labs

Field Specifications

Lab

100 points

Requirements

A complete specification is given for each field70
Field specifications are correct30
Total100 pts

Objective

To define fields and their details for a database

Instructions

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