際際滷

際際滷Share a Scribd company logo
DATABASE MANAGEMENT
      SYSTEM




     LECTURE 2

                      DBMS02
DBMS
際際滷 2
際際滷 2
際際滷 2
DBMS
              Command
           Tools


     -
     -

     -

     -

際際滷 2
1.
      2.
      3.
      4.
      5.


      6.
      7.
      8.

際際滷 2
DATA MODEL



             -

             -

             -
際際滷 2
(Relational
              Database Model)




          -
際際滷 2
(Relational
                     Database Model)  Table
                                    Relation
                                  Row
          (Column)
      Dept_ Dept_nam           Location
       no         e
Department Administrati
        1                      Sathorn
                                               row
            on
        2   Shipping           Silom
        3   Sales              Silom
        4   Marketing          Bangpo
        5   Accounting         Sathorn
際際滷 2                  column
Table

 1.


 2.




 3.
          (

              )
際際滷 2
Department




          Department



際際滷 2

                Table       Department
                                     Location
                Silom
      =>>
                 2      Shippin Silom
                        g
                 3      Sales   Silom
            2                               Location
           Silom
   Dept_name                     Sales
  =>>
                  3      Sales      Silom

際際滷 2
3
      Location            Silom
      Dept_no             3
      Dept_name
      =>>                    Sales
              3   Sales     Silom


         4
   Dept_name                 Sales
  =>>

              3   Sales     Silom

際際滷 2
Dept_no               3
=>>
          3   Sales       Silom
NOTE




際際滷 2
-         Key -
-

               Identify

-


-
    NOTE
    -
                 Unique
    -                     Null
際際滷 2
Invoice
  No   Inv_No   Amout   Prod_id
  1       221    230      A1
  2       221    450      B4
  3       221    450      D1
  1       224    125      B1
  2       224    300      A2
  1       225    300      B1
  2       225    300      A1
Candidate Key
                Identify



                            Candidate Key
                      Candidate Key
                     Primary Key
               Candidate Key
                  Candidate Key
                           Primary Key
          Candidate Key
際際滷 2         Alternate Key
Primary Key / PK


          Null)

                             PK




際際滷 2
>>   Column

際際滷 2
NOTE




際際滷 2
Secondary Key
                                Single
          or Composite Key




                 Foreign Key




際際滷 2
Department
Dept   Dept_na      Loca
_no      me         tion
  1    Administra   Satho                  Pimon
       tion         rn
  2    Shipping     Silom
  3    Sales        Silom
  4    MarketingBang
Employee        po      Karoon
 5ID Accounting Satho
        Name     Positio Salary MGR_ID     Dept_no
                rn n
 111     Satit      MD       95000            1
 112     Ladda      Manage   58000   111      1
                    r
 212     Pimon      Manage   47000   111      2
                    r
 312     Tida       Manage   25000   111      3
                    r
 313     Sansiri    Clerk    12500   112      1
際際滷 2

More Related Content

Featured (20)

