06026110 , 06016308, 06016217 DATABASE SYSTEM CONCEPT 2564

Home / Class / DATABASE SYSTEM CONCEPT 2564

Course Code

06026110 , 06016308, 06016217

Open Date

January 5th 2023 00:00

Close Date

January 8th 2023 00:00

Instructor


TA

Tag

SQL , Transaction Management Concepts , Normalizaton , DBMS , Entity Relationship Model , Extend Entity Relaitonship Model , Database Logical Design

Chapter Playground   

  • 1

    Lab Playground

  • 2

    Lab Playground- Aggregate function

  • 3

    Playground - Relational Algebra

  • 4

    Database Design Tool Link

  • 5

    Conceptual ER Tool: Playlist

  • 6

    Scoring guideline for ER and Logical models

  • 7

    ER tool manual

  • 8

    Logical Design Tool: example

  • 9

    Tuition Playground

  • 10

    Ag#12 Playground

Chapter Admin   

  • 1

    Untitled Topic

Section 1

  • 1697

    2564-LAB01-ER-Modelling

  • 1730

    2564-LAB02-EER modelling

  • 1702

    2564-LAB03-ER Mapping

  • 1710

    2564-LAB04-EER Mapping

  • 1714

    Optional Lab1: Conceptual Design Practice-ER modeling

  • 1741

    Optional Lab3-Conceptual design practice: EER modelling

  • 1748

    Optional Lab 4 - ER Mapping

  • 1752

    Optional Lab5-EER mapping

  • 1780

    Optioanal Lab 6: EER Model

  • 1784

    Optional Lab 7: EER Mapping

  • 1792

    Optional Lab 8: from Assignments

Section 2

  • 1698

    2564-LAB01-ER-Modelling

  • 1731

    2564-LAB02-EER modelling

  • 1703

    2564-LAB03-ER Mapping

  • 1711

    2564-LAB04-EER Mapping

  • 1715

    Optional Lab1: Conceptual Design Practice-ER modeling

  • 1742

    Optional Lab3-Conceptual design practice: EER modelling

  • 1749

    Optional Lab 4 - ER Mapping

  • 1753

    Optional Lab5-EER mapping

  • 1781

    Optioanal Lab 6: EER Model

  • 1785

    Optional Lab 7: EER Mapping

  • 1793

    Optional Lab 8: from Assignments

Section 3

  • 1699

    2564-LAB01-ER-Modelling

  • 1732

    2564-LAB02-EER modelling

  • 1704

    2564-LAB03-ER Mapping

  • 1712

    2564-LAB04-EER Mapping

  • 1716

    Optional Lab1: Conceptual Design Practice-ER modeling

  • 1743

    Optional Lab3-Conceptual design practice: EER modelling

  • 1750

    Optional Lab 4 - ER Mapping

  • 1754

    Optional Lab5-EER mapping

  • 1782

    Optioanal Lab 6: EER Model

  • 1786

    Optional Lab 7: EER Mapping

  • 1794

    Optional Lab 8: from Assignments

Section 4

  • 1458

    2564-LAB01-ER-Modelling

  • 1442

    2564-LAB01-DDL-Creating and managing tables

  • 1450

    2564-LAB02-DDL-Including constraints

  • 1462

    2564-LAB03-RelationalAlgebra-1

  • 1486

    2564-LAB05-SQL SELECT

  • 1494

    2564-LAB06-SQL JOIN

  • 1502

    2564-LAB07-SQL OUTER JOIN

  • 1510

    2564-LAB08-SQL GROUP FUNCTION

  • 1518

    2564-LAB09-SQL SUBQUERIES

  • 1526

    2564-LAB10-Data Manipulation Language

