Page 15 - الحاسب الآلي ثانية إرشاد 2

‫أﻧﻈﻤﺔ ﻗﻮاﻋﺪ اﻟﺒﻴﺎﻧﺎت‬ ‫اﻟﻔﺼﻞ اﻷول‬

Entities

Attributes Fields ‫ﺨﺎﺼﺔ ﺒﻪ‬

Products Employees Orders

ProductID EmployeeID OrderID
ProductName LastName CustomerID

SupplierID Firstname EmployeeID
OrderDate
CategoryID BirthDate
ShippedDate
UnitPrice Address ShipName

QuantityPerUnit HomePhone

Entity Class Entity

Identifier .

Product Number Key Field

Key Products

. Unique Field

Logical Metadata .‫ﻌﻠﻴﺔ‬
Associations -٢
.
Design

١٥