2024 Trend Updates: What Really Works In SEO & Content Marketing
2024 Trend Updates: What Really Works In SEO & Content Marketing2024 Trend Updates: What Really Works In SEO & Content Marketing
2024 Trend Updates: What Really Works In SEO & Content Marketing
Search Engine Journal
Storytelling For The Web: Integrate Storytelling in your Design Process
Storytelling For The Web: Integrate Storytelling in your Design ProcessStorytelling For The Web: Integrate Storytelling in your Design Process
Storytelling For The Web: Integrate Storytelling in your Design Process
Chiara Aliotta
Artificial Intelligence, Data and Competition SCHREPEL June 2024 OECD dis...
Artificial Intelligence, Data and Competition  SCHREPEL  June 2024 OECD dis...Artificial Intelligence, Data and Competition  SCHREPEL  June 2024 OECD dis...
Artificial Intelligence, Data and Competition SCHREPEL June 2024 OECD dis...
OECD Directorate for Financial and Enterprise Affairs
How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...
How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...
How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...
SocialHRCamp
2024 State of Marketing Report by Hubspot
2024 State of Marketing Report  by Hubspot2024 State of Marketing Report  by Hubspot
2024 State of Marketing Report by Hubspot
Marius Sescu
Everything You Need To Know About ChatGPT
Everything You Need To Know About ChatGPTEverything You Need To Know About ChatGPT
Everything You Need To Know About ChatGPT
Expeed Software
Product Design Trends in 2024 | Teenage Engineerings
Product Design Trends in 2024 | Teenage EngineeringsProduct Design Trends in 2024 | Teenage Engineerings
Product Design Trends in 2024 | Teenage Engineerings
Pixeldarts
How Race, Age and Gender Shape Attitudes Towards Mental Health
How Race, Age and Gender Shape Attitudes Towards Mental HealthHow Race, Age and Gender Shape Attitudes Towards Mental Health
How Race, Age and Gender Shape Attitudes Towards Mental Health
ThinkNow
AI Trends in Creative Operations 2024 by Artwork Flow.pdf
AI Trends in Creative Operations 2024 by Artwork Flow.pdfAI Trends in Creative Operations 2024 by Artwork Flow.pdf
AI Trends in Creative Operations 2024 by Artwork Flow.pdf
marketingartwork
Skeleton Culture Code
Skeleton Culture CodeSkeleton Culture Code
Skeleton Culture Code
Skeleton Technologies
PEPSICO Presentation to CAGNY Conference Feb 2024
PEPSICO Presentation to CAGNY Conference Feb 2024PEPSICO Presentation to CAGNY Conference Feb 2024
PEPSICO Presentation to CAGNY Conference Feb 2024
Neil Kimberley
Content Methodology: A Best Practices Report (Webinar)
Content Methodology: A Best Practices Report (Webinar)Content Methodology: A Best Practices Report (Webinar)
Content Methodology: A Best Practices Report (Webinar)
contently
How to Prepare For a Successful Job Search for 2024
How to Prepare For a Successful Job Search for 2024How to Prepare For a Successful Job Search for 2024
How to Prepare For a Successful Job Search for 2024
Albert Qian
Social Media Marketing Trends 2024 // The Global Indie Insights
Social Media Marketing Trends 2024 // The Global Indie InsightsSocial Media Marketing Trends 2024 // The Global Indie Insights
Social Media Marketing Trends 2024 // The Global Indie Insights
Kurio // The Social Media Age(ncy)
Trends In Paid Search: Navigating The Digital Landscape In 2024
Trends In Paid Search: Navigating The Digital Landscape In 2024Trends In Paid Search: Navigating The Digital Landscape In 2024
Trends In Paid Search: Navigating The Digital Landscape In 2024
Search Engine Journal
5 Public speaking tips from TED - Visualized summary
5 Public speaking tips from TED - Visualized summary5 Public speaking tips from TED - Visualized summary
5 Public speaking tips from TED - Visualized summary
SpeakerHub
ChatGPT and the Future of Work - Clark Boyd
ChatGPT and the Future of Work - Clark Boyd ChatGPT and the Future of Work - Clark Boyd
ChatGPT and the Future of Work - Clark Boyd
Clark Boyd
Getting into the tech field. what next
Getting into the tech field. what next Getting into the tech field. what next
Getting into the tech field. what next
Tessa Mero
Google's Just Not That Into You: Understanding Core Updates & Search Intent
Google's Just Not That Into You: Understanding Core Updates & Search IntentGoogle's Just Not That Into You: Understanding Core Updates & Search Intent
Google's Just Not That Into You: Understanding Core Updates & Search Intent
Lily Ray
How to have difficult conversations
How to have difficult conversations How to have difficult conversations
How to have difficult conversations
Rajiv Jayarajah, MAppComm, ACC
2024 Trend Updates: What Really Works In SEO & Content Marketing
2024 Trend Updates: What Really Works In SEO & Content Marketing2024 Trend Updates: What Really Works In SEO & Content Marketing
2024 Trend Updates: What Really Works In SEO & Content Marketing
Search Engine Journal
Storytelling For The Web: Integrate Storytelling in your Design Process
Storytelling For The Web: Integrate Storytelling in your Design ProcessStorytelling For The Web: Integrate Storytelling in your Design Process
Storytelling For The Web: Integrate Storytelling in your Design Process
Chiara Aliotta
How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...
How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...
How to Leverage AI to Boost Employee Wellness - Lydia Di Francesco - SocialHR...
SocialHRCamp
2024 State of Marketing Report by Hubspot
2024 State of Marketing Report  by Hubspot2024 State of Marketing Report  by Hubspot
2024 State of Marketing Report by Hubspot
Marius Sescu
Everything You Need To Know About ChatGPT
Everything You Need To Know About ChatGPTEverything You Need To Know About ChatGPT
Everything You Need To Know About ChatGPT
Expeed Software
Product Design Trends in 2024 | Teenage Engineerings
Product Design Trends in 2024 | Teenage EngineeringsProduct Design Trends in 2024 | Teenage Engineerings
Product Design Trends in 2024 | Teenage Engineerings
Pixeldarts
How Race, Age and Gender Shape Attitudes Towards Mental Health
How Race, Age and Gender Shape Attitudes Towards Mental HealthHow Race, Age and Gender Shape Attitudes Towards Mental Health
How Race, Age and Gender Shape Attitudes Towards Mental Health
ThinkNow
AI Trends in Creative Operations 2024 by Artwork Flow.pdf
AI Trends in Creative Operations 2024 by Artwork Flow.pdfAI Trends in Creative Operations 2024 by Artwork Flow.pdf
AI Trends in Creative Operations 2024 by Artwork Flow.pdf
marketingartwork
PEPSICO Presentation to CAGNY Conference Feb 2024
PEPSICO Presentation to CAGNY Conference Feb 2024PEPSICO Presentation to CAGNY Conference Feb 2024
PEPSICO Presentation to CAGNY Conference Feb 2024
Neil Kimberley
Content Methodology: A Best Practices Report (Webinar)
Content Methodology: A Best Practices Report (Webinar)Content Methodology: A Best Practices Report (Webinar)
Content Methodology: A Best Practices Report (Webinar)
contently
How to Prepare For a Successful Job Search for 2024
How to Prepare For a Successful Job Search for 2024How to Prepare For a Successful Job Search for 2024
How to Prepare For a Successful Job Search for 2024
Albert Qian
Social Media Marketing Trends 2024 // The Global Indie Insights
Social Media Marketing Trends 2024 // The Global Indie InsightsSocial Media Marketing Trends 2024 // The Global Indie Insights
Social Media Marketing Trends 2024 // The Global Indie Insights
Kurio // The Social Media Age(ncy)
Trends In Paid Search: Navigating The Digital Landscape In 2024
Trends In Paid Search: Navigating The Digital Landscape In 2024Trends In Paid Search: Navigating The Digital Landscape In 2024
Trends In Paid Search: Navigating The Digital Landscape In 2024
Search Engine Journal
5 Public speaking tips from TED - Visualized summary
5 Public speaking tips from TED - Visualized summary5 Public speaking tips from TED - Visualized summary
5 Public speaking tips from TED - Visualized summary
SpeakerHub
ChatGPT and the Future of Work - Clark Boyd
ChatGPT and the Future of Work - Clark Boyd ChatGPT and the Future of Work - Clark Boyd
ChatGPT and the Future of Work - Clark Boyd
Clark Boyd
Getting into the tech field. what next
Getting into the tech field. what next Getting into the tech field. what next
Getting into the tech field. what next
Tessa Mero
Google's Just Not That Into You: Understanding Core Updates & Search Intent
Google's Just Not That Into You: Understanding Core Updates & Search IntentGoogle's Just Not That Into You: Understanding Core Updates & Search Intent
Google's Just Not That Into You: Understanding Core Updates & Search Intent
Lily Ray

