Computer Science Question

Data Dictionary Exercise for University Library Systems.

Scenario:

Metropolitan University plans to upgrade its library management system with an enhanced and digital-friendly platform. The goal is to manage books, journals, digital assets, students, faculty, and library staff details more efficiently while making borrowing, returning, acquisitions, and inventory auditing efficient, accurate, and user-friendly.

A library management system must take into account:

User Information: This category encompasses students, faculty, and library staff alike. Each has unique attributes like ID number, name, and address as well as courses taken, departments taught in, and roles assigned (for students).

Asset Information: This comprises information on all physical and digital assets like books, journals, e-books, and videos that exist within an institution’s collection. Each asset should have a unique identifier assigned as well as title information including author(s), publication date genre status.

Transaction Information: When assets are borrowed and returned, the system should record details about each transaction including transaction ID, user ID, asset ID number, date of issue/due date/return date/due date as well as due date and return date/due date information.

Acquisition Information: As new assets are added to a library, this part of the system records their acquisition details such as ID number, date of acquisition, asset ID number, vendor details, and cost.

Assignment: Your task is to create a data dictionary for Metropolitan University’s library management system based on the given scenario. Your dictionary should list, define, and provide data types for attributes associated with users, assets, transactions, and acquisitions.

Instructions: Begin by identifying the primary entities and their attributes within your system. Next, construct a structured data dictionary table outlining these details: Data Element Name || Description || Data Type (e.g., integer, string, or date) || Length (if applicable) || Valid Range/Values (if applicable) || Default Values (if applicable).

(If relevant) Provide brief explanations for each entry in your data dictionary, providing reasons why they believe it to be essential as well as how decisions were reached regarding data types or length.

This exercise will test your ability to extract essential data elements from a scenario, organize them systematically and justify your decisions within system design context.

Essential Activities:

  1. Reading Chapters 8-9 will assist you with this exercise.
  2. Watching the video on Process Specification and Decision Making will assist you with this exercise.

Notes:

  1. This paper must be formatted in APA Style 7th edition.
  2. This paper should have a properly formatted title page, introduction, content body, conclusion, and references.

Requirements: 900 words explaination + Screenshots

WRITE MY PAPER