Scribd Logo
Upload

Welcome to Scribd!

  • 3 views

    New DBS Overview Lecture

    Uploaded by

    thao.lephuong
    Overview

    Copyright:

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

    New DBS Overview Lecture

    Uploaded by

    thao.lephuong
    3 views16 pages
    Overview

    Original Title

    New-DBS-Overview-Lecture

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Overview

    Copyright:

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

    New DBS Overview Lecture

    Uploaded by

    thao.lephuong
    Overview

    Copyright:

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

    DATABASE SYSTEMS

    CONTACT
    qLecturer: Phan Trọng Nhân, PhD
    qFaculty: Computer Science and Engineering
    qDepartment: Information Systems
    qEmail: [email protected]
    qCourse Site: LMS

    8/23/2024 DATABASE SYSTEMS – C02013 2


    COURSE INTRODUCTION
    qSubject: Database Systems
    qNumber: CO2013
    qCredits: 4
    qLength: 45 units
    qPrerequisite: None
    qClass Periods: 15 weeks
    qCourse Syllabus

    8/23/2024 DATABASE SYSTEMS – C02013 3


    COURSE AIMS
    qThis course is to introduce
    oThe history and motivations for database systems
    oArchitecture and components of a database system
    oEntity relationship model and its extensions
    oData models and relational data model
    oRelational algebra and SQL
    oDatabase design methodologies
    oFunctional dependencies and data normalization
    oDatabase storage, management, and security
    oDatabase applications

    8/23/2024 DATABASE SYSTEMS – C02013 4


    LEARNING OUTCOMES (1/4)
    qL.O.1 – Explaining basic concepts (data, data model, database,
    database system, the relational data model, the relational algebra, SQL,
    database design methodology, the entity relationship model, data
    normalization, database application), understand the architecture of a
    database system, describe the components of a database system.
    oL.O.1.1 – Explain basic concepts: data, database, database system, architecture of a
    database system and components of a database system.
    oL.O.1.2 – Explain the relational data model, relational algebra, and SQL.
    oL.O.1.3 – Explain database design methodologies, entity relationship model, data
    normalization.
    oL.O.1.4 – Identify applications of database systems.

    8/23/2024 DATABASE SYSTEMS – C02013 5


    LEARNING OUTCOMES (2/4)
    qL.O.2 – Designing a database using the entity relationship model, the
    relational data model and a database design methodology to meet data
    requirements of a particular database application.
    oL.O.2.1 – Design a conceptual schema using the entity relationship model and its
    extended versions in such a way that data requirements of a given database
    application are satisfied.
    oL.O.2.2 – Develop a relational schema from a conceptual schema which is designed
    using the entity relationship model and its extended versions.
    oL.O.2.3 – Identify functional dependencies of a relation and define a key of a relation
    with given functional dependencies.
    oL.O.2.4 – Determine a normal form (1NF, 2NF, 3NF, BCNF) of a relation based on its
    given primary key and functional dependencies

    8/23/2024 DATABASE SYSTEMS – C02013 6


    LEARNING OUTCOMES (3/4)
    qL.O.3 – Using the SQL language and an existing database management
    system (DBMS) such as MySQL, Oracle, and MS SQL Server.
    oL.O.3.1 – Write data definition and manipulation (query, insertion, deletion, and
    update) statements as well as procedures/functions/triggers for data processing in
    SQL.
    oL.O.3.2 – Install and configure an existing database management system such as
    MySQL, Oracle, and MS SQL Server.
    oL.O.3.3 – Implement and manage databases for database applications on top of an
    existing database management system.
    oL.O.3.4 – Use basic security techniques such as authorization and user management
    on an existing database management system.

    8/23/2024 DATABASE SYSTEMS – C02013 7


    LEARNING OUTCOMES (4/4)
    qL.O.4 – Be able to analyze tradeoffs between usability, performance,
    security and constraints of resource and technology in order to identify
    an appropriate approach for data design and implementation (file based
    approach or database approach, relational data model or other data
    models, approaches for database management systems).
    oL.O.4.1 – Explain the characteristics that distinguish the database approach from the
    approach of programming with data files.
    oL.O.4.2 – Explain the concept of data independence and its importance in a database
    system.
    oL.O.4.3 – Evaluate appropriateness and effectiveness of database approaches, data
    models and database management systems for developing applications in an
    information system.

    8/23/2024 DATABASE SYSTEMS – C02013 8


    OUTLINE
    qChapter 1: Database Systems in Overview
    qChapter 2: Entity Relationship Model
    qChapter 3: Relational Model
    qChapter 4: Structured Query Language
    qChapter 5: Database Design Methodologies
    qChapter 6: Database Storage and Management
    qChapter 7: Database Security
    qChapter 8: Review and Open Research

    8/23/2024 DATABASE SYSTEMS – C02013 9


    TEXT BOOKS & REFERENCES (1/2)
    1. Fundamentals of Database Systems, 7th Edition – R. Elmasri & S.B. Navathe, AddisonWesley, 2016.
    2. Relational Database Systems: Language, Conceptual, Modeling and Design for Engineers, Suphamit
    Chittayasothorn, 2017.
    3. Database Systems – A Practical Approach to Design, Implementation, and Management, 6 th Edition – T.
    Connolly & C. Begg, Addison-Wesley, 2015.
    4. Database Systems Concepts, 6th Edition – A. Silberschatz, H.F. Korth & S. Sudarshan, McGraw-Hill, 2006.
    5. Database Systems – The Complete Book – H.G. Molina, J.D. Ullman & J. Widom, PrenticeHall, 2002.
    6. Data Warehousing Fundamentals for IT Professionals, 2nd Edition – P. Ponniah, Wiley, 2010.
    7. The Data Warehouse Toolkit, 3rd Edition – R. Kimball, M. Ross, Wiley, 2013.
    8. Building the Data Warehouse, 4td Edition – W. H. Inmon, Wiley, 2005.
    9. Database Systems Using Oracle – A Simplified Guide to SQL and PL/SQL, 2nd Edition - N. Shah, Prentice Hall,
    2005.
    10. Database Management Systems, 2nd Edition – R. Ramakrishnan & J. Gehrke, McGraw-Hill, 2001.
    11. Khai Phá Dữ Liệu và Kỹ Thuật Phân Lớp, Trần Minh Quang, NXB Đại Học Quốc Gia TP. HCM, 2020.

    8/23/2024 DATABASE SYSTEMS – C02013 10


    TEXT BOOKS & REFERENCES (2/2)

    8/23/2024 DATABASE SYSTEMS – C02013 11


    ASSESSMENT
    qNo Midterm Test qFinal Test (T)
    qSeminar (S) oWeight: 50%
    oWeight: 20% oQuizzes and written test: 90
    oGrouping: 4-5 members per group minutes
    qPractice (P)
    oWeight: 30%

    èFinal Score = (20% * S) + (30% * P) + (50% * T)


    èAND No Nullable scores
    8/23/2024 DATABASE SYSTEMS – C02013 12
    SEMINAR (1/2)
    qForming a group
    o4-5 members
    qChoosing a non-identical topic
    qRegistration link on LMS
    qRegistration due date: 11pm 08/09/2024

    8/23/2024 DATABASE SYSTEMS – C02013 13


    SEMINAR (2/2)
    qSubmitting a 10-20’ video to LMS before 11pm 11 Nov. 2024
    qMaking a summary presentation as scheduled (Week 12-14)
    o20-25 min presentation for each group
    oFocus on the highlight of the topics
    vWhat? (1.5 points)
    vHow? (4 points)
    vWhy is it useful? (1.5 points)
    vDemo with a case study (3 points)

    8/23/2024 DATABASE SYSTEMS – C02013 14


    SOFTWARES
    qOracle DB Express Edition 21c
    qOracle SQL Developer
    qDraw.io
    qLatest version softwares or alternatives are
    welcome

    8/23/2024 DATABASE SYSTEMS – C02013 15


    QUESTIONS AND ANSWERS

    Picture from: http://philadelphiasculpturegym.blogspot.com/2013/09/save-date-free-talk-and-q-on-affordable.html

    8/23/2024 DATABASE SYSTEMS – C02013 16

    You might also like