Section 5

  • 1459

    2564-LAB01-ER-Modelling

  • 1443

    2564-LAB01-DDL-Creating and managing tables

  • 1451

    2564-LAB02-DDL-Including constraints

  • 1463

    2564-LAB03-RelationalAlgebra-1

  • 1487

    2564-LAB05-SQL SELECT

  • 1495

    2564-LAB06-SQL JOIN

  • 1503

    2564-LAB07-SQL OUTER JOIN

  • 1511

    2564-LAB08-SQL GROUP FUNCTION

  • 1519

    2564-LAB09-SQL SUBQUERIES

  • 1527

    2564-LAB10-Data Manipulation Language

Section 6

  • 1444

    2564-LAB01-DDL-Creating and managing tables

  • 1452

    2564-LAB02-DDL-Including constraints

  • 1464

    2564-LAB03-RelationalAlgebra-1

  • 1496

    2564-LAB06-SQL JOIN

  • 1504

    2564-LAB07-SQL OUTER JOIN

  • 1512

    2564-LAB08-SQL GROUP FUNCTION

  • 1520

    2564-LAB09-SQL SUBQUERIES

  • 1528

    2564-LAB10-Data Manipulation Language

Section 7

  • 1700

    2564-LAB01-ER-Modelling

  • 1733

    2564-LAB02-EER modelling

  • 1705

    2564-LAB03-ER Mapping

  • 1713

    2564-LAB04-EER Mapping

  • 1717

    Optional Lab1: Conceptual Design Practice-ER modeling

  • 1751

    Optional Lab 4 - ER Mapping

  • 1755

    Optional Lab5-EER mapping

  • 1787

    Optional Lab 7: EER Mapping

  • 1795

    Optional Lab 8: from Assignments

  • 1829

    Optional Lab 9: WH Design-COVID-19 Pandemic

  • 1830

    Optional Lab 10: From Assignment: Distribution Center

Section 8

  • 1445

    2564-LAB01-DDL-Creating and managing tables

  • 1453

    2564-LAB02-DDL-Including constraints

  • 1465

    2564-LAB03-RelationalAlgebra-1

  • 1489

    2564-LAB05-SQL SELECT

  • 1497

    2564-LAB06-SQL JOIN

  • 1505

    2564-LAB07-SQL OUTER JOIN

  • 1513

    2564-LAB08-SQL GROUP FUNCTION

  • 1521

    2564-LAB09-SQL SUBQUERIES

  • 1529

    2564-LAB10-Data Manipulation Language

Section 9

  • No Practice Available

Section 1

  • 1734

    Assignment Lab_01: Conceptual modeling

  • 1756

    Assignment Lab_02: Logical design

Section 2

  • 1736

    Assignment Lab_01: Conceptual modeling

  • 1757

    Assignment Lab_02: Logical design

Section 3

  • 1737

    Assignment Lab_01: Conceptual modeling

  • 1758

    Assignment Lab_02: Logical design

Section 4

  • 1446

    2564-LAB01-DDL-Creating and managing tables

  • 1454

    2564-LAB02-DDL-Including constraints

  • 1466

    2564-LAB03-Relational Algebra 1

  • 1474

    2564-LAB04-Relational Algebra 2

  • 1535

    2564-LAB05-SQL SELECT

  • 1498

    2564-LAB06-SQL JOIN

  • 1506

    2564-LAB07-SQL OUTER JOIN

  • 1514

    2564-LAB08-SQL GROUP FUNCTION

  • 1522

    2564-LAB09-SQL SUBQUERIES

  • 1530

    2564-LAB10-Data Manipulation Language

Section 5

  • 1447

    2564-LAB01-DDL-Creating and managing tables

  • 1455

    2564-LAB02-DDL-Including constraints

  • 1467

    2564-LAB03-Relational Algebra 1

  • 1475

    2564-LAB04-Relational Algebra 2

  • 1536

    2564-LAB05-SQL SELECT

  • 1499

    2564-LAB06-SQL JOIN

  • 1507

    2564-LAB07-SQL OUTER JOIN

  • 1515

    2564-LAB08-SQL GROUP FUNCTION

  • 1523

    2564-LAB09-SQL SUBQUERIES

  • 1531

    2564-LAB10-Data Manipulation Language

