CST 1340 - Information in Organisations
29 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Students must attend at least 75% of the lecture and lab sessions to pass CST1340.

True (A)

What is the minimum attendance percentage required for CST1340?

  • 50%
  • 75% (correct)
  • 80%
  • 60%

    • What is the grade given to students who do not meet the attendance requirement for CST1340?

    X

    In cases of unforeseen absence from lab sessions, students should contact their lab instructor via ______ to explain the reason for their absence.

    <p>email</p> Signup and view all the answers

    Match the following resources with their respective locations or availability:

    <p>Unihelp = Ground Floor of the Sheppard Library Module Handbook = Unihub / Moodle Lecture Slides = Unihub / Moodle Exercises and Tests = Unihub / Moodle</p> Signup and view all the answers

    Which of the following books is NOT listed as an additional text for CST1340?

    <p>HTML &amp; CSS: Design and Build Websites by Duckett (A)</p> Signup and view all the answers

    Mobile phones are allowed during lecture and lab sessions for CST1340.

    <p>False (B)</p> Signup and view all the answers

    What are the core topics investigated in CST1340, related to information management in organizations?

    <p>Data and information storage needs, data modeling, data management, data querying, and information presentation. These topics provide students with a comprehensive understanding of effective information management strategies within organizational settings.</p> Signup and view all the answers

    Which of the following are crucial considerations when designing an information system for an organization? (Select all that apply)

    <p>Relationship modeling between data (A), Data management techniques (C), Data storage methods (D), Presenting information effectively (E)</p> Signup and view all the answers

    The "mini-world" use case for Middlesex University only focuses on student data, excluding staff and other relevant entities.

    <p>False (B)</p> Signup and view all the answers

    What are the fundamental units of information in a database?

    <p>Objects</p> Signup and view all the answers

    Each object in a database is described using a set of ______

    <p>attributes</p> Signup and view all the answers

    Match the following information system aspects with their relevant questions:

    <p>Data Storage = How to store information? Data Modeling = How to model relationships between data? Data Management = How to manage data? Data Presentation = How to present information?</p> Signup and view all the answers

    What is a primary challenge associated with the file-based approach to data management?

    <p>Inability to handle complex queries (A)</p> Signup and view all the answers

    A database system offers a centralized repository for all data, making it easier to access and manage information.

    <p>True (A)</p> Signup and view all the answers

    What does DBMS stand for?

    <p>Database Management System</p> Signup and view all the answers

    A ______ is a software system that enables users to define, create, maintain, and control access to the database.

    <p>Database Management System (DBMS)</p> Signup and view all the answers

    Which of the following is NOT a component of a database system environment?

    <p>Operating System (C)</p> Signup and view all the answers

    Match the following components of a database system with their descriptions:

    <p>Application programs = Software that interacts with the database to perform specific tasks DBMS = Software that manages the database and provides access to data Stored database definition = Metadata describing the database structure and data organization Stored database = Actual data stored in the database system</p> Signup and view all the answers

    The database approach to data management is less flexible than the file-based approach

    <p>False (B)</p> Signup and view all the answers

    Give one advantage of using a database approach over a file-based approach to data management.

    <p>Improved data consistency and integrity</p> Signup and view all the answers

    Which of the following is a problem associated with the File-Based Approach?

    <p>Separation and isolation of data (A)</p> Signup and view all the answers

    Duplication of data in a File-Based Approach is efficient and cost-effective.

    <p>False (B)</p> Signup and view all the answers

    What does FBA stand for in the context of managing data?

    <p>File-Based Approach</p> Signup and view all the answers

    The structure of files in a File-Based Approach is often dependent on the ________ language used in application programs.

    <p>programming</p> Signup and view all the answers

    Match each problem associated with the File-Based Approach to its description:

    <p>Separation and isolation of data = Makes data difficult to access Duplication of data = Wasteful in storage and time Incompatible file formats = Dependent on programming languages</p> Signup and view all the answers

    How does the Database Approach differ from the File-Based Approach?

    <p>It centralizes data management (C)</p> Signup and view all the answers

    Incompatible file formats can be a challenge in a File-Based Approach.

    <p>True (A)</p> Signup and view all the answers

    List one question that a File-Based Approach would struggle to answer efficiently.

    <p>Is there any customer who has more than 10 orders and has bought more than 5 items?</p> Signup and view all the answers

    Flashcards

    Data Storage in Organizations

    The methods and systems used to store information within an organization.

    Attributes in Data

    Specific pieces of data that describe an entity, like a student's ID or name.

    Mini-world Use Case

    A simplified model of a real-world scenario used for data modeling, like a university's student system.

    Relationships between Data

    Connections among different data entities, showing how they interact, like students and modules.

    Signup and view all the flashcards

    Data Management Inquiries

    The processes involved in managing, querying, and presenting stored data effectively.

    Signup and view all the flashcards

    Attendance Requirement

    Students must attend at least 75% of lectures/labs to pass.

    Signup and view all the flashcards

    Absence Notification

    Inform the lab instructor via email if absent with details.

    Signup and view all the flashcards

    Prolonged Absence Protocol

    Raise prolonged absences with the module leader immediately.

    Signup and view all the flashcards

    Mobile Phone Policy

    No mobile phones during lectures and lab sessions.

    Signup and view all the flashcards

    Core Textbook

    Essential reading includes Connolly & Begg's Database Systems.

    Signup and view all the flashcards

    Module Resources

    Access module handbook, lecture slides, and tests on Unihub.

    Signup and view all the flashcards

    Information Management

    Study effective ways to manage information in organizations.

    Signup and view all the flashcards

    Data Querying

    Learn how to query data to retrieve necessary information.

    Signup and view all the flashcards

    File-Based Approach (FBA)

    An early method of managing data using individual files for each application.

    Signup and view all the flashcards

    Separation of Data

    Data stored in isolated files, making access difficult.

    Signup and view all the flashcards

    Duplication of Data

    Repeated data entries that waste space and resources.

    Signup and view all the flashcards

    Incompatible File Formats

    Different structures of files that hinder data exchange.

    Signup and view all the flashcards

    Access Difficulty

    Challenges in retrieving data from isolated files.

    Signup and view all the flashcards

    Data Management

    Techniques for storing, accessing, and maintaining data.

    Signup and view all the flashcards

    Modeling Relationships

    Creating connections between different data sets.

    Signup and view all the flashcards

    Querying Data

    The process of retrieving specific information from a database.

    Signup and view all the flashcards

    File Based Approach

    A method where data is stored in fixed queries and application programs.

    Signup and view all the flashcards

    Database Approach

    A method that uses a shared collection of logically related data for organizational needs.

    Signup and view all the flashcards

    Database Management System (DBMS)

    Software that manages the definition, creation, maintenance, and access control of databases.

    Signup and view all the flashcards

    Application Programs

    Software designed to perform specific tasks and process queries on a database.

    Signup and view all the flashcards

    Data

    Known facts that can be recorded and have implicit meaning.

    Signup and view all the flashcards

    Database

    A collection of related data organized for easy access and management.

    Signup and view all the flashcards

    Meta-Data

    Data that describes other data, enabling better understanding and management.

    Signup and view all the flashcards

    User Roles

    Different categories of users in a DBMS system that interact with the database.

    Signup and view all the flashcards

    Study Notes

    CST 1340 - Information in Organisations

    • CST 1340 is a module about information in organisations.
    • Attendance is monitored. Students need to attend at least 75% of lectures and labs.
    • Students with less than 75% attendance will fail the module and receive a grade X. Grade X prevents resitting the module.

    Absence Policy

    • If a student is unable to attend a lab session due to unforeseen circumstances, they must contact their instructor via email, providing the reason, the date and time of absence, and their student number.
    • For prolonged absences due to exceptional circumstances, contact the module leader immediately, and submit a deferral request as soon as possible.

    Course Resources & Support

    • Unihelp: For information and advice, visit the Sheppard Library, Ground Floor, Monday to Friday: 08:30 - 21:30, and Saturday/Sunday: 11:00 - 18:00.

    • Readings:

      • Connolly & Begg. 2009. Database Systems (5th Ed). Pearson.
      • Duckett. 2011. HTML & CSS: design and build websites. Wiley.
      • Harold & Means. 2004. XML in a Nutshell (3rd Ed). O'Reilly.
      • Ward, Patricia, 2nd Edition September 2008, Database Management Systems, Cengage, ISBN 978-1-40800-768-6.
      • Beighley, Lynn, SQL Head First SQL, O'Reiley ISBN 0-596-52684-9.

    • Unihub/Moodle: Access module handbooks, lecture slides, exercises, and tests via Unihub → My Learning → My Learning (https://myunihub.mdx.ac.uk).

    Module Content

    • The module investigates efficient and effective ways of managing information in organisations. This includes:

      • What data and information needs to be stored?
      • How to store data?
      • How to model relationships between data?
      • How to manage data?
      • How to query data to retrieve information?
      • How to present information?

    • Mini-world use case: Middlesex University recruits 10,000 students yearly. Each student can enroll in multiple modules, and each module is led by a lecturer. Information to store includes student ID, name, date of birth, program, staff details, module information, program details, school details, and department details.

    Managing Information

    • File-based approach: Early attempts to computerize manual filing. Each program manages its own data, leading to potential issues as described below.
    • Database approach: A shared collection of logically related data, designed to meet organisational information needs. This is more manageable than individual program files, with the help of Database Management Systems (DBMS).

    Problems with File-Based Approach

    • Isolation of data: Data is separated, making it difficult to access data across different programs. This makes it challenging to answer complex questions like if a customer has ordered more than 10 items and bought more than 5.
    • Duplication of data: Redundant storage of data across different programs. This wastes time, money, and storage space.
    • Incompatible file formats: File structures are embedded into application programs, leading to compatibility issues. Query results and reports are difficult to produce across programs with varying formats.
    • Fixed queries: queries or reports that can be produced are limited by the way the data is structured in the files.

    Database Management System (DBMS) overview

    • DBMS is software that enables users to define, create, maintain, and control access to a database.
    • DBMS software and data make up the database system.

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Related Documents

    CST 1340 Information in Organisations - Module Introduction PDF

    Description

    Explore the key aspects of the CST 1340 module that focuses on information management in organizations. Understand the attendance policy, resources, and essential readings necessary for success in the course. This quiz will help you review critical policies and support systems available to students.

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser