Appendix C Sample Data Dictionary

Data Dictionary Entries for the ACME Library Management System

Configuration Identification: ACME.001.DD001

Name :

Asset Database

Aliases:

None

Where Used/How Used:

Used by the Database Management System to process requests and return results to the Inquiry and Administration Sub-systems

Content Description:

Attributes associated with each asset including:

  • Asset Number = 16 numeric digits
  • ISBN Number = 16 alphanumeric characters
  • Library of Congress Classification Number = 16 alphanumeric digits
  • Asset Title = 64 alphanumeric characters
  • Author = 32 alphanumeric characters
  • Dewey Decimal Classification Number = 16 numeric digits
  • Media Type = Enumeration {BOOK MAGAZINE CDROM REFERENCE}
  • Status = Enumeration {IN OUT LOST MISSING DUE_DATE}
  • Category = Enumeration {FICTION NONFICTION}
  • Published = 32 alphanumeric characters
  • Keywords = 64 alphanumeric characters
  • Date Acquired = Date
  • Location = 16 alphanumeric characters

Name:

Membership Database

Aliases:

None

Where Used/How Used:

Used by the Database Management System to process requests and return results to the Inquiry and Administration Sub-systems

Content Description:

  • Attributes associated with each asset including:
  • Membership Number = 10 numeric digits
  • Member Since Date = Date
  • Last Name = 16 alphanumeric characters
  • First Name = 16 alphanumeric characters
  • Address = 64 alphanumeric characters
  • Phone Number = 11 numeric digits (1, area code, phone number)
  • Assets on Loan = Array containing 10 strings, each containing 64 alphanumeric characters
  • Assets Overdue = Array containing 10 string,s each containing 64 alphanumeric characters
  • Late Fees Due = 10 numeric digits
  • Maximum Allowed Loans = 2 numeric digits

Name:

Member Data

Aliases:

None

Where Used/How Used:

A file used to validate username and passwords for members , librarians, and administrator when attempting to access the system. The username and password entered is compared with the username and password in this file. Access is granted only if a match is found.

Content Description:

Attributes associated with each asset including:

  • Member Username = 16 alphanumeric digits
  • Member Password = 16 alphanumeric digits

Name:

Library Data

Aliases:

None

Where Used/How Used:

Files maintained by the Administrator and used to provide general information about the library.

Content Description:

HTML files for:

  • General Library Information (Policy, etc.)
  • Coming Events
  • Library Floor Map
  • Library Directions Screen

Name:

Database Catalog

Aliases:

None

Where Used/How Used:

Used by the DDL Compiler process.

Content Description:

Contains detailed information about the various objects in the databases, including tables, indices, integrity constraints, security constraints, etc.




Software Configuration Management
Software Configuration Management
ISBN: 0849319765
EAN: 2147483647
Year: 2006
Pages: 235
Authors: Jessica Keyes

Similar book on Amazon

Flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net