Scribd
Upload
284 views11 pages

Database: Icdl

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.

Uploaded by

Mohammad Edris Yawar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
284 views11 pages

Database: Icdl

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.

Uploaded by

Mohammad Edris Yawar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 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