Key Insights on Database Systems and Pronoun Data Policies
School
Montclair State University**We aren't endorsed by this school
Course
INFO 565
Subject
Information Systems
Date
Dec 11, 2024
Pages
4
Uploaded by aminb2230137
Part 1. Write a short summary of the main lessons you learned in the module. Data and database systems are critical components of information technology that enable data storage, retrieval, and administration. Data are basic facts and numbers that can be analyzed to yield meaningful information. Database management systems (DBMS) organize and manage organized data collections. Database management systems (DBMS) are pieces of software that provide tools for creating, querying, updating, and managing databases. It allows multiple users to view and alter data simultaneously while maintaining data consistency, security, and integrity.Relational databases organize data into tables with rows and columns, whereas non-relational databases, such as NoSQL databases, store data in a variety of formats, including documents, graphs, and key-value pairs. Databases are heavily used in a variety of applications, including social networking platforms, scientific research, corporate operations, and customer relationship management systems. Through the provision of dependable and effective access to vast amounts of data, they facilitate decision-making processes. In today's digital age, building and implementing successful data-driven solutions requires an understanding of data and database systems.
Part 2. Based on the three options listed as drop-down list, validation table, and free-form field, in my personal opinion StateU should implement Validation Table Policy because this solution has advantages as listed below. One of the main reasons is it would allow users to type their pronouns into the MIS field as a string of characters, andthe pronouns would then be checked against a predefined validation table.Validation Table policyAdvantages: The validation table aims to standardize the collection and display of pronoun data, ensuring a cleaner and more structured understanding of the StateU community. It also ensures uniform display across all systems, improving data organization and accessibility. Additionally, the table aims to prevent misspellings of pronouns, enhancing the overall user experience.Disadvantages: The only downside is potential issues with allowing non-common pronouns and difficulty in pronunciation of made-up ones.Drop – down List SolutionAdvantages: Many universities use a drop-down option that allows users to select one from four options, reducing implementation time and resources, allowing focus on critical projects, budget cuts, and short staff, and promoting self-authorization and respect.Disadvantages The "other" option in pronouncing gender can lead to feelings of offence and isolation, as individuals may feel disrespected or hurt. The fluid nature of pronouns can create social debt and additional administration costs. StateU's large Hispanic,
Litinx, international, and Indigenous students often use pronouns in languages other than English, which could be prohibited by the system.Free Form Field optionAdvantages: Allow users to simply type their pronouns into the MIS interface and the pronouns would be stored as a string.Disadvantages: The proposed system requires significant development and discovery work to transfer data, potentially increasing costs and scope. The implementation of a "free for all" solution could lead to malicious threats disrupting university systems. Additionally, specifying a character length for the free form field may be necessary to accommodate long strings, as some systems may not accommodate very long strings.Conclusion By introducing and executing one of the choices, StateU was able to innovate and create a game-changing solution. However, taking into account all of the elements and making a judgment that could threaten the structure of many industry-wide systems, fluidity, plurality, and cultural evolution of personal data such as pronouns. For all offered ideas, it is critical to thoroughly analyze both the pros and disadvantages and make an informed conclusion. Sources: Case Study of StateU from HBP by author Marta Stelmaszak and Erica Wagner. Videos of Prof. Malaga for Data.https://www.mongodb.com/resources/compare/relational-vs-non-relational-databaseshttps://www.economist.com/finance-and-economics/2020/02/27/rethinking-how-we-value-data.