Logical Model

  • Customer: CustomerID, Name, Email
  • Order: OrderID, OrderDate, CustomerID
  • Book: BookID, Title, Author
  • Order-Book Relationship: OrderID, BookID

Logical Model

  • Details the attributes of each data entity.
  • Specifies relationships without depending on a specific database management system.