Threesuns

Email the Instructor

Contact

All Semesters

Semesters

All Courses

Courses

2017Spring

01.09.17 - 05.07.17

Database Design

CSYS2643

Monday
05:30 PM - 08:20 PM

Field Specifications

Lab04

Objective: To define fields and their details for a database

pastdue

Submit Your Solution

Lab04

Request a Copy of your Solution

Lab04

Requirements

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

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