exercise 3

Tables (5)

animal (애완동물)

  • animid (Key) — Primary key — NOT NULL
  • animname (Field)
  • acategory (Field2)
  • breed (Field3)
  • dob (Field4)
  • gender (Field5)
  • reg (Field6)
  • color (Field7)
  • alprice (Field8)
  • custid (Key2) — Foreign key → customer.custid — NOT NULL

customer (고객)

  • custid (Key) — Primary key — NOT NULL
  • custname (Field)
  • address (Field2)
  • city (Field3)
  • state (Field4)
  • zipcode (Field5)
  • empid (Key2) — Foreign key → employee.empid — NOT NULL

employee (직원)

  • empid (Key) — Primary key — NOT NULL
  • empname (Field)

merchandise (상품)

  • item (Key) — Primary key — NOT NULL
  • desc (Field2)
  • mcategory (Field3)
  • mlprice (Field4)
  • custid (Key2) — Foreign key → customer.custid — NOT NULL

sale (할인)

  • saleno (Key) — Primary key — NOT NULL
  • animid (Key2) — Foreign key → animal.animid — NOT NULL
  • item (Key3) — Foreign key → merchandise.item — NOT NULL
  • saledate (Field)
  • asubtotal (Field2)
  • msubtotal (Field3)
  • saletax (Field4)
  • saletotal (Field5)