Appendix C Sample Data Dictionary

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.