Designing CML Administration

Administrators need access to add, delete, and change records in the Corporate Media Library (CML) SQL Server 7.0 database. The CML Functionality for F & M Administrators topic describes the way the designers envision the administrative user interface should work.

Administrators need to interact with the CML database to perform the following actions:

• Add, change, and delete title information.
• Add, change, and delete item information. An item is an individual copy of a library title. The library contains multiple copies of popular titles. To allow the CML application to track who has an item checked out, each item must have information that distinguishes it from other copies of the same title. The CML developers decided that a bar code would be an effective way to distinguish among items.
• Add, change, and delete subject information. Subjects are associated with titles. A title can have one or many subjects and a subject can be associated with one or many titles.
• Add, change, and delete author information. Authors are associated with titles. A title can have one or many authors and an author can be associated with one or many titles.
• Assign a code to each item that indicates its status (such as in or out). This also requires a way to add, change, and delete these status codes.
• Select and fill a request to check out a library title. The request record is deleted after the request is filled. The information for each borrower needs to include a tally of items checked out over time.
• Renew the due date of checked-out library materials. When a request for the title is pending the due date cannot be extended.
• Check items in to the library. The bar code assigned to each item is the only value needed to do this.
• Modify application settings. Application settings are stored in the database.