Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 49 views

    Database: Icdl

    Uploaded by

    Mohammad Edris Yawar
    The document is a lecture on databases and database management systems (DBMS). It includes definitions of key database concepts like fields, data types, primary keys, and cardinality. It also discusses entity relationship (ER) diagrams and shows an example of creating an ER diagram for a library database. The diagram models the entities of books, authors, publishers, users, departments, and categories along with their attributes and relationships.

    Copyright:

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

    Database: Icdl

    Uploaded by

    Mohammad Edris Yawar
    49 views11 pages
    The document is a lecture on databases and database management systems (DBMS). It includes definitions of key database concepts like fields, data types, primary keys, and cardinality. It also discusses entity relationship (ER) diagrams and shows an example of creating an ER diagram for a library database. The diagram models the entities of books, authors, publishers, users, departments, and categories along with their attributes and relationships.

    Original Description:

    Original Title

    4th

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document is a lecture on databases and database management systems (DBMS). It includes definitions of key database concepts like fields, data types, primary keys, and cardinality. It also discusses entity relationship (ER) diagrams and shows an example of creating an ER diagram for a library database. The diagram models the entities of books, authors, publishers, users, departments, and categories along with their attributes and relationships.

    Copyright:

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

    Database: Icdl

    Uploaded by

    Mohammad Edris Yawar
    The document is a lecture on databases and database management systems (DBMS). It includes definitions of key database concepts like fields, data types, primary keys, and cardinality. It also discusses entity relationship (ER) diagrams and shows an example of creating an ER diagram for a library database. The diagram models the entities of books, authors, publishers, users, departments, and categories along with their attributes and relationships.

    Copyright:

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

    ICDL:

    Module 7 Database

    ‫بانک اطالعاتی‬

    Forth lecture Lecturer: Mahjube JamiulAhmadi


    29/05/2012
    ‫‪Quiz‬‬
    ‫‪ DBMS‬چیست ؟ با مثال‪.‬‬ ‫‪.1‬‬
    ‫‪ Fields‬چیست؟‬ ‫‪.2‬‬
    ‫چرا از ‪ Data Type‬استفاده میکنیم؟‬ ‫‪.3‬‬
    ‫‪ Primary Key‬چه خاصیتی باید داشته باشد؟‬ ‫‪.4‬‬
    ‫چند نوع ‪ Cardinality‬وجود دارد؟ نام ببرید‪.‬‬ ‫‪.5‬‬
    ‫برای ترسیم ‪ ER‬دیاگرام از چه اشکال هندسی میتوان‬ ‫‪.6‬‬
    ‫استفاده کرد؟ کاربرد هر یک را مشخص کنید‪.‬‬

    ‫‪2‬‬
    ‫ترسیم نمودار ارتباط موجودیت‬
    Creating of Entity Relation Diagram

    Library

    3
    Entities
    Author

    User Publisher
    Book

    Deportment Category

    4
    Entities & Attributes
    Title
    Book_ID Edition

    Publish_Year  Book Signatory

    Number_OF Language
    _Copy

    5
    Entities & Attributes

    Author ID
    First_Name

    Last_Name
    Author

    Publisher_ID Name

    Address Publisher
    6
    Entities & Attributes
    Category_ID
    Category

    Name

    Name

    Deportment Deportmentt_ID

    7
    Entities & Attributes
    First_Name
    Last_Name

    ID
    Father_Name

    Type
    User
    Birth_Year
    Semester

    Contact_ Number

    Email Gender

    8
    Relationships Author

    User Publisher
    Write

    Barrow

    Book Publish

    Member

    Have

    Deportment Category
    9
    Deportmentt
    _ID
    Author

    User Author
    N ID
    Publisher
    User_ Author_Book
    Write
    N ID
    M Book_
    Barrow
    Barrow
    M ID 1

    Book Publish
    Book_ N
    ID
    N Publisher
    _ID
    M
    Member
    Cat_Book
    Have
    1 N
    Category
    Deportment Category Book_
    10 _ID ID
    Complete ER Model 1 Author
    Deportment N
    D_ID Author_Book A_ID
    A_First_Name
    D_Name N ISBN
    User 1 A_ID A_Last_Name
    U_ID
    1 1
    U_First_Name Publisher
    N Book P_ID
    U_Last_Name N
    ISBN
    U_Father_Name P_Name
    Title
    U_Type 1 P_Address
    Edition
    U_Contact_NO P_Email
    Publish_Year
    Semester N P_Contact_NO
    Barrow Num_Of_Copy Cat_Book
    Contact_Number
    Barrow_ID Language ISBN
    U_Email
    Date_of_Barrow Signatory Cat_ID
    Gender
    Date_of_Return P_ID N
    Photo
    1 Category
    Is_Return
    D_ID
    ISBN Cat_ID
    1 1
    11 N U_ID N Cat_Name

    You might also like