Scribd Logo
Upload

Welcome to Scribd!

  • 82 views

    Homework 1: 1. What Is ? and Be Able To Give Example Diagram. A. Relational Model?

    Uploaded by

    dbircs for life
    This document provides definitions and examples of different data models: - The relational model uses relations consisting of columns and rows to structure data. The entity-relationship model describes database structure using entity relationship diagrams. The object-based model represents real world objects as isolated objects that can inherit functionality. The semi-structured model allows flexible data structures like XML. Hierarchical and network models organize data in tree-like or graph structures with single or multiple parent nodes.

    Copyright:

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

    Homework 1: 1. What Is ? and Be Able To Give Example Diagram. A. Relational Model?

    Uploaded by

    dbircs for life
    82 views5 pages
    This document provides definitions and examples of different data models: - The relational model uses relations consisting of columns and rows to structure data. The entity-relationship model describes database structure using entity relationship diagrams. The object-based model represents real world objects as isolated objects that can inherit functionality. The semi-structured model allows flexible data structures like XML. Hierarchical and network models organize data in tree-like or graph structures with single or multiple parent nodes.

    Original Title

    AC181-ITTOOLS-Homework-1 (1).docx

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides definitions and examples of different data models: - The relational model uses relations consisting of columns and rows to structure data. The entity-relationship model describes database structure using entity relationship diagrams. The object-based model represents real world objects as isolated objects that can inherit functionality. The semi-structured model allows flexible data structures like XML. Hierarchical and network models organize data in tree-like or graph structures with single or multiple parent nodes.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    82 views5 pages

    Homework 1: 1. What Is ? and Be Able To Give Example Diagram. A. Relational Model?

    Uploaded by

    dbircs for life
    This document provides definitions and examples of different data models: - The relational model uses relations consisting of columns and rows to structure data. The entity-relationship model describes database structure using entity relationship diagrams. The object-based model represents real world objects as isolated objects that can inherit functionality. The semi-structured model allows flexible data structures like XML. Hierarchical and network models organize data in tree-like or graph structures with single or multiple parent nodes.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 5

    Dianne Marie O.

    Ballon February 14,


    2020
    AC181 ITTOOLS
    Homework 1:
    1. What is …? and be able to give example diagram.
    a. relational model?
     The relational model is the conceptual basis of relational databases. it is a method
    of structuring data using relations, which are grid-like mathematical structures
    consisting of columns and rows.
    b. Entity-Relationship model?
     An Entity–relationship model (ER model) describes the structure of a database
    with the help of a diagram, which is known as Entity Relationship Diagram (ER
    Diagram). An ER model is a design or blueprint of a database that can later be
    implemented as a database.
    c. Object-based data models?
     It is a method of representing real world objects. It considers each object in the
    world as objects and isolates it from each other. It groups its related functionalities
    together and allows inheriting its functionality to other related sub-groups.
    d. Semi structured data model (XML)?
     The semi-structured data model is designed as an evolution of the relational data
    model that allows the representation of data with a flexible structure.
    e. Network and hierarchal model?
     Hierarchal model organises data into a tree-like-structure, with a single root, to
    which all the other data is linked. The heirarchy starts from the Root data, and
    expands like a tree, adding child nodes to the parent nodes. Network Model is an
    extension of the Hierarchical model. In this model data is organised more like a
    graph and are allowed to have more than one parent node. In this database model
    data is more related as more relationships are established in this database model.
    Also, as the data is more related, hence accessing the data is also easier and fast.
    This database model was used to map many-to-many data relationships.
    Example Diagrams
    a. relational model?

    b. Entity-Relationship model?

    c. Object-based data models?


    d. Semi structured data model (XML)?

    e. Network and hierarchal model?


    Network Model

    Hierarchal Model
    2. What is the difference between DDL and DML?
     The basic difference between DDL and DML is that DDL (Data Definition Language) is
    used to Specify the database schema database structure. On the other hand, DML (Data
    Manipulation Language) is used to access, modify or retrieve the data from the database. Let
    us discuss the differences between DDL and DML, with the help of comparison chart below.

    3. What is SQL?
     SQL stands for Structured Query Language. SQL is used to communicate with a database.
    According to ANSI (American National Standards Institute), it is the standard language for
    relational database management systems. SQL statements are used to perform tasks such as
    update data on a database or retrieve data from a database. Some common relational database
    management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access,
    Ingres, etc. The standard SQL commands such as "Select", "Insert", "Update", "Delete",
    "Create", and "Drop" can be used to accomplish almost everything that one needs to do with
    a database.
    Reference/s:
    DBMS Database Models. (n.d.). Retrieved from https://www.studytonight.com/dbms/database-
    model.php

    Rahul. (2020, January 7). Object based Data Models - Object Oriented Data Models -
    Advantages - Disadvantages. Retrieved from https://www.tutorialcup.com/dbms/object-based-
    data-models.htm

    Singh, C., Gurudevi, Gurudevi, Kumar, B., Kumar, B., Jahan, T., & Jahan, T. (2018, November
    16). Entity Relationship Diagram - ER Diagram in DBMS. Retrieved from
    https://beginnersbook.com/2015/04/e-r-model-in-dbms/

    Singh, A., Singh, A., David, Tithi, Tithi, Shivaam, … Manu. (2019, December 26). Difference
    Between DDL and DML in DBMS (with Comparison Chart). Retrieved from
    https://techdifferences.com/difference-between-ddl-and-dml-in-dbms.html

    SQLCourse. (2000, August 20). What is SQL? Retrieved from


    http://www.sqlcourse.com/intro.html

    Suciu, D. (1970, January 1). Semi-Structured Data Model. Retrieved from


    https://link.springer.com/referenceworkentry/10.1007/978-0-387-39940-9_337

    What is a Relational Model? - Definition from Techopedia. (n.d.). Retrieved from


    https://www.techopedia.com/definition/24559/relational-model-database

    You might also like