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.