longquiz

    Cards (45)

    • What does DBMS stand for?

      Database Management System
    • What is the primary function of a DBMS?

      It helps people create and manage databases.
    • What does CRUD stand for in database management?

      Create, Read, Update, Delete
    • What does metadata refer to in the context of databases?

      It is the data about the data, defining what kind of data can be stored.
    • Who is a Sophisticated User in a database environment?

      A user who runs advanced queries to analyze or retrieve specific data.
    • Why is the Filesystem not considered part of the database environment?

      Because the focus is more on elements like data, procedures, and people.
    • What is a key advantage of a Distributed Database?

      Data can be accessed faster and is more readily available.
    • What is Operational Data used for?

      Day-to-day operations, like customer transactions.
    • What is the purpose of a DBMS?

      DBMS is software that helps people create and manage databases by organizing data so it can be easily accessed or updated
    • What does CRUD stand for?

      Create, Read, Update, and Delete
    • What are the four main operations that can be performed on a database using CRUD?

      Creating new data, reading/retrieving existing data, updating data, and deleting data
    • What is metadata?

      Metadata is data about the data, such as defining what type of data can be stored in a database field
    • What are the different types of database users?
      Database users include sophisticated users who run advanced queries, as well as other types of users with varying levels of expertise
    • What is not considered part of the database environment?

      The filesystem
    • What is the main advantage of a distributed database?

      Data can be accessed faster and is more readily available, especially for large systems spread across different locations
    • What is operational data?

      Operational data is data used for day-to-day operations, such as customer transactions in a retail system
    • What is the purpose of a data warehouse?

      Data warehouses are designed to store large amounts of data for analysis, helping companies look at trends over time to make informed decisions
    • What is an example of a commonly used DBMS software?
      MySQL
    • How do enterprise databases differ from other databases?

      Enterprise databases are much larger and designed to manage complex operations across multiple departments
    • What is the role of a system administrator in managing databases?

      System administrators handle the physical servers and ensure the database environment is running smoothly
    • What is the purpose of procedures in a database system?

      Procedures are the rules that ensure data accuracy and security, such as only allowing authorized users to access sensitive information
    • What type of database would be ideal for a library system to track books and user information?

      A multitier client/server database
    • Why would a bank need a multiuser database?

      Because multiple tellers need to access customer records at the same time
    • What type of database would be best suited for a retail system that requires real-time data processing?

      An operational database
    • Why would a distributed database be a good choice for a system that needs to stay up even if one server fails?

      Because a distributed database spreads data across multiple locations, so the system can continue to function if one server goes down
    • What type of database would be best for a university's online student registration system?

      An internet database
    • Why would a multiuser database with specific views be beneficial for a company that needs to provide secure access for different teams?

      A multiuser database with specific views allows each team to see only the data they need, maintaining security and access control
    • What type of database would be best for a healthcare analyst to analyze patient data?

      A data warehouse
    • Why would an extranet database be the best choice for an organization that needs to share data securely with external partners?
      An extranet database allows for secure access to data while maintaining control and security, which is important when sharing information with external partners
    • What is the purpose of the planning phase in the System Development Life Cycle (SDLC)?

      The planning phase focuses on developing a feasibility report and project plan to ensure the system being developed is viable and aligned with business objectives
    • What is the key outcome of the design phase in the SDLC?
      The key outcome is the logical and physical database design, which outlines how the database will be structured and implemented to support the system's requirements
    • How does the Database Life Cycle (DBLC) relate to the SDLC?

      The DBLC mirrors many aspects of the SDLC, as both processes are designed to create, develop, and maintain information systems
    • What is the purpose of the planning phase in the Database Life Cycle (DBLC)?

      In the planning phase of the DBLC, high-level entities and relationships are defined, establishing a foundation for the database's structure
    • What is one of the core principles of database design?

      Normalization, which ensures that redundancy is reduced and data integrity is maintained, making databases efficient and reliable
    • What is the purpose of the primary key in a database?
      The primary key ensures that each record is unique, which is critical for maintaining data integrity and proper referencing between tables
    • What is the purpose of the maintenance phase in the SDLC?

      The maintenance phase involves regular updates and performance improvements to keep the system running efficiently and to address evolving needs
    • What is the focus of the analysis phase in the SDLC?

      The focus is on developing a detailed conceptual data model that captures the data needs of the organization
    • What is the purpose of the foreign key in a relational database?
      The foreign key links tables in a relational database to maintain relationships between datasets
    • What is the purpose of achieving Third Normal Form (3NF) in database design?

      Achieving 3NF ensures that all non-key columns depend only on the primary key, further promoting data integrity
    • What is the focus of the physical design phase in the Database Life Cycle (DBLC)?

      The physical design phase is where decisions regarding indexing and storage strategies are made to optimize how data is stored and accessed
    See similar decks