Phone table Serial - must be unique, year+3 letters of make + 3letters of model + screensize or something alike Make Model Form-Factor Size - 152.9x77.2x10.7 Weight - gramms SIM_Type SIM_Num - number of simcards, 1 to 4 DisplaySize DisplayRez - 1920x1080 LightSensor - boolean QWERTY - boolean, if has keyboard Touchscreen - boolean TouchType - IPS, TFT, etc OS_ID - foreign key to OS table CPU_ID - foreign key to CPU table GPU_ID - foreign key to GPU table IntMemorySize ExtMem - boolean, if has slot for memory card ExtMemSize Camera - boolean, if has CamRez CamFlash - boolean CamVideoRez CamVideoFPS CamGeoTag - boolean FaceDetect - boolean Panorama - boolean HDR - boolean FrCamera - boolean, if has front cam FrRez 3.5Jack - boolean, if has Bluetooth - foreign key to Comms table GPS - foreign key to Comms table Wi-Fi - foreign key to Comms table WiMAX - foreign key to Comms table RAM_Size RemovableBattery - boolean BatteryCapacity USB_Charging WirelessCharging - boolean FMRadio - boolean InternalRadioAntenna - boolean GSM - foreign key to Comms table CDMA - foreign key to Comms table 3G - foreign key to Comms table 4G - foreign key to Comms table LTE - foreign key to Comms table GPRS - foreign key to Comms table EDGE - foreign key to Comms table HSDPA - foreign key to Comms table HSUPA - foreign key to Comms table HSPA+ - foreign key to Comms table DLNA - boolean IRDA - foreign key to Comms table Dumbphone - boolean, if it's designed for senior users and people with eyevision issues PlaneMode - boolean built-in_walkie-talkie - boolean SAR_Level Accelerometer - boolean Compass - boolean Proximity - boolean Gyroscope - boolean NFC - boolean FingerprintScan - boolean OS table OS_ID - primary key, must be unique OS_Family OS_Version OS_Description CPU table CPU_ID - primary key, must be unique CPU_Arcitecture CPU_Cache CPU_CoreNum CPU_Freq CPU_Fab - https://en.wikipedia.org/wiki/Semiconductor_device_fabrication GPU_ID - foreign key to GPU table GPU table GPU_ID - primary key, must be unique and all specs like here - https://en.wikipedia.org/wiki/Adreno Comms Table Comm_ID - primary key, must be unique Comm_Desc - shows all specs of standard, including frequency, range, bandwidth, etc.