exam. 2 mis

Key Concepts in Database Design

  • Understanding the Process:

    • Before creating tables, identify the business problem. Understand what information is necessary to address that problem.

    • Example: Information about students, instructors, courses, and grades will inform the tables you create.

  • Creating Tables:

    • While creating tables, ensure each has a unique identifier (Primary Key).

      • Importance of a Primary Key: It allows the connection of tables and creates relationships, which is essential for data integrity.

    • Populate the tables with relevant data.

  • Creating Forms and Reports:

    • After establishing relationships between tables, you can create forms and set up queries to generate reports.

    • Note: Reports depend on queries; hence, create queries first before creating reports.

Supply Chain Models

  • Push-Based vs. Pull-Based Models:

    • Push-Based Model:

      • Definition: Involves making products based on forecasts, leading to potential surplus and needing discounts for unsold stock.

      • Risks: Inventory build-up can lead to losses if forecasts are incorrect.

    • Pull-Based Model:

      • Definition: Involves producing goods based on customer orders which minimizes inventory.

      • Advantages: Lower inventory and reduced costs, resulting in fewer problems with excess stock.

Communication Tools and Networks

  • Email: Used primarily for coordinating activities and scheduling meetings.

  • Groupware: Designed for collaborative tasks to share and edit documents (e.g., Microsoft Teams, Google Docs).

    • Benefits over email: Keeps track of document changes by multiple users, reducing versioning issues.

  • VPN (Virtual Private Network):

    • Definition: Secures communication when accessing the internet over public Wi-Fi by encrypting data.

    • Purpose: Protects sensitive information and ensures secure access.

  • Extranet vs Intranet:

    • Intranet: Internal access to company’s private internet for employees.

    • Extranet: Access for vendors to a company’s internal network for management purposes.

Network Basics

  • Switch: Connects multiple devices (computers, printers) within a local area network (LAN).

  • Router: Connects a network to the internet, enabling access to external networks.

Examination Preparation

  • Data Hierarchy:

    • Understand the structure that goes from bits to databases:

      • Bits → Bytes → Fields → Records → Files → Database.

  • Relational Databases: Use two-dimensional tables for organizing data.

Additional Technical Concepts

  • TCP/IP: Primary communication method for internet. Each device has a unique IP address, similar to a Social Security number.

  • Grid Computing: Connecting remote computers to function as a single supercomputer.

  • ERP Systems: A set of interdependent software modules aimed at integrating business processes, such as HR and accounting.

  • Data Warehouse vs Data Mart:

    • Data Warehouse: Central repository for collecting and managing data.

    • Data Mart: A subset of a data warehouse, focused on a particular business area.

  • Bandwidth: The frequency range a communication medium can support (specifically, the minimum and maximum).

  • Communication Protocols: Rules that govern how data is transmitted across networks (e.g., email delivery protocols).

Exam Logistics

  • Multiple Choice Format: Be prepared for questions on chapters and remember to bring necessary materials like a pencil and eraser.

  • Ensure clarity on concepts like push/pull supply chain models, client-server computing, and other technical details outlined above.