ER - Model ตอนที่ 2
posted on 01 Sep 2009 08:25 by computerize in ERการออกแบบฐานข้อมูล อีอาร์โมเดล ( ER : Entity Relationship Model )
ตัวอย่างของ Relation schema ของ Northwind
- Categories (CategoryID,CategoryName,Description,Picture)
- CustomersCustomerID,CompanyName,ContactName,ContactTitle, Address,City,Region,PostalCode,Country,Phone,Fax)
- EmployeesEmployeeID,LastName,FirstName,Title,BirthDate,HireDate, Address,City,Region,PostalCode,Country,HomePhone,Extension,Photo,Notes,ReportsTo)
- ProductsProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit, UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued)
- Shippers (ShipperID,CompanyName,Phone)
- SuppliersSupplierID,CompanyName,ContactName,ContactTitle,Address,City, Region,PostalCode,Country,Phone,Fax,Homepage)
- OrdersOrderID,CustomerID,EmployeeID,OrderDate,RequiredDate, ShippedDate,ShipVia,Freight,ShipName,ShipAddress,ShipCity ShipRegion,ShipPostalCode,ShipCountry)
- Order Details (OrderID,ProductID,UnitPrice,Quantity,Discount)
Tags: er, er model0 Comments