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