ER - Model ตอนที่ 2

posted on 01 Sep 2009 08:25 by computerize in ER

การออกแบบฐานข้อมูล อีอาร์โมเดล ( ER : Entity Relationship Model )

ตัวอย่างของ Relation schema ของ Northwind

  1. Categories (CategoryID,CategoryName,Description,Picture)
  2. CustomersCustomerID,CompanyName,ContactName,ContactTitle, Address,City,Region,PostalCode,Country,Phone,Fax) 
  3. EmployeesEmployeeID,LastName,FirstName,Title,BirthDate,HireDate, Address,City,Region,PostalCode,Country,HomePhone,Extension,Photo,Notes,ReportsTo) 
  4. ProductsProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit, UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) 
  5. Shippers (ShipperID,CompanyName,Phone)
  6. SuppliersSupplierID,CompanyName,ContactName,ContactTitle,Address,City, Region,PostalCode,Country,Phone,Fax,Homepage) 
  7. OrdersOrderID,CustomerID,EmployeeID,OrderDate,RequiredDate, ShippedDate,ShipVia,Freight,ShipName,ShipAddress,ShipCity ShipRegion,ShipPostalCode,ShipCountry) 
  8. Order Details (OrderID,ProductID,UnitPrice,Quantity,Discount)



Comment

Comment:

Tweet