Scribd Logo
Upload

Welcome to Scribd!

  • 133 views

    LAB ACTIVITY 1: Fundamentals of Database Management System: Duration: 4 Hours Learning Outcomes

    Uploaded by

    rosdi jkm
    This lab activity covers fundamentals of database management systems (DBMS) over 4 hours. Students will learn to define a DBMS, identify common DBMS types, and explain DBMS features. Activities include defining databases and DBMS, listing examples of open source and licensed DBMS, describing DBMS features, schemas and architectures, and discussing the contributions of databases to society and business.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    LAB ACTIVITY 1: Fundamentals of Database Management System: Duration: 4 Hours Learning Outcomes

    Uploaded by

    rosdi jkm
    133 views9 pages
    This lab activity covers fundamentals of database management systems (DBMS) over 4 hours. Students will learn to define a DBMS, identify common DBMS types, and explain DBMS features. Activities include defining databases and DBMS, listing examples of open source and licensed DBMS, describing DBMS features, schemas and architectures, and discussing the contributions of databases to society and business.

    Original Description:

    thfhtrhtrhtr

    Original Title

    wegergrh

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This lab activity covers fundamentals of database management systems (DBMS) over 4 hours. Students will learn to define a DBMS, identify common DBMS types, and explain DBMS features. Activities include defining databases and DBMS, listing examples of open source and licensed DBMS, describing DBMS features, schemas and architectures, and discussing the contributions of databases to society and business.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    133 views9 pages

    LAB ACTIVITY 1: Fundamentals of Database Management System: Duration: 4 Hours Learning Outcomes

    Uploaded by

    rosdi jkm
    This lab activity covers fundamentals of database management systems (DBMS) over 4 hours. Students will learn to define a DBMS, identify common DBMS types, and explain DBMS features. Activities include defining databases and DBMS, listing examples of open source and licensed DBMS, describing DBMS features, schemas and architectures, and discussing the contributions of databases to society and business.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 9

    LAB ACTIVITY 1: Fundamentals of Database

    Management System
    Duration: 4 Hours

    Learning Outcomes
    This activity encompasses activities 1A, 1B and 1C.

    By the end of this tutorial session, you should be able to:


    1. Define Database Management System (DBMS)
    2. Identify various common DBMS.
    3. Explain the common features of DMBS

    Activity 1A
    Activity Outcome: Define Database Management System (DBMS).

    Briefly explain in your own words the definitions below.

    Database

    ~ A collection of information that is organized so that it can be easy


    accessed, managed and updated.

    Database Management System

    ~ Collection of components that support data acquisition, dissemination,


    storage, maintenance, retrieval and formatting

    ~ A set of software programs that allows users to create, edit and update
    data in database files, and store and retrieve data from those database
    files.
    Activity 1B
    Activity Outcome: Identify various common DBMS.

    In group of two, list the common DMBS use in database management.

    Open Source Software


    MySQL
    • __________________________________

    SQLite
    • __________________________________

    FirebirdSQL
    • __________________________________

    PostgreSQL
    • __________________________________

    Licence software
    Amazon RDS
    • ___________________________________

    Microsoft SQL Server


    • ___________________________________

    IBM db2
    • ___________________________________

    Oracle
    • ___________________________________
    Activity 1C
    Activity Outcome: Explain the common features of DBMS

    Briefly explain the following common features of DBMS.

    ~ Language and graphical tools to define


    Database entities, relationships, integrity constraints
    definition and authorization rights.

    ~ Language and graphical tools to access


    Nonprocedural data without complicated coding
    access

    ~ Graphical tools to develop menus, data entry


    Application forms, and reports data requirements for
    development forms and reports are specified using
    nonprocedural access

    ~ Language that combines nonprocedural


    Procedural access with full capabilities of a programming
    language interface language

    ~ Control mechanisms to prevent interference


    Transaction from simultaneous users and recover lost
    Processing data after a failure

    ~ Tools to monitor and improve database


    performance
    Database tuning
    Activity 1D
    Activity Outcome: Identify the three-schema architecture of DBMS.

    1. Three-schema architecture also known as ANSI-SPARC architecture. What does ANSI-


    SPARC stand for?

    ANSI-SPARC is American National Standards Institute, Standards


    Planning And Requirements Committee

    2. Write the correct schema for the explanation given.

    o User’s view of database.


    o Describes the part of the database that a particular user Answer:
    group is interested in
    o Hides the rest of the database from that user group. External level
    ________________
    o Excludes irrelevant data as well as data which ________________
    the user is not authorized to access. ________________
    o Written in the Data Definition Language _______________

    o This schema concern in : Answer:


     Storage space allocation for data and indexes
     Record description for storage Internal level
    ________________
     Record placement ________________
     Data compression and data encryption technique ________________
    _______________

    o Community view of database.


    o Hides the details of physical storage structures Answer:
    o Describes what data is stored in database and Conceptual level
    relationships among the data. ________________
    o Doesn’t specify how the data is physically stored. ________________
    o Only DBA define and works at this level. ________________
    _______________
    Based on the diagram given, fill in the blanks with the correct schema.

    End Users

    External Level External view ... External view

    External/Conceptual
    mapping
    Conceptual Level
    Conceptual Schema
    Conceptual/Internal
    mapping

    Internal Level
    Internal Schema
    Activity 1E
    Activity Outcome: Describe the client-server architecture of DBMS.

    In group of two, briefly explain about types of client server architecture below:

    Client-Server architecture

    ~ Client-Server architecture is a network architecture in which each


    computer or process on the network is either a client or a server.
    ~ Servers are powerful computers or processes dedicated to managing
    disk drives (file servers), printers (print servers), or network traffic
    (network servers). Clients are PCs or workstations on which users run
    applications. Clients rely on servers for ~ resources, such as files,
    devices and even processing power.

    File-Server architecture

    ~ A file-server is a computer that is connected to a network and mainly


    serves as a shared storage.
    ~ In the file-server architecture, the processing is distributed over the
    network. Workstation (application and DBMS) must request data
    before they can get database. Since the file-server is not SQL-aware,
    the customer and Order relation (files) have to be transferred to the
    client.

    Database-Server architecture

    ~ A database server provides the data requested by an application server


    on behalf of a client. The database server does all of the remaining
    query processing.

    Three Tier architecture

    ~ A three-tier architecture is a client-server architecture in which the


    functional process logic, data access, computer data storage and
    user interface are developed and maintained as independent modules
    on separate platforms.
    ~ It is a software design pattern and a well-established software
    architecture.
    Activity 1F
    Activity Outcome: Identify the two categories of DBMS.

    Based on the list of database software below, you are required to identify the categories of
    DBMS for each of database software.

    No Database Software Categories of DBMS

    Server database
    1 Oracle

    2 Microsoft Access Desktop database

    3 Paradox Desktop database

    4 Microsoft SQL Server


    Server database

    5 Lotus Desktop database

    6 FoxPro Desktop database

    7 DB2 Server database

    8 IBM Server database

    9 FileMaker Pro Desktop database


    Activity 1G
    Activity Outcome: Identify the contribution of database technology to the society.

    1. In groups of two, discuss and list the contribution of database technology to the society.

    Historical data can show your business trends.


    1. _________________________________ Business
    2. Sales records can identify valuable customers.
    _________________________________

    Reduce the amount of time you spend


    3. _________________________________
    managing data.
    4. _________________________________
    Improve the quality and consistency of
    information.

    Databases managed with a web browser enable


    1. the lecturer to collect data from the students
    _________________________________
    without the restrictions of time and space.
    2. Students can retrieve their course information
    _________________________________
    and marks.
    3. _________________________________
    Make easy the finance Unit to managed the
    finance and programmes fee
    4. Easy to managed the attandance student
    _________________________________
    management
    Education

    1. _________________________________
    Store and retrieve the election data easily
    Social Work
    and fast.
    Register and store data of flood victim or
    2. _________________________________
    any bad disaster in Malaysia.
    3. Make
    _________________________________
    easy to generate data analysis about
    financial aid recipient
    4. Make
    _________________________________
    easy to prepare the budget to
    distribution the financial aid to community

    You might also like