Section 6

  • 1448

    2564-LAB01-DDL-Creating and managing tables

  • 1456

    2564-LAB02-DDL-Including constraints

  • 1468

    2564-LAB03-Relational Algebra 1

  • 1476

    2564-LAB04-Relational Algebra 2

  • 1537

    2564-LAB05-SQL SELECT

  • 1500

    2564-LAB06-SQL JOIN

  • 1508

    2564-LAB07-SQL OUTER JOIN

  • 1516

    2564-LAB08-SQL GROUP FUNCTION

  • 1524

    2564-LAB09-SQL SUBQUERIES

  • 1532

    2564-LAB10-Data Manipulation Language

Section 7

  • 1738

    Assignment Lab_01: Conceptual modeling

  • 1759

    Assignment Lab_02: Logical design

  • 1818

    Assignment Lab_03: Warehouse design

Section 8

  • 1449

    2564-LAB01-DDL-Creating and managing tables

  • 1457

    2564-LAB02-DDL-Including constraints

  • 1469

    2564-LAB03-Relational Algebra 1

  • 1477

    2564-LAB04-Relational Algebra 2

  • 1534

    2564-LAB05-SQL SELECT

  • 1501

    2564-LAB06-SQL JOIN

  • 1509

    2564-LAB07-SQL OUTER JOIN

  • 1517

    2564-LAB08-SQL GROUP FUNCTION

  • 1525

    2564-LAB09-SQL SUBQUERIES

  • 1533

    2564-LAB10-Data Manipulation Language

Section 9

  • No Assignment Available

Section 1

  • No Quiz Available

Section 2

  • No Quiz Available

Section 3

  • No Quiz Available

Section 4

  • 1808

    กลุ่ม 4 Quiz 1-1

  • 1806

    กลุ่ม 4 Quiz 1-2

  • 1810

    กลุ่ม 4 Quiz 1-3

  • 1824

    กลุ่ม 4 Quiz 2-1

  • 1827

    กลุ่ม 4 Quiz 2-2

Section 5

  • 1800

    กลุ่ม 5 Quiz 1-1

  • 1801

    กลุ่ม 5 Quiz 1-2

  • 1811

    กลุ่ม 5 Quiz 1-3

  • 1823

    กลุ่ม 5 Quiz 2-1

  • 1825

    กลุ่ม 5 Quiz 2-2

Section 6

  • 1804

    กลุ่ม 6 Quiz 1-2

  • 1812

    กลุ่ม 6 Quiz 1-3

  • 1820

    กลุ่ม 6 Quiz 2-1

  • 1826

    กลุ่ม 6 Quiz 2-2

  • 1774

    กลุ่ม 6 Quiz 1-1

Section 7

  • 1833

    Final Exam 64

Section 8

  • No Quiz Available

Section 9

  • 1834

    run score _student

  • Optional Lab 7: EER Mapping

    Posted at 2022-03-05 15:24:27 by Srinual Nalintipwong

    Srinual Nalintippayawong posted a new optional lab: EER Mapping

  • New Optional Lab 6: EER Modelling

    Posted at 2022-03-05 15:18:19 by Srinual Nalintipwong

    Srinual Nalintippayawong posted a new optional lab 6: EER Modelling

  • Posted at 2022-02-09 19:05:16 by Srinual Nalintipwong

    Srinual Nalintippayawong posted a new assignment: LAB 02 - Logical modeling 

  • New Assignment Lab 01: Conceptual modeling

    Posted at 2022-01-26 20:08:28 by Srinual Nalintipwong

    Srinual Nalintippayawong posted a new assignment: LAB 01-Conceptual modeling - deadline Jan 29

  • มีการตรวจ Optional design Lab2 (Taxi system) ใหม่

    Posted at 2022-01-26 18:32:52 by Srinual Nalintipwong

    เฉลย lab ดังกล่าว relationship type "has" ของ Parking_area (Weak) ต้องเป็น  identifying relationship นะคะ

238 Members applied