#1

Tables (5)

Agent (Untitled3)

  • ID (Key) — Primary key — NOT NULL
  • Name (Field)
  • OfficeID (Field2)
  • PhoneNumber (Field3)

Buyer (CopyOfUntitled)

  • BuyerID (Field9)
  • BuyerName (Field)
  • BuyerSSN (Field2)
  • Address (Field3)
  • PhoneNumber (Field4)
  • SpouseName (Field7)
  • SpouseSSN (Field8)
  • Bathrooms (Field5)
  • Bedrooms (Field6)

Home (Untitled)

  • ID (Key2) — Foreign key → Agent.ID — NOT NULL
  • Address (Field)
  • City (Field2)
  • State (Field3)
  • ZipCode (Field4)
  • Bathrooms (Field5)
  • Bedrooms (Field6)
  • SquareFeet (Field7)
  • Type (Field8)

Office (Untitled4)

  • ID (Key) — Foreign key → Agent.ID — NOT NULL
  • PhoneNumber (Field)
  • ManagerName (Field2)
  • Address (Field3)

Owner (Untitled2)

  • Social Security Number (Key) — Primary key — NOT NULL
  • Name (Field)
  • SpouseName (Field2)
  • Profession (Field3)
  • Spouse Profession (Field4)