Week2 dbms

  • 1. DATABASE MANAGEMENT SYSTEM LECTURE 2 DBMS02
  • 5. DBMS Command Tools - - - - 際際滷 2
  • 6. 1. 2. 3. 4. 5. 6. 7. 8. 際際滷 2
  • 7. DATA MODEL - - - 際際滷 2
  • 8. (Relational Database Model) - 際際滷 2
  • 9. (Relational Database Model) Table Relation Row (Column) Dept_ Dept_nam Location no e Department Administrati 1 Sathorn row on 2 Shipping Silom 3 Sales Silom 4 Marketing Bangpo 5 Accounting Sathorn 際際滷 2 column
  • 10. Table 1. 2. 3. ( ) 際際滷 2
  • 11. Department Department 際際滷 2
  • 12. Table Department Location Silom =>> 2 Shippin Silom g 3 Sales Silom 2 Location Silom Dept_name Sales =>> 3 Sales Silom 際際滷 2
  • 13. 3 Location Silom Dept_no 3 Dept_name =>> Sales 3 Sales Silom 4 Dept_name Sales =>> 3 Sales Silom 際際滷 2
  • 14. Dept_no 3 =>> 3 Sales Silom
  • 16. - Key - - Identify - - NOTE - Unique - Null 際際滷 2
  • 17. Invoice No Inv_No Amout Prod_id 1 221 230 A1 2 221 450 B4 3 221 450 D1 1 224 125 B1 2 224 300 A2 1 225 300 B1 2 225 300 A1
  • 18. Candidate Key Identify Candidate Key Candidate Key Primary Key Candidate Key Candidate Key Primary Key Candidate Key 際際滷 2 Alternate Key
  • 19. Primary Key / PK Null) PK 際際滷 2
  • 20. >> Column 際際滷 2
  • 22. Secondary Key Single or Composite Key Foreign Key 際際滷 2
  • 23. Department Dept Dept_na Loca _no me tion 1 Administra Satho Pimon tion rn 2 Shipping Silom 3 Sales Silom 4 MarketingBang Employee po Karoon 5ID Accounting Satho Name Positio Salary MGR_ID Dept_no rn n 111 Satit MD 95000 1 112 Ladda Manage 58000 111 1 r 212 Pimon Manage 47000 111 2 r 312 Tida Manage 25000 111 3 r 313 Sansiri Clerk 12500 112 1