final_exam

Tables (6)

CPU (Untitled4)

  • cpuID (Key) — char — Primary key — NOT NULL
  • name (Field) — char
  • core (Field2) — integer
  • mhz (Field3) — integer
  • thread (Field4) — integer
  • pricec (Field5) — integer
  • company (Key2) — char — NOT NULL

Computer (Untitled)

  • remID (Key) — char — Foreign key → Memory.remID — NOT NULL
  • moniterID (Key2) — char — Foreign key → Moniter.moniterID — NOT NULL
  • cpuID (Key3) — char — Foreign key → CPU.cpuID — NOT NULL
  • mainID (Key4) — char — Foreign key → Mainboard.mainID — NOT NULL
  • cpuID (Key23) — char — Foreign key → Mainboard.cpuID — NOT NULL
  • company (Key222) — char — Foreign key — NOT NULL
  • cardID (Key5) — char — Foreign key → GraphicCard.cardID — NOT NULL

GraphicCard (Untitled5)

  • cardID (Key) — char — Primary key — NOT NULL
  • name (Field) — char
  • mhz (Field2) — integer
  • watts (Field3) — integer
  • manufacturer (Field4) — char
  • registrationDate (Field5) — char
  • price (Field6) — integer

Mainboard (Untitled6)

  • mainID (Key) — char — Primary key — NOT NULL
  • cpuID (Key2) — char — Foreign key → CPU.cpuID — NOT NULL
  • name (Field) — char
  • ddr (Field2) — integer
  • memoryMax (Field3) — integer
  • memorySlot (Field4) — integer
  • price (Field5) — integer

Memory (Untitled3)

  • remID (Key) — char — Primary key — NOT NULL
  • name (Field) — char
  • ddr (Field2) — integer
  • price (Field3) — integer
  • gb (Field4) — integer
  • bandwidth (Field5) — integer

Moniter (Untitled2)

  • moniterID (Key) — char — Primary key — NOT NULL
  • name (Field) — char
  • hz (Field2) — integer
  • resolution (Field3) — char
  • curved (Field4) — char
  • rate (Field5) — char
  • ms (Field6) — integer
  • price (Field7) — integer