Business Rules For Product And Customer Tables – Database Schema
- December 28, 2023/ Uncategorized
Product Table
following business rules have been identified from the case study;
- A1E deals with one or more products.
- There are many characteristics identifying products. A characteristic can be shared by one or more products
- Every product has one or more characteristics.
- There are many features identifying products. A feature can be shared by one or more products.
- Every product has one or more features.
- There are many product details and a detail can be shared by one or more products.
- Every product has one or more details.
- Every product ha one or more categories.
- Every category has one or more subcategories.
- Every has one or more reviews.
- A customer makes a review for one or more products.
- Every review has score for the quality and the value.
- Task2: Data dictionary
|
Table |
Columm |
Data type |
Constraint |
|
Product |
PID |
Integer |
Primary key |
|
manufacturerName |
Varchar2(100) |
||
|
Name |
Varchar2(100) |
||
|
Model |
Varchar2(100) |
||
|
imageFIleName |
Varchar2(250) |
||
|
price |
Decimal |
||
|
Customer |
CID |
Integer |
Primary key |
|
name |
Varchar2(100) |
||
|
Address |
Varchar2(100) |
||
|
mobile |
Varchar2(25) |
||
|
score |
SID |
integer |
Primary key |
|
Val |
Integer |
||
|
description |
Varchar2(50) |
||
|
characteristic |
CID |
integer |
Primary key |
|
Name |
Varchar2(100) |
||
|
shortDescription |
Varchar2(1000) |
||
|
feature |
FID |
Integer |
Primary key |
|
Name |
Varchar2(100) |
||
|
shortDescription |
Varchar2(1000) |
||
|
Category |
catID |
integer |
Primary key |
|
name |
Varchar2(100) |
||
|
ProductCategory |
PID |
integer |
Primary key Foreign key references product.PID |
|
catID |
integer |
Primary key Foreign key references Caegerory.catID |
|
|
Detail |
FID |
integer |
Primary key |
|
Name |
Varchar2(100) |
||
|
shortDescription |
Varchar2(1000) |
||
|
subcategory |
subcatID |
integer |
Primary key |
|
name |
Varchar2(100) |
||
|
review |
CID |
integer |
Primary key Foreign key references customer.customerID |
|
PID |
Integer |
Foreign key references product.productID |
|
|
Author |
Varchar2(100) |
||
|
Subject |
Varchar2(100) |
||
|
Text |
Varchar2(250) |
||
|
Recommendation |
Varchar2(100) |
||
|
Quality |
Integer |
Foreign key references score.SID |
|
|
val |
Integer |
Foreign key references score.SID |
|
|
productcharacteristic |
PID |
integer |
Primary key Foreign key references product.PID |
|
CID |
Integer |
Primary key Foreign key references characteristic.CID |
|
|
ProductFeature |
PID |
Integer |
Primary key Foreign key references product.PID |
|
FID |
integer |
Primary key Foreign key references feature.FID |
|
|
productDetail |
PID |
Integer |
Primary key Foreign key references product.PID |
|
DID |
Integer |
Primary key Foreign key references details.DID |
|
|
categorySubcategory |
catID |
integer |
Primary key Foreign key references category.catID |
|
subCatID |
Integer |
Primary key Foreign key references subcategory.subcatID |
|
|
productsubcategory |
Pid |
integer |
Primary key Foreign key references product.PID |
|
subcatid |
integer |
Primary key Foreign key references subcategory.subcatID |
drop table customer cascade constraints;
drop table product cascade constraints;
drop table productCategory cascade constraints;
drop table category cascade constraints;
drop table review cascade constraints;
drop table productCharacteristic cascade constraints;
drop table productFeature cascade constraints;
drop table productDetail cascade constraints;
drop table categorySubcategory cascade constraints;
drop table score cascade constraints;
drop table characteristic cascade constraints;
drop table feature cascade constraints;
drop table detail cascade constraints;
drop table subcategory cascade constraints;
create table product(
PID integer primary key,
manufacturerName varchar2(100) not null,
name varchar2(100) not null,
model varchar2(100) not null,
imageFileName varchar2(250) not null,
price decimal not null
)create table customer(
CID integer primary key,
name varchar2(100) not null,
address varchar2 (100) not null,
mobile varchar2 (25) not null
create table score (
SID integer primary key,
val integer not null,
description varchar2(50) not null
create table characteristic(
CID integer primary key,
name varchar2(100),
shortDescription varchar2(1000) not null
create table feature (
FID integer primary key,
name varchar2(100) ,
shortDescription varchar2(1000) not null
create table category(
catID integer primary key,
name varchar2(100)
create table productcategory(
pid integer not null,
catID integer not null,
primary key (pid,catid),
foreign key (pid) references product (pid),
foreign key (catID) references category (catID)
create table Detail (
DID integer primary key,
name varchar2(100) not null,
shortDescription varchar2(1000)
create table subcategory(
subcatid integer primary key,
name varchar2(100)
create table review(
CID integer not null,
PID integer not null,
author varchar2(100) not null,
subject varchar2(100) not null,
text varchar2(1000) not null,
recommendation varchar2(100) not null,
quality integer not null,
val integer not null,
primary key (CID,PID),
foreign key (CID) references customer (CID),
foreign key (PID) references product (PID),
foreign key (quality) references score (SID),
foreign key (val) references score (SID)
create table productCharacteristic(
PID integer not null,
CID integer not null,
primary key (PID,CID),
foreign key (PID) references product (PID),
foreign key (CID) references characteristic (CID)
create table productfeature(
PID integer not null,
FID integer not null,
primary key (PID,FID),
foreign key (PID) references product (PID),
foreign key (FID) references feature (FID)
Customer Table
create table productDetail(
PID integer not null,
DID integer not null,
primary key (PID,DID),
foreign key (PID) references product (PID),
foreign key (DID) references detail (DID)
create table categorySubcategory(
catid integer not null,
subcatID integer not null,
primary key (catid,subcatid),
foreign key (catID) references category (catid),
foreign key (subcatid) references subcategory (subcatid)
create table productsubcategory(
pid integer not null,
subcatid integer not null,
primary key (pid,subcatid),
foreign key (pid) references Product (pid),
foreign key (subcatid) references subcategory (subcatid)–insert
— PAUSE ‘Insert SCORE values’
INSERT INTO SCORE VALUES(101, 1, ‘very poor’);
INSERT INTO SCORE VALUES(102, 2, ‘poor’);
INSERT INTO SCORE VALUES(103, 3, ‘good’);
INSERT INTO SCORE VALUES(104, 4, ‘very good’);
INSERT INTO SCORE VALUES(105, 5, ‘excellent’);
— PAUSE ‘Insert PRODUCT values’
INSERT INTO PRODUCT VALUES(1, ‘Samsung’, ‘Samsung Galaxy Note9 512GB (Midnight Black)’, ‘1091004836’, ‘/Images/235667.jpg’, 1799);
INSERT INTO PRODUCT VALUES(2, ‘Samsung’, ‘Samsung Galaxy S9+ 256GB (Coral Blue)’, ‘1091004314’, ‘/Images/235672.jpg’, 1499);
INSERT INTO PRODUCT VALUES(3, ‘Apple’, ‘Apple iPhone X 256GB (Silver)’, ‘3801000070’, ‘/Images/235682.jpg’, 1829);
INSERT INTO PRODUCT VALUES(4, ‘Apple’, ‘Apple iPhone X 64GB (Space Grey)’, ‘3801000067’, ‘/Images/235782.jpg’, 1574);
INSERT INTO PRODUCT VALUES(5, ‘Apple’, ‘Apple iPad Pro 10.5-inch 256GB Wi-Fi (Silver)’, ‘MPF02X/A’, ‘/Images/236782.jpg’, 1198);
INSERT INTO PRODUCT VALUES(6, ‘Apple’, ‘Apple iPad 32GB Wi-Fi + Cellular (Space Grey) [6th Gen]’, ‘MR6N2X/A’, ‘/Images/236787.jpg’, 669);
INSERT INTO PRODUCT VALUES(7, ‘Samsung’, ‘Samsung Galaxy Tab S4 10.5″ Wi-Fi 256GB (Fog Grey)’, ‘SM-T830NZALXSA’, ‘/Images/236887.jpg’, 1174);
INSERT INTO PRODUCT VALUES(8, ‘Microsoft’, ‘Microsoft Surface Pro i7 1TB Tablet’, ‘FKK-00007’, ‘/Images/236899.jpg’, 3996);
INSERT INTO PRODUCT VALUES(9, ‘Sony’, ‘Sony KDL32W660E 32″ Full HD HDR Smart LED LCD TV’, ‘KDL32W660E’, ‘/Images/247000.jpg’, 648);
INSERT INTO PRODUCT VALUES(10, ‘Sony’, ‘Sony X85F 75″ 4K UHD Android LED TV’, ‘KD75X8500F’, ‘/Images/247010.jpg’, 4496);
INSERT INTO PRODUCT VALUES(11, ‘LG’, ‘LG C8 77″ 4K UHD AI Smart OLED TV’, ‘OLED77C8PTA’, ‘/Images/247555.jpg’, 12996);
INSERT INTO PRODUCT VALUES(12, ‘Samsung’, ‘Samsung NU8000 75″ Series 8 Premium 4K UHD LED TV’, ‘UA75NU8000WXXY’, ‘/Images/248888.jpg’, 3996);
— PAUSE ‘Insert CATEGORY values’
INSERT INTO CATEGORY VALUES(1, ‘Phones’);
INSERT INTO CATEGORY VALUES(2, ‘Tablets’);
INSERT INTO CATEGORY VALUES(3, ‘TVs’);
— PAUSE ‘Insert PRODUCTCATEGORY values’
INSERT INTO PRODUCTCATEGORY VALUES(1, 1);
INSERT INTO PRODUCTCATEGORY VALUES(2, 1);
INSERT INTO PRODUCTCATEGORY VALUES(3, 1);
INSERT INTO PRODUCTCATEGORY VALUES(4, 1);
INSERT INTO PRODUCTCATEGORY VALUES(5, 2);
INSERT INTO PRODUCTCATEGORY VALUES(6, 2);
INSERT INTO PRODUCTCATEGORY VALUES(7, 2);
INSERT INTO PRODUCTCATEGORY VALUES(8, 2);
INSERT INTO PRODUCTCATEGORY VALUES(9, 3);
INSERT INTO PRODUCTCATEGORY VALUES(10, 3);
INSERT INTO PRODUCTCATEGORY VALUES(11, 3);
Score Table
INSERT INTO PRODUCTCATEGORY VALUES(12, 3);
— PAUSE ‘Insert SUBCATEGORY values’
INSERT INTO SUBCATEGORY VALUES(1, ‘Samsung Galaxy phones’);
INSERT INTO SUBCATEGORY VALUES(2, ‘iPhone X’);
INSERT INTO SUBCATEGORY VALUES(3, ‘Apple iPad’);
INSERT INTO SUBCATEGORY VALUES(4, ‘Samsung Galaxy’);
INSERT INTO SUBCATEGORY VALUES(5, ‘Microsoft Surface’);
INSERT INTO SUBCATEGORY VALUES(6, ‘Smart TVs’);
INSERT INTO SUBCATEGORY VALUES(7, ‘4K Ultra HD TVs’);
— PAUSE ‘Insert PRODUCTSUBCATEGORY values’
INSERT INTO PRODUCTSUBCATEGORY VALUES(1, 1);
INSERT INTO PRODUCTSUBCATEGORY VALUES(2, 1);
INSERT INTO PRODUCTSUBCATEGORY VALUES(3, 2);
INSERT INTO PRODUCTSUBCATEGORY VALUES(4, 2);
INSERT INTO PRODUCTSUBCATEGORY VALUES(5, 3);
INSERT INTO PRODUCTSUBCATEGORY VALUES(6, 3);
INSERT INTO PRODUCTSUBCATEGORY VALUES(7, 4);
INSERT INTO PRODUCTSUBCATEGORY VALUES(8, 5);
INSERT INTO PRODUCTSUBCATEGORY VALUES(9, 6);
INSERT INTO PRODUCTSUBCATEGORY VALUES(10, 7);
INSERT INTO PRODUCTSUBCATEGORY VALUES(11, 7);
INSERT INTO PRODUCTSUBCATEGORY VALUES(12, 7);
— PAUSE ‘Insert CATEGORYSUBCATEGORY values’
INSERT INTO CATEGORYSUBCATEGORY VALUES(1, 1);
INSERT INTO CATEGORYSUBCATEGORY VALUES(1, 2);
INSERT INTO CATEGORYSUBCATEGORY VALUES(2, 3);
INSERT INTO CATEGORYSUBCATEGORY VALUES(2, 4);
INSERT INTO CATEGORYSUBCATEGORY VALUES(2, 5);
INSERT INTO CATEGORYSUBCATEGORY VALUES(3, 6);
INSERT INTO CATEGORYSUBCATEGORY VALUES(3, 7);
— PAUSE ‘Insert CUSTOMER values’
INSERT INTO CUSTOMER VALUES(1, ‘Jack’, ’71 High St, Belmont, 3216′, ‘0421 335865’);
INSERT INTO CUSTOMER VALUES(2, ‘Jill’, ’81 High St, Belmont, 3216′, ‘0432 335879 ‘);
INSERT INTO CUSTOMER VALUES(3, ‘Bill’, ’90 High St, Belmont, 3216′, ‘0450 335891 ‘);
INSERT INTO CUSTOMER VALUES(4, ‘George’, ’92 High St, Belmont, 3216′, ‘0416 335934 ‘);
INSERT INTO CUSTOMER VALUES(5, ‘Fred’, ‘103 High St, Belmont, 3216’, ‘0443 336010 ‘);
INSERT INTO CUSTOMER VALUES(6, ‘Barny’, ‘105 High St, Belmont, 3216’, ‘0445 336094 ‘);
INSERT INTO CUSTOMER VALUES(7, ‘Ralph’, ‘118 High St, Belmont, 3216’, ‘0430 336189 ‘);
INSERT INTO CUSTOMER VALUES(8, ‘Leanne’, ‘132 High St, Belmont, 3216’, ‘0441 336221 ‘);
INSERT INTO CUSTOMER VALUES(9, ‘Paul’, ‘139 High St, Belmont, 3216’, ‘0419 336259 ‘);
INSERT INTO CUSTOMER VALUES(10, ‘John’, ‘145 High St, Belmont, 3216’, ‘0447 336280 ‘);
INSERT INTO CUSTOMER VALUES(11, ‘Lisa’, ‘158 High St, Belmont, 3216’, ‘0420 336358 ‘);
INSERT INTO CUSTOMER VALUES(12, ‘Bart’, ‘178 High St, Belmont, 3216’, ‘0424 336404 ‘);
INSERT INTO CUSTOMER VALUES(13, ‘Harry’, ‘185 High St, Belmont, 3216’, ‘0419 336431 ‘);
INSERT INTO CUSTOMER VALUES(14, ‘Mary’, ‘205 High St, Belmont, 3216’, ‘0432 336472 ‘);
INSERT INTO CUSTOMER VALUES(15, ‘Steven’, ‘208 High St, Belmont, 3216’, ‘0449 336530 ‘);
INSERT INTO CUSTOMER VALUES(16, ‘Guy’, ‘210 High St, Belmont, 3216’, ‘0412 336627 ‘);
INSERT INTO CUSTOMER VALUES(17, ‘Dave’, ‘228 High St, Belmont, 3216’, ‘0420 336666 ‘);
INSERT INTO CUSTOMER VALUES(18, ‘Travis’, ‘233 High St, Belmont, 3216’, ‘0420 336754 ‘);
INSERT INTO CUSTOMER VALUES(19, ‘James’, ‘251 High St, Belmont, 3216’, ‘0419 336831 ‘);
Characteristic Table
— PAUSE ‘Insert REVIEW values’
INSERT INTO REVIEW VALUES(1, 2, ‘Jack’, ‘Almost perfect samsung’, ‘I bought this a few weeks ago and it”s a great phone very good anti theft security and useful apps.’, ‘yes’, 104, 105);
INSERT INTO REVIEW VALUES(2, 2, ‘Jill’, ‘Great phone and good quality’, ‘I bought this in store and it worked out great. Everyone loves the edge.’, ‘yes’, 105, 104);
INSERT INTO REVIEW VALUES(3, 3, ‘Bill’, ‘Too overpriced’, ‘For what this phone is, it is certainly not worth the amount I paid for it. The Galaxy Note8 has much better value and offers more features.’, ‘no’, 102, 101);
INSERT INTO REVIEW VALUES(4, 3, ‘George’, ‘Its just ok ‘, ‘Same stuff like iphone 8. It has very bad bettery life. Iphone 8+ worth than x.’, ‘no’, 102, 101);
INSERT INTO REVIEW VALUES(5, 3, ‘Fred’, ‘Great phone but be careful ‘, ‘Me and my friend bought the iphone x recently and my friend dropped the iPhone X and it broke, thank god it wasn’t me. Buy a case that is strong enough to protect the phone or it could break. But the features are mind blowing and is extremely worth its price like the Animoji like that is the best and the Face ID is also awesome’, ‘yes’, 104, 104);
INSERT INTO REVIEW VALUES(6, 3, ‘Barny’, ‘Love everything about the X’, ‘I bought this phone approximately 6 months ago. I went in to just upgrade from the 6 but after having a play with this & seeing what it did I just had to get it! I read reviews prior to going to buy a new phone and the X is a must! I bought the 6 new so it did well for 3 years. I actually am excited to see what Apple brings out next!’, ‘yes’, 105, 105);
INSERT INTO REVIEW VALUES(7, 4, ‘Ralph’, ‘Good Smart Phone’, ‘Very slippery without a screen protector & I”ve read that jeans will scratch the screen. Not much is new in the OS from a 4s. Amazed at the size of screen & how thin it is.’, ‘yes’, 105, 103);
INSERT INTO REVIEW VALUES(8, 4, ‘Leanne’, ‘Hmm’, ‘I’ve tried plenty of iPhones for my life but this one finally feels like a new device if you know what I mean. All those gestures require getting used to it but it’s so fun – not having the home button haha. Face ID has been working flawlessly (considering all the camera angles needed for it to actually work), finally I can use my phone with wet hands without any problems.’, ‘yes’, 105, 104);
Feature Table
INSERT INTO REVIEW VALUES(9, 6, ‘Paul’, ‘too new and fandangled ‘, ‘these things are too confusing, why not go back to the good old newton. that baby was the real deal it even had a game in it. but these things have got too many new features that ill drown in them.’, ‘no’, 102, 101);
INSERT INTO REVIEW VALUES(9, 7, ‘Paul’, ‘too new and fandangled ‘, ‘these things are too confusing, why not go back to the good old newton. that baby was the real deal it even had a game in it. but these things have got too many new features that ill drown in them.’, ‘no’, 102, 101);
INSERT INTO REVIEW VALUES(10, 9, ‘John’, ‘Picture perfect ‘, ‘Straight out of the box and setup in minutes. Picture is great and sound is good too. Would highly recommend and can”t beat that price. Great value for money’, ‘yes’, 105, 105);
INSERT INTO REVIEW VALUES(11, 9, ‘Lisa’, ‘Absolutely love it ‘, ‘Easy to navigate and set up Crystal clear tv Worth the value’, ‘yes’, 105, 105);
INSERT INTO REVIEW VALUES(12, 9, ‘Bart’, ‘Great TV!’, ‘Bought this tv 3 weeks ago and i couldnt be happier. Amazing graphics, looks nice and easy to use’, ‘yes’, 105, 105);
INSERT INTO REVIEW VALUES(13, 9, ‘Harry’, ‘Great spare room TV’, ‘Faultless picture – works really well with Apple TV. Sound is very good for a TV of this size.’, ‘yes’, 105, 105);
INSERT INTO REVIEW VALUES(14, 9, ‘Mary’, ‘Great quality visuals, nice speakers.’, ‘Really happy with the high quality of the screen and great colour and adjustments in the settings. Love the Netflix and Youtube shortcut buttons on the remote. Minor complaint is that the base that holds tv up is plastic and not the strongest and can”t tilt or swivel so it is in a fixed position. Still definitely worth the money’, ‘yes’, 105, 104);
INSERT INTO REVIEW VALUES(15, 10, ‘Steven’, ‘Brilliant TV! ‘, ‘Have had this TV for about 3 weeks now. Superb picture quality. 4K movies look magnificent. Surprisingly, the up-scaling technology is also great – Foxtel HD movies and ”normal” blu-rays also look fantastic. My last TV was also a Sony, had it for 8 years, so the remote/features are very familiar. Cable management is a great feature and my old Sony soundbar sits perfectly underneath the panel (yes, I am a bit biased towards Sony products). If I had to be picky… the inbuilt speakers aren”t great (great volume, sounds a bit ”tinny”), but then – that”s why the tech gods have given us soundbars / amplifiers / external speakers… Make sure you have a ”buddy” help you unpack/setup etc – this thing is huge! Pricey, but worth every penny.’, ‘yes’, 105, 104);
Category Table
INSERT INTO REVIEW VALUES(16, 11, ‘Guy’, ‘Bright as the sun and black as space!’, ‘An incredible TV that brings out the best picture in any format of content. WebOS and very quick processing make it great to watch Netflix and Youtube. Game mode offers an HDR variant with amazing picture quality and very low input lag. If you’re in the market for a TV consider an OLED, and in particular the LG C8.’, ‘yes’, 105, 105);
INSERT INTO REVIEW VALUES(17, 11, ‘Dave’, ‘not worth the price’, ‘i bought this tv for the family a few weekends ago and i”m not impressed with the quality of this product from such a popular retail shop.’, ‘no’, 103, 101);
INSERT INTO REVIEW VALUES(18, 12, ‘Travis’, ‘Just as good as Q7FN’, ‘It”s great for Xbox One X gaming. Minimal calibration required, although you need to make sure you”re using a HDMI 2.0 cable to get the Variable Refresh Rate (Freesync) activated. HDR10 and 4K run really smooth and the input lag is not really even a thing anymore (it”s under 10ms now with VRR enabled). Only downside is that the auto-game-mode (which is awesome) kind of breaks with VRR enabled, and the TV just stays in Game Mode the whole time. This can be disabled manually, and since VRR is part of the latest firmware update, I”m hoping a future update will pair VRR back up with auto-game-mode.’, ‘yes’, 105, 105);
INSERT INTO REVIEW VALUES(19, 12, ‘James’, ‘Great Upgrade ‘, ‘Not being tech savvy thought Google would be helpful in best options for feature setup but believe me after following numerous supposedly professional advice sites I went back to factory setup and couldn”t be happier – don”t over think it.’, ‘yes’, 105, 105);
— PAUSE ‘Insert CHARACTERISTIC values’
INSERT INTO CHARACTERISTIC VALUES(1, ‘The all new S Pen’, ‘The all new S Pen now boasts powerful Bluetooth technology, letting you press a button to take control of your camera, presentations and more without touching your phone. While drawing, taking notes, and sending Live Messages is as intuitive and natural as pen and paper, thanks to the fine tip and true-to-life pressure sensitivity.’);
INSERT INTO CHARACTERISTIC VALUES(2, ‘Super-fast downloads’, ‘Discover what you can achieve on the Galaxy Note9. Whether gaming, streaming, or multitasking, the 10nm processor and 8GB RAM models deliver performance that makes you take notice. And with access to lightning fast network speeds, things get done in a flash.’);
Product Category Table
INSERT INTO CHARACTERISTIC VALUES(3, ‘Long lasting battery’, ‘Leave your battery packs and cords at home — the 4000mAh battery is designed to get you through your day.’);
INSERT INTO CHARACTERISTIC VALUES(4, ‘See more, do more’, ‘Enjoy an uninterrupted view on our largest Infinity Display ever. Its virtually bezelless display gives you an expansive edge-to-edge cinematic experience as boundless as your imagination.’);
INSERT INTO CHARACTERISTIC VALUES(5, ‘Stunning photos, day or night’, ‘Our Dual Aperture lens intelligently adapts to the surrounding light like the human eye — choosing between two f-stop modes. F1.5 mode brings in light to brighten up super low light shots. While F2.4 mode helps make sure your photos come out clear.’);
INSERT INTO CHARACTERISTIC VALUES(6, ‘True to life colours’, ‘Designed so you get the photo you want in the first shot. Scene Optimiser on the rear camera intelligently detects the subject in frame. It then chooses from twenty different modes like flowers, food, and more, and enhances the picture to suit your subject.’);
INSERT INTO CHARACTERISTIC VALUES(7, ‘Picture perfect’, ‘Eradicate closed eyes and blurry photos with Galaxy Note9”s Flaw Detection. It intelligently detects blinks, blurs, smudged lenses, and backlighting, notifying you so you can adjust and reshoot.’);
INSERT INTO CHARACTERISTIC VALUES(8, ‘More space for everything’, ‘Stop deleting your memories for just a little extra space. With the power of 512GB* storage built in – you’ll have room for what matters. And adding even more is simple; just place a microSD card** in the slot for up to 400GB of extra space. So you can keep your files and photos right where you need them — on your phone.’);
INSERT INTO CHARACTERISTIC VALUES(9, ‘Make a splash’, ‘For most phones, water is the enemy. The Galaxy Note9 and S Pen are sealed from the inside out with an IP68 rating to protect your phone from dust and water.*’);
INSERT INTO CHARACTERISTIC VALUES(10, ‘It’s like two phones in one’, ‘It”s always handy to have an option, whether it”s more storage or an extra phone number. With Hybrid SIM, keep your important files, photos, and videos with a MicroSD card, or use a second SIM to give you the freedom to have two phone numbers.*’);
INSERT INTO CHARACTERISTIC VALUES(11, ‘Leave your computer behind’, ‘DeX is designed to give you what you want from a PC experience.* Just connect your phone into an external display to use apps, review documents, and watch videos on a PC-like interface. So you can turn any place into a workplace.’);
Detail Table
INSERT INTO CHARACTERISTIC VALUES(12, ‘Super Slow-mo’, ‘The camera that radically slows down time, making everyday moments epic.’);
INSERT INTO CHARACTERISTIC VALUES(13, ‘AR Emoji’, ‘The camera that turns you into an emoji, so you’re not the “you” everyone else is.’);
INSERT INTO CHARACTERISTIC VALUES(14, ‘Dual Aperture’, ‘The revolutionary camera that adapts like the human eye, capturing stunning pictures in super low light.’);
INSERT INTO CHARACTERISTIC VALUES(15, ‘Live Translation’, ‘The camera that can instantly read what your eyes can”t.*’);
INSERT INTO CHARACTERISTIC VALUES(16, ‘Quick Command’, ‘The camera that responds to your voice commands, so capturing moments becomes effortless.’);
INSERT INTO CHARACTERISTIC VALUES(17, ‘Dual Camera’, ‘Capture every sharp detail with two advanced rear cameras and 2x optical zoom.’);
INSERT INTO CHARACTERISTIC VALUES(18, ‘Water-resistant’, ‘The remarkable water-resistant phone: Make a splash*’);
INSERT INTO CHARACTERISTIC VALUES(19, ‘Stereo Speakers’, ‘Stereo speakers with Dolby Atmos surround sound.’);
INSERT INTO CHARACTERISTIC VALUES(20, ‘Multi Device Experience’, ‘Share your screen, to your other Samsung screens, hassle-free*.’);
INSERT INTO CHARACTERISTIC VALUES(21, ‘Infinity Display’, ‘See more. Hold less.’);
INSERT INTO CHARACTERISTIC VALUES(22, ‘Intelligent Scan’, ‘The camera that recognises you instantly, acting as your security guard.’);
INSERT INTO CHARACTERISTIC VALUES(23, ‘Performance’, ‘Our fastest Galaxy yet with cat. 18 technology for super-fast downloads.’);
INSERT INTO CHARACTERISTIC VALUES(24, ‘Battery’, ‘Power through the day with a long-lasting battery engineered for fast wireless charging*’);
INSERT INTO CHARACTERISTIC VALUES(25, null, ‘iPhone X features an all-screen design with a 5.8-inch Super Retina HD display with HDR and True Tone.1 Designed with the most durable glass ever in a smartphone and a surgical-grade stainless steel band. Charges wirelessly.2 Resists water and dust.3 12-megapixel dual cameras with dual optical image stabilisation for great low light photos. TrueDepth camera with Portrait selfies and new Portrait Lighting.4 Face ID lets you unlock and use Apple Pay with just a glance. Powered by A11 Bionic, the smartest and most powerful chip ever in a smartphone. Supports augmented reality experiences in games and apps. With iPhone X, the next era of iPhone has begun.’);
INSERT INTO CHARACTERISTIC VALUES(26, null, ‘Immensely powerful and capable, the 10.5-inch iPad Pro features a redesigned Retina display that is Apple’s most advanced yet1, while the A10X Fusion chip outperforms most PC laptops. With Apple Pencil, Smart Keyboard2 (both optional) and iOS, Apple’s most advanced mobile operating system ever, the 10.5-inch iPad Pro is designed for the world we live in today.’);
INSERT INTO CHARACTERISTIC VALUES(27, null, ‘Create, learn, work and play like never before. An immersive 9.7-inch Multi-Touch Retina display.1 A10 Fusion chip with the power and capability you’d expect from a computer. Now supports Apple Pencil.2 8-megapixel camera. FaceTime HD camera. Touch ID and Apple Pay.3 Wi-Fi and 4G LTE.4 All-day battery life.5 Over a million apps available on the App Store, including augmented reality experiences. A thin, durable aluminium design that weighs less than 500 grams. And iOS 11 makes iPad more powerful, personal and intelligent, so you can do more than ever before. iPad. There’s nothing else quite like it.’);
Subcategory Table
INSERT INTO CHARACTERISTIC VALUES(28, ‘Effortless productivity’, ‘Samsung Dex is available on a Samsung tablet for the first time with Galaxy Tab S4. Get computer-like productivity with the mobility of a tablet. Multi-task simply by connecting to a compatible monitor via a USB-C to HDMI adapter without a DeX station or DeX Pad, and add the Tab S4 book cover keyboard or mouse for even more efficiency. [1]’);
INSERT INTO CHARACTERISTIC VALUES(29, ‘Ready to work’, ‘Put on your work hat. Galaxy Tab S4 works like a PC with a task bar, multi-window capability and familiar gestures like drag & drop. When you want to transition to a PC-like experience, just enable Samsung DeX via the on-screen Quick Panel and add the Tab S4 book cover keyboard and mouse.[2]’);
INSERT INTO CHARACTERISTIC VALUES(30, ‘Enhanced S Pen experience’, ‘The redesigned S Pen offers an authentic handwriting experience—it’s perfect for drawing, taking notes, and communicating in the modern world. With the S Pen you can access advanced translation[4] features and thrill your friends with Live Message.[3]’);
INSERT INTO CHARACTERISTIC VALUES(31, ‘Redesigned for outstanding usability’, ‘The S Pen now features a sophisticated new design. Since it doesn’t require charging, it’s always ready when you need it. The S Pen’s 0.7mm elastomer tip and comfortable size gives the feel of a real pen.’);
INSERT INTO CHARACTERISTIC VALUES(32, ‘Lose yourself in your entertainment’, ‘Galaxy Tab S4 provides an expansive viewing area on a compact device. The 10.5” screen size was made possible by minimising the bezel and removing the physical home button. An improved 16:10 aspect ratio gives the sAMOLED display an immersive viewing experience when viewing your favorite content.’);
INSERT INTO CHARACTERISTIC VALUES(33, ‘Powerful sound’, ‘The Galaxy Tab S4’s quad speakers, tuned by AKG, deliver a rich and powerful sound. The audio is automatically routed to the correct speaker, no matter the screen’s orientation. Enjoy bass that goes straight to the heart.’);
INSERT INTO CHARACTERISTIC VALUES(34, ‘Surround yourself in the sound’, ‘Dolby Atmos surround sound fills all three dimensions and delivers rich, deep, resonant sound with an added overhead dimension that brings the screen to life. Watch a video or listen to music, with or without earphones, and instantly be transported right there. Be captivated, at the heart of the action.’);
INSERT INTO CHARACTERISTIC VALUES(35, ‘Enhanced experience’, ‘With 256GB memory configuration[5], additional memory of up to 400GB through the MicroSD card slot[6], you have plenty of space to store documents and videos.’);
Product Review Table
INSERT INTO CHARACTERISTIC VALUES(36, ‘Binge watch for hours on end’, ‘Keep the fun going. A fully charged Galaxy Tab S4 can play up to 15 hours of video—long enough to finish off that entire season of your favourite TV show.[7] If your battery does run out, bring it to full charge again rapidly with fast charging.’);
INSERT INTO CHARACTERISTIC VALUES(37, ‘Your eyes are the key’, ‘Galaxy Tab S4 now includes iris scanning and facial recognition technology. A quick scan of your face or eyes is all that is needed to unlock your device. Even protect private files and apps with powerful encryption security using bio-authentication together with Secure folder.’);
INSERT INTO CHARACTERISTIC VALUES(38, null, ‘The new Surface Pro delivers the perfect balance of versatility and portability, without sacrificing the performance you need.’);
INSERT INTO CHARACTERISTIC VALUES(39, null, ‘No matter where you are, you”ll have the power to capture your creativity and turn it into your next big idea.’);
INSERT INTO CHARACTERISTIC VALUES(40, null, ‘Sketch your storyboard in the park.’);
INSERT INTO CHARACTERISTIC VALUES(41, null, ‘Code your next hit app in the cafe.’);
INSERT INTO CHARACTERISTIC VALUES(42, null, ‘Compose your masterpiece on the train.’);
INSERT INTO CHARACTERISTIC VALUES(43, null, ‘Type your next novel from the couch.’);
INSERT INTO CHARACTERISTIC VALUES(44, null, ‘Edit your pitch before take-off.’);
INSERT INTO CHARACTERISTIC VALUES(45, null, ‘Create without limits on the new Surface Pro’);
INSERT INTO CHARACTERISTIC VALUES(46, ‘Expect more from your laptop.’, ‘The new Surface Pro adapts to how you work, from powerful laptop to a tablet for entertainment and a studio for writing, sketching and drawing. Always with you for your next big idea, the new surface Pro is the most versatile Surface yet.’);
INSERT INTO CHARACTERISTIC VALUES(47, ‘The power to take you anywhere.’, ‘Built with the latest Intel® Core™ processors, the new Surface Pro is a full-power laptop that can handle anything you throw at it, with all the storage, memory, and battery life you need. Immerse yourself in your creation with Microsoft”s stunning high-resolution PixelSense™ Display, which allows you to read more, do more, and see more. And Dolby® Audio™ Premium sound surrounds you of your next movie, TV show, or call home.’);
INSERT INTO CHARACTERISTIC VALUES(48, ‘Do more with Microsoft.’, ‘Harness the creative power of Windows 10 Creators Update, including new 3D creation tools. Interact with your ideas naturally, with the new Surface Pen and Surface Dial[1]. The new Surface Pro runs the software and apps you love and need, and the world”s best tools from Microsoft Office, including your favourite new pens and pencils which are faster and more responsive than ever before in Word, Powerpoint, Excel, and OneNote. Quit remembering passwords with Windows Hello’);
Product Characteristic Table
INSERT INTO CHARACTERISTIC VALUES(49, null, ‘The W660E is a feature packed Full HD panel with the brightness, colour and detail of High Dynamic Range (HDR). Previously hidden areas of dark shadow and sunlight are now full of clarity and detail. Discover entertainment for everyone with a Sony Smart TV. With internet ready, the possibilities are endless. New to 2017, viewers can take advantage of the PS4 Pro for HDR gaming and can now go online directly to access all contents from YouTube™, Netflix®, Internet TV apps and Internet Browser.’);
INSERT INTO CHARACTERISTIC VALUES(50, ‘One chip, incredibly real’, ‘With Object-based HDR remaster and Super Bit Mapping™ 4K HDR technology, our 4K HDR Processor X1™ reproduces enhanced depth, textures and natural colours. You’ll see pure colours at higher brightness levels for exceptionally realistic pictures.’);
INSERT INTO CHARACTERISTIC VALUES(51, ‘Rediscover every detail in 4K’, ‘With 4K X-Reality PRO, every image is upscaled closer to true 4K quality for remarkable clarity. Images are sharpened and refined in real time, revealing extra detail in the books and architecture of the library.’);
INSERT INTO CHARACTERISTIC VALUES(52, ‘Life’s brilliance, revealed with extra colours’, ‘See vivid real world colours all around you. A TRILUMINOS Display maps colours from a wider palette, faithfully reproducing every shade and hue in the umbrellas.’);
INSERT INTO CHARACTERISTIC VALUES(53, ‘Discover thrilling 4K HDR entertainment’, ‘This TV brings you the excitement of movies and games in 4K HDR. It handles a variety of HDR formats, including HDR10 and Hybrid Log-Gamma.’);
INSERT INTO CHARACTERISTIC VALUES(54, ‘Just talk, a fun way to explore new worlds’, ‘Find all the entertainment you can dream of, as fast as you can talk. With advanced voice control, this 4K HDR TV with Android TV™ brings you movies and TV shows from apps or broadcast in an instant.’);
INSERT INTO CHARACTERISTIC VALUES(55, ‘Designed to keep your focus on the picture’, ‘No distractions, just beautiful pictures. The narrow, exquisitely designed aluminium frame keeps you focused on the screen, while cables stay cleverly hidden at the back and the front.’);
INSERT INTO CHARACTERISTIC VALUES(56, null, ‘ThinQ ® LG ThinQ offers an enhanced interactive experience in the company’s new 2018 TV lineup by employing Natural Language Processing (NLP) to deliver intelligent voice-activated control. OLED Display without Backlight This state-of-the-art OLED Display generates over a billion rich and beautiful colours. Combine this with no backlight, and you also get the most hair raising blacks imaginable for enhanced contrast. Alpha 9 Intelligent Processor The new Alpha 9 Intelligent Processor designed for LG OLED, delivers stunning image performance, noise reduction, image enhancement and colour refinement for a next generation visual experience. 4K Cinema HDR with Dolby Vision 4K Cinema HDR delivers a stunning high dynamic range picture, while Dolby Vision™ dramatically enhances the colour and contrast of content frame-by-frame, for a truly cinematic viewing experience. Dolby Atmos® Enter a new world of sound with Dolby Atmos®. You’ll feel like you’re inside the action as the sounds come alive with breathtaking realism. Dolby Atmos® is sound that creates a powerfully moving entertainment experience.’);
Product Feature Table
INSERT INTO CHARACTERISTIC VALUES(57, ‘Premium UHD. Everything happens here.’, ‘The stunning depth of HDR10+ and dynamic crystal colour helps to create a breathtaking picture.[1]’);
INSERT INTO CHARACTERISTIC VALUES(58, ‘High Dynamic Range, find the hidden details’, ‘Get more from what you watch, with Samsung Premium UHD TV. HDR offers a wide range of brightness levels that help you see fine detail clearly, even in dark and bright scenes.[1]’);
INSERT INTO CHARACTERISTIC VALUES(59, ‘HDR 10+’, ‘HDR 10+ helps bring the content creator’s vision to life. A sophisticated High Dynamic Range technology, it optimises each scene for remarkable HDR expression.[2]’);
INSERT INTO CHARACTERISTIC VALUES(60, ‘Ultra Slim Array’, ‘See details that stand out, with deep contrast levels on Premium UHD TV. The Ultra Slim Array carefully controls the TV”s backlight, helping dark scenes appear darker and bright scenes even brighter.’);
INSERT INTO CHARACTERISTIC VALUES(61, ‘Dynamic Crystal Colour’, ‘See firsthand how dynamic, crystal clear colour can bring images to life. Engineered to provide a wide range of tones and hues, Dynamic Cystal Colour helps create superb viewing experiences.’);
INSERT INTO CHARACTERISTIC VALUES(62, ‘Game Mode, get your best game on Low Input Lag Smooth Motion’, ‘Whether it’s dynamic action or something fun from the arcade, Game Mode can provide outstanding gaming experiences.Low Input Lag: Enjoy dynamic action with fast interaction and low lag.Smooth Motion: Supports smooth motion even when playing games with high graphic quality.’);
INSERT INTO CHARACTERISTIC VALUES(63, ‘4K UHD resolution’, ‘Enjoy sharp, crisp images on a true 4K TV. With 4x more pixels than Samsung Full HD TV, you can see even the small details in each scene.[3]’);
INSERT INTO CHARACTERISTIC VALUES(64, ‘Big moments need a big screen’, ‘Enjoy entertainment on an extreme scale. Discover a breathtaking cinematic experience with an enhanced experience of immersion that helps you feel like you”re part of the game. With vivid colours and precise details on our large screens, you can”t help but see more.’);
INSERT INTO CHARACTERISTIC VALUES(65, ‘Boundless Design’, ‘Get ready to dive into your Premium UHD TV. Almost bezel-less on three sides, the sleek design help take you to another level of immersive viewing.’);
INSERT INTO CHARACTERISTIC VALUES(66, ‘An intelligent way to enjoy the smart TV’, ‘Find your entertainment the easy way. Control your devices with the One Remote Control[5] and a simple hub to help you search less, and watch more. Enjoying TV has never been so easy![4] ‘);
INSERT INTO CHARACTERISTIC VALUES(67, ‘One Remote Control’, ‘Easily access and control connected devices and content with just One Remote Control. Its auto detection feature can connect and label connected devices, for quick and simple access. Easy to find, easy to use and just One Remote Control.[5]’);
Product Detail Table
INSERT INTO CHARACTERISTIC VALUES(68, ‘SmartThings’, ‘Keep your compatible smart devices connected. SmartThings enables Premium UHD TV to connect various compatible smart home devices, from fridge to mobile to washing machine, for seamless interaction.[6]’);
INSERT INTO CHARACTERISTIC VALUES(69, ‘Notifications’, ‘Know what’s happening without leaving the comfort of your sofa. Receive pop-up messages on your TV, including status updates for home IoT devices, calendar reminders and notifications for when your favourite shows are on. You can even have notifications sent to your compatible mobile.[6]’);
INSERT INTO CHARACTERISTIC VALUES(70, ‘Steam Link’, ‘Enjoy your high speed PC games on the TV via Steamlink. Play favourite PC games on a big screen and ampify your fun.[7]’);
— PAUSE ‘Insert PRODUCTCHARACTERISTIC values’
INSERT INTO PRODUCTCHARACTERISTIC VALUES(1, 1);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(1, 2);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(1, 3);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(1, 4);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(1, 5);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(1, 6);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(1, 7);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(1, 8);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(1, 9);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(1, 10);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(1, 11);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(2, 12);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(2, 13);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(2, 14);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(2, 15);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(2, 16);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(2, 17);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(2, 18);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(2, 19);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(2, 20);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(2, 21);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(2, 22);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(2, 23);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(2, 24);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(3, 25);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(4, 25);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(5, 26);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(6, 27);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(7, 28);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(7, 29);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(7, 30);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(7, 31);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(7, 32);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(7, 33);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(7, 34);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(7, 35);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(7, 36);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(7, 37);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(8, 38);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(8, 39);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(8, 40);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(8, 41);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(8, 42);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(8, 43);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(8, 44);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(8, 45);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(8, 46);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(8, 47);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(8, 48);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(9, 49);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(10, 50);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(10, 51);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(10, 52);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(10, 53);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(10, 54);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(10, 55);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(11, 56);
Category Subcategory Table
INSERT INTO PRODUCTCHARACTERISTIC VALUES(12, 57);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(12, 58);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(12, 59);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(12, 60);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(12, 61);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(12, 62);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(12, 63);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(12, 64);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(12, 65);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(12, 66);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(12, 67);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(12, 68);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(12, 69);
INSERT INTO PRODUCTCHARACTERISTIC VALUES(12, 70);
— PAUSE ‘Insert FEATURE values’
INSERT INTO FEATURE VALUES(1, null, ‘All new intelligent S Pen’);
INSERT INTO FEATURE VALUES(2, null, ‘6.4″ Infinity Display with Quad HD+ resolution’);
INSERT INTO FEATURE VALUES(3, null, ’12MP Super Speed Dual Camera with intelligent scene recognition’);
INSERT INTO FEATURE VALUES(4, null, ‘Long lasting 4,000mAh battery’);
INSERT INTO FEATURE VALUES(5, null, ‘8GB RAM’);
INSERT INTO FEATURE VALUES(6, null, ‘512GB storage’);
INSERT INTO FEATURE VALUES(7, null, ‘Water and dust resistant (IP68)’);
INSERT INTO FEATURE VALUES(8, null, ‘Hybrid SIM option for a second SIM’);
INSERT INTO FEATURE VALUES(9, null, ’12MP Super Speed Dual Camera with Super Slow-mo up to 960fps’);
INSERT INTO FEATURE VALUES(10, null, ‘6.2″ Infinity Display with Quad HD+ resolution’);
INSERT INTO FEATURE VALUES(11, null, ‘Stereo speakers with Dolby Atmos’);
INSERT INTO FEATURE VALUES(12, null, ‘Water and dust resistant (IP68)[1]’);
INSERT INTO FEATURE VALUES(13, null, ‘256GB[2] storage’);
INSERT INTO FEATURE VALUES(14, null, ‘Secure iris and face recognition technology’);
INSERT INTO FEATURE VALUES(15, null, ‘Fast wired and wireless charging[3]’);
INSERT INTO FEATURE VALUES(16, null, ‘New 10nm Octa Core chip’);
INSERT INTO FEATURE VALUES(17, null, ‘5.8-inch Super Retina HD display with HDR and True Tone1’);
INSERT INTO FEATURE VALUES(18, null, ‘All-glass and stainless steel design; water and dust resistance3’);
INSERT INTO FEATURE VALUES(19, null, ’12-megapixel dual cameras with dual OIS, Portrait mode, Portrait Lighting and 4K video up to 60 fps4′);
INSERT INTO FEATURE VALUES(20, null, ‘7-megapixel TrueDepth front camera with Portrait mode and Portrait Lighting4’);
INSERT INTO FEATURE VALUES(21, null, ‘Face ID for secure authentication and Apple Pay’);
INSERT INTO FEATURE VALUES(22, null, ‘A11 Bionic, the smartest and most powerful chip in a smartphone’);
INSERT INTO FEATURE VALUES(23, null, ‘Wireless charging — works with Qi chargers2’);
INSERT INTO FEATURE VALUES(31, null, ‘10.5-inch Retina display1’);
INSERT INTO FEATURE VALUES(32, null, ‘A10X Fusion chip with 64-bit desktop-class architecture’);
INSERT INTO FEATURE VALUES(33, null, ‘Touch ID fingerprint sensor’);
INSERT INTO FEATURE VALUES(34, null, ’12-megapixel camera with 4K HD video’);
INSERT INTO FEATURE VALUES(35, null, ‘7-megapixel FaceTime HD camera’);
INSERT INTO FEATURE VALUES(36, null, ‘802.11ac Wi-Fi with MIMO’);
Product Subcategory Table
INSERT INTO FEATURE VALUES(37, null, ‘Up to 10 hours of battery life3’);
INSERT INTO FEATURE VALUES(38, null, ‘Four Speaker Audio’);
INSERT INTO FEATURE VALUES(39, null, ‘9.7-inch Multi-Touch Retina display1’);
INSERT INTO FEATURE VALUES(40, null, ‘A10 Fusion chip’);
INSERT INTO FEATURE VALUES(41, null, ‘Supports Apple Pencil2 (sold separately)’);
INSERT INTO FEATURE VALUES(42, null, ‘8-megapixel camera’);
INSERT INTO FEATURE VALUES(43, null, ‘FaceTime HD camera’);
INSERT INTO FEATURE VALUES(44, null, ‘Touch ID and Apple Pay3’);
INSERT INTO FEATURE VALUES(45, null, ‘Wi-Fi and 4G LTE4’);
INSERT INTO FEATURE VALUES(46, null, ‘All-day battery life5’);
INSERT INTO FEATURE VALUES(47, null, ‘iOS 11’);
INSERT INTO FEATURE VALUES(48, null, ‘10.5″ QHD (2560×1600) sAMOLED touch display’);
INSERT INTO FEATURE VALUES(49, null, ‘Qualcomm Snapdragon 835 (Quad 2.35GHz + Quad 1.9GHz)’);
INSERT INTO FEATURE VALUES(50, null, ‘4GB RAM’);
INSERT INTO FEATURE VALUES(51, null, ‘256GB SSD storage (expandable via optional microSD card, up to 400GB)’);
INSERT INTO FEATURE VALUES(52, null, ‘Samsung S pen’);
INSERT INTO FEATURE VALUES(53, null, ‘Quad speakers tuned by AKG with Dolby Atmos 3D audio’);
INSERT INTO FEATURE VALUES(54, null, ’13MP rear camera’);
INSERT INTO FEATURE VALUES(55, null, ‘8MP front camera’);
INSERT INTO FEATURE VALUES(56, null, ‘Iris scanning and facial recognition’);
INSERT INTO FEATURE VALUES(57, null, ‘Wi-Fi + Bluetooth v5.0’);
INSERT INTO FEATURE VALUES(58, null, ‘Headphone output’);
INSERT INTO FEATURE VALUES(59, null, ‘Samsung DeX enabled’);
INSERT INTO FEATURE VALUES(60, null, ‘12.3” PixelSense™ Display’);
INSERT INTO FEATURE VALUES(61, null, ‘2736 x 1824 (267 PPI) Resolution’);
INSERT INTO FEATURE VALUES(62, null, ’10 Point Multi-touch with 6th Generation Microsoft Touch Architecture’);
INSERT INTO FEATURE VALUES(63, null, ‘Corning® Gorilla® Glass 4’);
INSERT INTO FEATURE VALUES(64, null, ‘7th Generation Intel® Core™ i7-7660U’);
INSERT INTO FEATURE VALUES(65, null, ’16GB RAM’);
INSERT INTO FEATURE VALUES(66, null, ‘1TB SSD’);
INSERT INTO FEATURE VALUES(67, null, ‘Intel® Iris™ Plus Graphics 640’);
INSERT INTO FEATURE VALUES(68, null, ‘Bluetooth 4.1’);
INSERT INTO FEATURE VALUES(69, null, ‘Dolby® Audio™ Premium’);
INSERT INTO FEATURE VALUES(70, null, ‘5.0MP front-facing camera with 1080p Skype HD video’);
INSERT INTO FEATURE VALUES(71, null, ‘8.0MP rear-facing autofocus camera with 1080p Full HD video’);
INSERT INTO FEATURE VALUES(72, null, ‘Windows 10 Pro’);
INSERT INTO FEATURE VALUES(73, null, ’32” Full HD HDR Panel 1920×1080′);
INSERT INTO FEATURE VALUES(74, null, ‘Edge LED Backlighting’);
INSERT INTO FEATURE VALUES(75, null, ‘HD Upscaling’);
INSERT INTO FEATURE VALUES(76, null, ‘Movie/Cinema Mode’);
INSERT INTO FEATURE VALUES(77, null, ‘Dolby Digital’);
INSERT INTO FEATURE VALUES(78, null, ‘Built-In Wi-Fi’);
INSERT INTO FEATURE VALUES(79, null, ‘DLNA’);
INSERT INTO FEATURE VALUES(80, null, ‘2 x HDMI Inputs’);
INSERT INTO FEATURE VALUES(81, null, ‘1 x USB Port’);
INSERT INTO FEATURE VALUES(82, null, ‘1 x Ethernet Port’);
INSERT INTO FEATURE VALUES(83, null, ‘4K UHD (3840×2160) High Dynamic Range’);
INSERT INTO FEATURE VALUES(84, null, ‘4K HDR Processor X1’);
INSERT INTO FEATURE VALUES(85, null, ‘4K X-Reality PRO’);
INSERT INTO FEATURE VALUES(86, null, ‘Android TV’);
INSERT INTO FEATURE VALUES(87, null, ‘TRILUMINOS Display’);
INSERT INTO FEATURE VALUES(88, null, ‘Motionflow XR 800 (200 Hz Equivalent)’);
INSERT INTO FEATURE VALUES(89, null, ‘Super Bit Mapping™ 4K HDR’);
INSERT INTO FEATURE VALUES(90, null, ‘Object-based HDR remaster’);
INSERT INTO FEATURE VALUES(91, null, ‘Chromecast Built-In’);
INSERT INTO FEATURE VALUES(92, null, ‘ClearAudio+’);
INSERT INTO FEATURE VALUES(93, null, ‘Cinematic S-Force Front Surround’);
INSERT INTO FEATURE VALUES(94, null, ‘4 x HDMI Input’);
INSERT INTO FEATURE VALUES(95, null, ‘3 x USB Ports’);
INSERT INTO FEATURE VALUES(96, ‘AI ThinQ’, ‘LG AI ThinQ offers an enhanced interactive experience in the company’s new 2018 TV lineup by employing Natural Language Processing (NLP) to deliver intelligent voice-activated control.’);
INSERT INTO FEATURE VALUES(97, ‘Nano Cell Technology’, ‘Nano Cell Technology with IPS provides breathtakingly vivid and eye catching colour even at wide viewing angles, for an amazing experience.’);
INSERT INTO FEATURE VALUES(98, ‘4K Cinema HDR with Dolby Vision’, ‘4K Cinema HDR delivers a stunning high dynamic range picture, while Dolby Vision™ dramatically enhances the colour and contrast of content frame-by-frame, for a truly cinematic viewing experience.’);
INSERT INTO FEATURE VALUES(99, ‘Full Array Dimming’, ‘Full Array Dimming actively dims the backlight on your TV, significantly improving black levels for better contrast.’);
INSERT INTO FEATURE VALUES(100, null, ‘Ultra HD (3840 x 2160) screen’);
INSERT INTO FEATURE VALUES(101, null, ‘HDR10+ compatible’);
INSERT INTO FEATURE VALUES(102, null, ‘200Hz Motion Refresh Rate’);
INSERT INTO FEATURE VALUES(103, null, ‘Dolby Digital Plus’);
INSERT INTO FEATURE VALUES(104, null, ‘Samsung SMART TV’);
INSERT INTO FEATURE VALUES(105, null, ‘One Remote Control’);
INSERT INTO FEATURE VALUES(106, null, ‘Steam Link’);
INSERT INTO FEATURE VALUES(107, null, ‘4 x HDMI’);
INSERT INTO FEATURE VALUES(108, null, ‘2 x USB’);
— PAUSE ‘Insert PRODUCTFEATURE values’
INSERT INTO PRODUCTFEATURE VALUES(1, 1);
INSERT INTO PRODUCTFEATURE VALUES(1, 2);
INSERT INTO PRODUCTFEATURE VALUES(1, 3);
INSERT INTO PRODUCTFEATURE VALUES(1, 4);
INSERT INTO PRODUCTFEATURE VALUES(1, 5);
INSERT INTO PRODUCTFEATURE VALUES(1, 6);
INSERT INTO PRODUCTFEATURE VALUES(1, 7);
INSERT INTO PRODUCTFEATURE VALUES(1, 8);
INSERT INTO PRODUCTFEATURE VALUES(2, 9);
INSERT INTO PRODUCTFEATURE VALUES(2, 10);
INSERT INTO PRODUCTFEATURE VALUES(2, 11);
INSERT INTO PRODUCTFEATURE VALUES(2, 12);
INSERT INTO PRODUCTFEATURE VALUES(2, 13);
INSERT INTO PRODUCTFEATURE VALUES(2, 14);
INSERT INTO PRODUCTFEATURE VALUES(2, 15);
INSERT INTO PRODUCTFEATURE VALUES(2, 16);
INSERT INTO PRODUCTFEATURE VALUES(3, 17);
INSERT INTO PRODUCTFEATURE VALUES(4, 17);
INSERT INTO PRODUCTFEATURE VALUES(3, 18);
INSERT INTO PRODUCTFEATURE VALUES(4, 18);
INSERT INTO PRODUCTFEATURE VALUES(3, 19);
INSERT INTO PRODUCTFEATURE VALUES(4, 19);
INSERT INTO PRODUCTFEATURE VALUES(3, 20);
INSERT INTO PRODUCTFEATURE VALUES(4, 20);
INSERT INTO PRODUCTFEATURE VALUES(3, 21);
INSERT INTO PRODUCTFEATURE VALUES(4, 21);
INSERT INTO PRODUCTFEATURE VALUES(3, 22);
INSERT INTO PRODUCTFEATURE VALUES(4, 22);
INSERT INTO PRODUCTFEATURE VALUES(3, 23);
INSERT INTO PRODUCTFEATURE VALUES(4, 23);
INSERT INTO PRODUCTFEATURE VALUES(5, 31);
INSERT INTO PRODUCTFEATURE VALUES(5, 32);
INSERT INTO PRODUCTFEATURE VALUES(5, 33);
INSERT INTO PRODUCTFEATURE VALUES(5, 34);
INSERT INTO PRODUCTFEATURE VALUES(5, 35);
INSERT INTO PRODUCTFEATURE VALUES(5, 36);
INSERT INTO PRODUCTFEATURE VALUES(5, 37);
INSERT INTO PRODUCTFEATURE VALUES(5, 38);
INSERT INTO PRODUCTFEATURE VALUES(6, 39);
INSERT INTO PRODUCTFEATURE VALUES(6, 40);
INSERT INTO PRODUCTFEATURE VALUES(6, 41);
INSERT INTO PRODUCTFEATURE VALUES(6, 42);
INSERT INTO PRODUCTFEATURE VALUES(6, 43);
INSERT INTO PRODUCTFEATURE VALUES(6, 44);
INSERT INTO PRODUCTFEATURE VALUES(6, 45);
INSERT INTO PRODUCTFEATURE VALUES(6, 46);
INSERT INTO PRODUCTFEATURE VALUES(6, 47);
INSERT INTO PRODUCTFEATURE VALUES(7, 48);
INSERT INTO PRODUCTFEATURE VALUES(7, 49);
INSERT INTO PRODUCTFEATURE VALUES(7, 50);
INSERT INTO PRODUCTFEATURE VALUES(7, 51);
INSERT INTO PRODUCTFEATURE VALUES(7, 52);
INSERT INTO PRODUCTFEATURE VALUES(7, 53);
INSERT INTO PRODUCTFEATURE VALUES(7, 54);
INSERT INTO PRODUCTFEATURE VALUES(7, 55);
INSERT INTO PRODUCTFEATURE VALUES(7, 56);
INSERT INTO PRODUCTFEATURE VALUES(7, 57);
INSERT INTO PRODUCTFEATURE VALUES(7, 58);
INSERT INTO PRODUCTFEATURE VALUES(7, 59);
INSERT INTO PRODUCTFEATURE VALUES(8, 60);
INSERT INTO PRODUCTFEATURE VALUES(8, 61);
INSERT INTO PRODUCTFEATURE VALUES(8, 62);
INSERT INTO PRODUCTFEATURE VALUES(8, 63);
INSERT INTO PRODUCTFEATURE VALUES(8, 64);
INSERT INTO PRODUCTFEATURE VALUES(8, 65);
INSERT INTO PRODUCTFEATURE VALUES(8, 66);
INSERT INTO PRODUCTFEATURE VALUES(8, 67);
INSERT INTO PRODUCTFEATURE VALUES(8, 68);
INSERT INTO PRODUCTFEATURE VALUES(8, 69);
INSERT INTO PRODUCTFEATURE VALUES(8, 70);
INSERT INTO PRODUCTFEATURE VALUES(8, 71);
INSERT INTO PRODUCTFEATURE VALUES(8, 72);
INSERT INTO PRODUCTFEATURE VALUES(9, 73);
INSERT INTO PRODUCTFEATURE VALUES(9, 74);
INSERT INTO PRODUCTFEATURE VALUES(9, 75);
INSERT INTO PRODUCTFEATURE VALUES(9, 76);
INSERT INTO PRODUCTFEATURE VALUES(9, 77);
INSERT INTO PRODUCTFEATURE VALUES(9, 78);
INSERT INTO PRODUCTFEATURE VALUES(9, 79);
INSERT INTO PRODUCTFEATURE VALUES(9, 80);
INSERT INTO PRODUCTFEATURE VALUES(9, 81);
INSERT INTO PRODUCTFEATURE VALUES(9, 82);
INSERT INTO PRODUCTFEATURE VALUES(10, 83);
INSERT INTO PRODUCTFEATURE VALUES(10, 84);
INSERT INTO PRODUCTFEATURE VALUES(10, 85);
INSERT INTO PRODUCTFEATURE VALUES(10, 86);
INSERT INTO PRODUCTFEATURE VALUES(10, 87);
INSERT INTO PRODUCTFEATURE VALUES(10, 88);
INSERT INTO PRODUCTFEATURE VALUES(10, 89);
INSERT INTO PRODUCTFEATURE VALUES(10, 90);
INSERT INTO PRODUCTFEATURE VALUES(10, 91);
INSERT INTO PRODUCTFEATURE VALUES(10, 92);
INSERT INTO PRODUCTFEATURE VALUES(10, 93);
INSERT INTO PRODUCTFEATURE VALUES(10, 94);
INSERT INTO PRODUCTFEATURE VALUES(10, 95);
INSERT INTO PRODUCTFEATURE VALUES(11, 96);
INSERT INTO PRODUCTFEATURE VALUES(11, 97);
INSERT INTO PRODUCTFEATURE VALUES(11, 98);
INSERT INTO PRODUCTFEATURE VALUES(11, 99);
INSERT INTO PRODUCTFEATURE VALUES(12, 100);
INSERT INTO PRODUCTFEATURE VALUES(12, 101);
INSERT INTO PRODUCTFEATURE VALUES(12, 102);
INSERT INTO PRODUCTFEATURE VALUES(12, 103);
INSERT INTO PRODUCTFEATURE VALUES(12, 104);
INSERT INTO PRODUCTFEATURE VALUES(12, 105);
INSERT INTO PRODUCTFEATURE VALUES(12, 106);
INSERT INTO PRODUCTFEATURE VALUES(12, 107);
INSERT INTO PRODUCTFEATURE VALUES(12, 108);
— PAUSE ‘Insert DETAIL values’
INSERT INTO DETAIL VALUES(426, ’12V DC input ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(201, ‘3D ‘, ‘No’);
INSERT INTO DETAIL VALUES(257, ‘4K streaming compatible ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(256, ‘4K Ultra HD disc compatible ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(56, ‘A2DP ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(386, ‘Analog tuner ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(77, ‘Apple connector type ‘, ‘Lightning’);
INSERT INTO DETAIL VALUES(199, ‘Backlighting type ‘, ‘Edge LED’);
INSERT INTO DETAIL VALUES(255, ‘Backlighting type ‘, ‘Edge-lit’);
INSERT INTO DETAIL VALUES(37, ‘Battery capacity (mAh) ‘, ‘3500’);
INSERT INTO DETAIL VALUES(4, ‘Battery capacity (mAh) ‘, ‘4000’);
INSERT INTO DETAIL VALUES(190, ‘Battery life ‘, ‘Up to 13.5 hours of local video playback’);
INSERT INTO DETAIL VALUES(185, ‘Bluetooth ‘, ‘v4.1’);
INSERT INTO DETAIL VALUES(119, ‘Bluetooth ‘, ‘v4.2’);
INSERT INTO DETAIL VALUES(25, ‘Bluetooth ‘, ‘v5.0’);
INSERT INTO DETAIL VALUES(411, ‘Bluetooth ‘, ‘Yes’);
INSERT INTO DETAIL VALUES(211, ‘Broadcast decoding ‘, ‘DVB-T/T2’);
INSERT INTO DETAIL VALUES(388, ‘Broadcast decoding ‘, ‘MPEG-2’);
INSERT INTO DETAIL VALUES(266, ‘Broadcast decoding ‘, ‘MPEG-4’);
INSERT INTO DETAIL VALUES(19, ‘Built-in flash’, ‘TRUE’);
INSERT INTO DETAIL VALUES(234, ‘Cables included ‘, ‘NA’);
INSERT INTO DETAIL VALUES(163, ‘Card reader ‘, ‘microSD’);
INSERT INTO DETAIL VALUES(187, ‘Card reader ‘, ‘MicroSDXC Card Reader’);
INSERT INTO DETAIL VALUES(14, ‘Colour ‘, ‘Black’);
INSERT INTO DETAIL VALUES(29, ‘Colour ‘, ‘Blue’);
INSERT INTO DETAIL VALUES(85, ‘Colour ‘, ‘Grey’);
INSERT INTO DETAIL VALUES(60, ‘Colour ‘, ‘Silver’);
INSERT INTO DETAIL VALUES(403, ‘Compatible audio files ‘, ‘MP3, FLAC, WAVE,’);
INSERT INTO DETAIL VALUES(335, ‘Compatible audio files ‘, ‘MP3/WAV/WMA/OGG/FLAC’);
INSERT INTO DETAIL VALUES(221, ‘Compatible audio files ‘, ‘MPEG1/MPEG2PS/MPEG2TS/AVCHD/MP4Part10/MP4Part2/AVI(XVID)/AVI(MotionJpeg)/WMV9/MKV/WEBM/WAV/MP3/WMA/JPEG’);
INSERT INTO DETAIL VALUES(222, ‘Compatible picture files ‘, ‘JPEG’);
INSERT INTO DETAIL VALUES(404, ‘Compatible picture files ‘, ‘JPEG, Bitmap, GIF, PNG’);
INSERT INTO DETAIL VALUES(336, ‘Compatible picture files ‘, ‘JPEG/PNG/BMP’);
INSERT INTO DETAIL VALUES(334, ‘Compatible video files ‘, ‘ASF/WMV/AVI (Xvid, H.264/AVC)/MP4/M4v/MOV (H.264, H.265, MPEG-4, HEVC)/MKV (MPEG-2, MPEG-4, H.264, H.265, VP8, VP9, HEVC) SHVC/TS/TRP/TP/MTS/MPG/3GP/3G2 MPEG/DAT/VOB/HEVC (Up to [email protected] 50Mbps)’);
INSERT INTO DETAIL VALUES(220, ‘Compatible video files ‘, ‘MPEG1/MPEG2PS/MPEG2TS/AVCHD/MP4Part10/MP4Part2/AVI(XVID)/AVI(MotionJpeg)/WMV9/MKV/WEBM/WAV/MP3/WMA/JPEG’);
INSERT INTO DETAIL VALUES(402, ‘Compatible video files ‘, ‘MPEG4, AAC, AVI, MOV, GIF’);
INSERT INTO DETAIL VALUES(284, ‘Component inputs ‘, ‘1’);
INSERT INTO DETAIL VALUES(170, ‘Computer type ‘, ‘2 in 1’);
INSERT INTO DETAIL VALUES(277, ‘Connected home features ‘, ‘Yes’);
INSERT INTO DETAIL VALUES(61, ‘Device screen size (inches) ‘, ‘5.8’);
INSERT INTO DETAIL VALUES(30, ‘Device screen size (inches) ‘, ‘6.2’);
INSERT INTO DETAIL VALUES(1, ‘Device screen size (inches) ‘, ‘6.4’);
INSERT INTO DETAIL VALUES(352, ‘Digital audio inputs ‘, ‘Optical (TOSLINK)’);
INSERT INTO DETAIL VALUES(285, ‘Digital audio output ‘, ‘Optical (TOSLINK)’);
INSERT INTO DETAIL VALUES(210, ‘Digital Tuner(s) ‘, ‘1(Digital/Analog)’);
INSERT INTO DETAIL VALUES(320, ‘Digital Tuner(s) ‘, ‘DVB-T2’);
INSERT INTO DETAIL VALUES(46, ‘Digital zoom ‘, ‘2’);
INSERT INTO DETAIL VALUES(127, ‘Display size (inches) ‘, ‘9.7’);
INSERT INTO DETAIL VALUES(109, ‘Display size (inches) ‘, ‘10.5’);
INSERT INTO DETAIL VALUES(172, ‘Display size (inches) ‘, ‘12.3’);
INSERT INTO DETAIL VALUES(18, ‘Display type ‘, ‘sAMOLED’);
INSERT INTO DETAIL VALUES(32, ‘Display type ‘, ‘Super AMOLED’);
INSERT INTO DETAIL VALUES(227, ‘DLNA ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(317, ‘Dolby Digital ‘, ‘Dolby Atmos’);
INSERT INTO DETAIL VALUES(205, ‘Dolby Digital ‘, ‘Dolby Digital Plus/Dolby Digital’);
INSERT INTO DETAIL VALUES(383, ‘Dolby Digital ‘, ‘Dolby Digital TrueHD’);
INSERT INTO DETAIL VALUES(260, ‘Dolby Digital ‘, ‘Dolby Digital, Dolby Digital Plus, Dolby Pulse’);
INSERT INTO DETAIL VALUES(261, ‘DTS ‘, ‘DTS Digital Surround’);
INSERT INTO DETAIL VALUES(206, ‘DTS ‘, ‘Yes’);
INSERT INTO DETAIL VALUES(20, ‘Dual sim ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(224, ‘e-Manual’, ‘TRUE’);
INSERT INTO DETAIL VALUES(338, ‘EPG (program guide) ‘, ‘8 day’);
INSERT INTO DETAIL VALUES(223, ‘EPG (program guide) ‘, ‘Yes’);
INSERT INTO DETAIL VALUES(233, ‘Estimated yearly electricity use (kWh) ‘, ‘146’);
INSERT INTO DETAIL VALUES(288, ‘Estimated yearly electricity use (kWh) ‘, ‘532’);
INSERT INTO DETAIL VALUES(231, ‘Ethernet / LAN ports ‘, ‘1’);
INSERT INTO DETAIL VALUES(16, ‘Expandable memory format ‘, ‘Micro SD card’);
INSERT INTO DETAIL VALUES(157, ‘Expandable memory format ‘, ‘MicroSD’);
INSERT INTO DETAIL VALUES(35, ‘Expandable memory up to ‘, ‘256’);
INSERT INTO DETAIL VALUES(9, ‘Expandable memory up to ‘, ‘400GB’);
INSERT INTO DETAIL VALUES(45, ‘Face detection ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(114, ‘Flash storage ‘, ‘256GB’);
INSERT INTO DETAIL VALUES(132, ‘Flash storage ‘, ’32GB’);
INSERT INTO DETAIL VALUES(135, ‘Front camera (MP) ‘, ‘1.2’);
INSERT INTO DETAIL VALUES(182, ‘Front camera (MP) ‘, ‘5’);
INSERT INTO DETAIL VALUES(117, ‘Front camera (MP) ‘, ‘7’);
INSERT INTO DETAIL VALUES(2, ‘Front camera (MP) ‘, ‘8’);
INSERT INTO DETAIL VALUES(70, ‘Front camera (MP) ‘, ’12’);
INSERT INTO DETAIL VALUES(21, ‘GPS ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(180, ‘Graphics processor ‘, ‘Intel® Iris™ Plus Graphics 640’);
INSERT INTO DETAIL VALUES(325, ‘HbbTV ‘, ‘FreeviewPlus’);
INSERT INTO DETAIL VALUES(217, ‘HbbTV ‘, ‘Yes’);
INSERT INTO DETAIL VALUES(118, ‘HD recording ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(229, ‘HDMI inputs ‘, ‘2’);
INSERT INTO DETAIL VALUES(280, ‘HDMI inputs ‘, ‘4’);
INSERT INTO DETAIL VALUES(228, ‘HDMI-CEC’, ‘TRUE’);
INSERT INTO DETAIL VALUES(198, ‘HDR (High Dynamic Range) ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(53, ‘Headphone output (3.5mm) ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(34, ‘Internal memory ‘, ‘256GB’);
INSERT INTO DETAIL VALUES(11, ‘Internal memory ‘, ‘512GB’);
INSERT INTO DETAIL VALUES(90, ‘Internal memory ‘, ’64GB’);
INSERT INTO DETAIL VALUES(308, ‘Local dimming ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(81, ‘Manufacturer”s warranty ‘, ‘1 Year’);
INSERT INTO DETAIL VALUES(7, ‘Manufacturer”s warranty ‘, ‘2 years’);
INSERT INTO DETAIL VALUES(343, ‘MHL (Mobile Link) ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(327, ‘Motion control ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(24, ‘Movie recording ‘, ‘Ultra HD’);
INSERT INTO DETAIL VALUES(203, ‘Movie/cinema Mode (24 FPS) ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(50, ‘MP3 ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(10, ‘Network compatibility ‘, ‘4G’);
INSERT INTO DETAIL VALUES(22, ‘NFC ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(314, ‘Noise reduction ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(381, ‘NTSC to PAL conversion ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(216, ‘Other apps ‘, ‘Yes’);
INSERT INTO DETAIL VALUES(246, ‘Packaged Depth (mm) ‘, ‘152’);
INSERT INTO DETAIL VALUES(300, ‘Packaged Depth (mm) ‘, ‘190’);
INSERT INTO DETAIL VALUES(434, ‘Packaged Depth (mm) ‘, ‘230’);
INSERT INTO DETAIL VALUES(362, ‘Packaged Depth (mm) ‘, ‘285’);
INSERT INTO DETAIL VALUES(244, ‘Packaged Height (mm) ‘, ‘822’);
INSERT INTO DETAIL VALUES(298, ‘Packaged Height (mm) ‘, ‘1086’);
INSERT INTO DETAIL VALUES(432, ‘Packaged Height (mm) ‘, ‘1121’);
INSERT INTO DETAIL VALUES(360, ‘Packaged Height (mm) ‘, ‘1130’);
INSERT INTO DETAIL VALUES(247, ‘Packaged Weight (kg) ‘, ‘9’);
INSERT INTO DETAIL VALUES(363, ‘Packaged Weight (kg) ‘, ‘46.5’);
INSERT INTO DETAIL VALUES(435, ‘Packaged Weight (kg) ‘, ‘51.7’);
INSERT INTO DETAIL VALUES(301, ‘Packaged Weight (kg) ‘, ’53’);
INSERT INTO DETAIL VALUES(245, ‘Packaged Width (mm) ‘, ‘525’);
INSERT INTO DETAIL VALUES(299, ‘Packaged Width (mm) ‘, ‘1886’);
INSERT INTO DETAIL VALUES(433, ‘Packaged Width (mm) ‘, ‘1891’);
INSERT INTO DETAIL VALUES(361, ‘Packaged Width (mm) ‘, ‘1895’);
INSERT INTO DETAIL VALUES(271, ‘Parental Controls ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(283, ‘PC Input ‘, ‘HDMI’);
INSERT INTO DETAIL VALUES(420, ‘PC Input ‘, ‘VGA, HDMI, DVI’);
INSERT INTO DETAIL VALUES(232, ‘PC Input ‘, ‘Yes’);
INSERT INTO DETAIL VALUES(13, ‘Phone Operating System ‘, ‘Android’);
INSERT INTO DETAIL VALUES(57, ‘Phone Operating System ‘, ‘iOS’);
INSERT INTO DETAIL VALUES(27, ‘Phone Type ‘, ‘Galaxy S9+’);
INSERT INTO DETAIL VALUES(58, ‘Phone Type ‘, ‘iPhone X’);
INSERT INTO DETAIL VALUES(316, ‘Picture In Picture ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(313, ‘Picture Modes ‘, ’10 (Vivid, Standard, Technicolor, APS, Cinema, Cricket, Game, HDR Effect, ISF Bright Room, ISF Dark Room)’);
INSERT INTO DETAIL VALUES(378, ‘Picture Modes ‘, ‘Dynamic, Standard, Natural, Movie’);
INSERT INTO DETAIL VALUES(258, ‘Picture Modes ‘, ‘Vivid,Standard,Custom,Cinema Pro,Cinema Home,Sports,Animation,Photo-Vivid,Photo-Standard,Photo-Custom,Game,Graphics’);
INSERT INTO DETAIL VALUES(259, ‘Picture Modes ‘, ‘Vivid,Standard,Custom,Cinema,Sports,Photo-Vivid,Photo-Standard,Photo-Custom,Game,Graphics,HDR Game,HDR Cinema’);
INSERT INTO DETAIL VALUES(67, ‘Processor ‘, ‘Apple A11 Bionic’);
INSERT INTO DETAIL VALUES(39, ‘Processor ‘, ‘Samsung Exynos 9 Octa-Core’);
INSERT INTO DETAIL VALUES(152, ‘Processor Clock Speed (GHz) ‘, ‘2.35’);
INSERT INTO DETAIL VALUES(150, ‘Processor Cores ‘, ‘Quad Core’);
INSERT INTO DETAIL VALUES(112, ‘Processor Model Number ‘, ‘A10X Fusion’);
INSERT INTO DETAIL VALUES(15, ‘Processor Model Number ‘, ‘Exynos 9810’);
INSERT INTO DETAIL VALUES(176, ‘Processor Model Number ‘, ‘i7-7660U’);
INSERT INTO DETAIL VALUES(151, ‘Processor Model Number ‘, ‘Qualcomm Snapdragon 835’);
INSERT INTO DETAIL VALUES(130, ‘Processor Type ‘, ‘Apple A10 Fusion’);
INSERT INTO DETAIL VALUES(175, ‘Processor Type ‘, ‘Intel Core i7’);
INSERT INTO DETAIL VALUES(430, ‘Product Depth with Stand (mm) ‘, ‘57.6’);
INSERT INTO DETAIL VALUES(238, ‘Product Depth with Stand (mm) ‘, ‘187’);
INSERT INTO DETAIL VALUES(358, ‘Product Depth with Stand (mm) ‘, ‘253’);
INSERT INTO DETAIL VALUES(292, ‘Product Depth with Stand (mm) ‘, ‘371’);
INSERT INTO DETAIL VALUES(296, ‘Product Depth without Stand (mm) ‘, ’54’);
INSERT INTO DETAIL VALUES(242, ‘Product Depth without Stand (mm) ‘, ’70’);
INSERT INTO DETAIL VALUES(236, ‘Product Height with Stand (mm) ‘, ‘731’);
INSERT INTO DETAIL VALUES(428, ‘Product Height with Stand (mm) ‘, ‘964.1’);
INSERT INTO DETAIL VALUES(290, ‘Product Height with Stand (mm) ‘, ‘1031’);
INSERT INTO DETAIL VALUES(356, ‘Product Height with Stand (mm) ‘, ‘1052’);
INSERT INTO DETAIL VALUES(240, ‘Product Height without Stand (mm) ‘, ‘731’);
INSERT INTO DETAIL VALUES(294, ‘Product Height without Stand (mm) ‘, ‘963’);
INSERT INTO DETAIL VALUES(239, ‘Product Weight with Stand (kg) ‘, ‘6.2’);
INSERT INTO DETAIL VALUES(431, ‘Product Weight with Stand (kg) ‘, ’36’);
INSERT INTO DETAIL VALUES(359, ‘Product Weight with Stand (kg) ‘, ‘36.5’);
INSERT INTO DETAIL VALUES(293, ‘Product Weight with Stand (kg) ‘, ‘40.1’);
INSERT INTO DETAIL VALUES(243, ‘Product Weight without Stand (kg) ‘, ‘5.8’);
INSERT INTO DETAIL VALUES(297, ‘Product Weight without Stand (kg) ‘, ‘28.9’);
INSERT INTO DETAIL VALUES(237, ‘Product Width with Stand (mm) ‘, ‘490’);
INSERT INTO DETAIL VALUES(291, ‘Product Width with Stand (mm) ‘, ‘1673’);
INSERT INTO DETAIL VALUES(429, ‘Product Width with Stand (mm) ‘, ‘1673.8’);
INSERT INTO DETAIL VALUES(357, ‘Product Width with Stand (mm) ‘, ‘1722’);
INSERT INTO DETAIL VALUES(241, ‘Product Width without Stand (mm) ‘, ‘442’);
INSERT INTO DETAIL VALUES(295, ‘Product Width without Stand (mm) ‘, ‘1673’);
INSERT INTO DETAIL VALUES(397, ‘PVR Function ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(131, ‘RAM (GB) ‘, ‘2’);
INSERT INTO DETAIL VALUES(68, ‘RAM (GB) ‘, ‘3’);
INSERT INTO DETAIL VALUES(113, ‘RAM (GB) ‘, ‘4’);
INSERT INTO DETAIL VALUES(41, ‘RAM (GB) ‘, ‘6’);
INSERT INTO DETAIL VALUES(3, ‘RAM (GB) ‘, ‘8’);
INSERT INTO DETAIL VALUES(177, ‘RAM (GB) ‘, ’16’);
INSERT INTO DETAIL VALUES(69, ‘Rear Camera (MP) ‘, ‘7’);
INSERT INTO DETAIL VALUES(134, ‘Rear Camera (MP) ‘, ‘8’);
INSERT INTO DETAIL VALUES(42, ‘Rear Camera (MP) ‘, ’12’);
INSERT INTO DETAIL VALUES(158, ‘Rear Camera (MP) ‘, ’13’);
INSERT INTO DETAIL VALUES(5, ‘Rear Camera (MP) ‘, ’12MP x 2’);
INSERT INTO DETAIL VALUES(331, ‘Record / Pause Live TV ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(332, ‘Recording Medium ‘, ‘Built-in Hard Drive, Expandable via USB’);
INSERT INTO DETAIL VALUES(400, ‘Recording Medium ‘, ‘External Drive Required (via USB)’);
INSERT INTO DETAIL VALUES(197, ‘Refresh Rate (Hz) ‘, ’50’);
INSERT INTO DETAIL VALUES(253, ‘Refresh Rate (Hz) ‘, ‘200’);
INSERT INTO DETAIL VALUES(355, ‘Remote Control(s) ‘, ‘Magic Remote’);
INSERT INTO DETAIL VALUES(235, ‘Remote Control(s) ‘, ‘Yes’);
INSERT INTO DETAIL VALUES(62, ‘Resolution (Pixels) ‘, ‘1125 x 2436’);
INSERT INTO DETAIL VALUES(6, ‘Resolution (Pixels) ‘, ‘1440 x 2960’);
INSERT INTO DETAIL VALUES(196, ‘Resolution (Pixels) ‘, ‘1920×1080’);
INSERT INTO DETAIL VALUES(128, ‘Resolution (Pixels) ‘, ‘2048 x 1536’);
INSERT INTO DETAIL VALUES(110, ‘Resolution (Pixels) ‘, ‘2224 x 1668’);
INSERT INTO DETAIL VALUES(148, ‘Resolution (Pixels) ‘, ‘2560 x 1600’);
INSERT INTO DETAIL VALUES(173, ‘Resolution (Pixels) ‘, ‘2736 x 1824’);
INSERT INTO DETAIL VALUES(31, ‘Resolution (Pixels) ‘, ‘2960 x 1440’);
INSERT INTO DETAIL VALUES(252, ‘Resolution (Pixels) ‘, ‘3840 x 2160’);
INSERT INTO DETAIL VALUES(373, ‘Response Time (ms) ‘, ’15’);
INSERT INTO DETAIL VALUES(286, ‘RF Input ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(195, ‘Screen Resolution ‘, ‘Full HD’);
INSERT INTO DETAIL VALUES(174, ‘Screen Resolution ‘, ‘Pixel Sense Screen’);
INSERT INTO DETAIL VALUES(149, ‘Screen Resolution ‘, ‘QHD’);
INSERT INTO DETAIL VALUES(111, ‘Screen Resolution ‘, ‘Retina Display’);
INSERT INTO DETAIL VALUES(251, ‘Screen Resolution ‘, ‘Ultra HD’);
INSERT INTO DETAIL VALUES(344, ‘Screen Sharing ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(193, ‘Screen Size (Inches) ‘, ’32’);
INSERT INTO DETAIL VALUES(249, ‘Screen Size (Inches) ‘, ’75’);
INSERT INTO DETAIL VALUES(303, ‘Screen Size (Inches) ‘, ’77’);
INSERT INTO DETAIL VALUES(194, ‘Screen Type ‘, ‘LED LCD – Flat’);
INSERT INTO DETAIL VALUES(304, ‘Screen Type ‘, ‘OLED – Flat’);
INSERT INTO DETAIL VALUES(330, ‘Series Record ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(268, ‘Smart OS ‘, ‘Android TV’);
INSERT INTO DETAIL VALUES(323, ‘Smart OS ‘, ‘LG Smart TV’);
INSERT INTO DETAIL VALUES(214, ‘Smart OS ‘, ‘Linux’);
INSERT INTO DETAIL VALUES(391, ‘Smart OS ‘, ‘TIZEN’);
INSERT INTO DETAIL VALUES(213, ‘Smart TV ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(384, ‘Sound Modes ‘, ‘Standard, Surround’);
INSERT INTO DETAIL VALUES(262, ‘Sound Modes ‘, ‘Standard,Dialog,Cinema,Music,Sports’);
INSERT INTO DETAIL VALUES(207, ‘Sound Modes ‘, ‘Standard,Music,Cinema,Sports’);
INSERT INTO DETAIL VALUES(382, ‘Speaker Configuration ‘, ‘2.1’);
INSERT INTO DETAIL VALUES(204, ‘Speaker Configuration ‘, ‘2ch, Full Range (4x10cm)x2’);
INSERT INTO DETAIL VALUES(178, ‘SSD Storage ‘, ‘1TB’);
INSERT INTO DETAIL VALUES(154, ‘SSD Storage ‘, ‘256GB’);
INSERT INTO DETAIL VALUES(324, ‘Streaming Apps ‘, ‘Netflix’);
INSERT INTO DETAIL VALUES(392, ‘Streaming Apps ‘, ‘Netflix, Stan, ABC, Iview, 7Plus, 9Now, 10Play, SBS on Demand, Youtube’);
INSERT INTO DETAIL VALUES(269, ‘Streaming Apps ‘, ‘Netflix/Youtube’);
INSERT INTO DETAIL VALUES(215, ‘Streaming Apps ‘, ‘Yes’);
INSERT INTO DETAIL VALUES(167, ‘Tablet Operating System ‘, ‘Android’);
INSERT INTO DETAIL VALUES(123, ‘Tablet Operating System ‘, ‘Apple iOS’);
INSERT INTO DETAIL VALUES(191, ‘Tablet Operating System ‘, ‘Windows’);
INSERT INTO DETAIL VALUES(145, ‘Tablet Type ‘, ‘Galaxy Tab S4’);
INSERT INTO DETAIL VALUES(125, ‘Tablet Type ‘, ‘iPad’);
INSERT INTO DETAIL VALUES(107, ‘Tablet Type ‘, ‘iPad Pro 10.5-inch’);
INSERT INTO DETAIL VALUES(169, ‘Tablet Type ‘, ‘Surface Pro’);
INSERT INTO DETAIL VALUES(212, ‘Teletext ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(179, ‘Total Storage ‘, ‘1TB’);
INSERT INTO DETAIL VALUES(115, ‘Total Storage ‘, ‘256GB’);
INSERT INTO DETAIL VALUES(133, ‘Total Storage ‘, ’32GB’);
INSERT INTO DETAIL VALUES(23, ‘Touchscreen ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(209, ‘TV Tuner(s) ‘, ‘HD Tuner’);
INSERT INTO DETAIL VALUES(311, ‘Upscaling ‘, ‘4K Ultra HD’);
INSERT INTO DETAIL VALUES(200, ‘Upscaling ‘, ‘HD’);
INSERT INTO DETAIL VALUES(165, ‘USB (Type-C) Port’, ‘3’);
INSERT INTO DETAIL VALUES(51, ‘USB (Type-C) Port ‘, ‘3.1’);
INSERT INTO DETAIL VALUES(188, ‘USB 3.0 Ports ‘, ‘1’);
INSERT INTO DETAIL VALUES(333, ‘USB Playback ‘, ‘ASF/WMV/AVI (Xvid, H.264/AVC)/MP4/M4v/MOV (H.264, H.265, MPEG-4, HEVC)/MKV (MPEG-2, MPEG-4, H.264, H.265, VP8, VP9, HEVC) SHVC/TS/TRP/TP/MTS/MPG/3GP/3G2 MPEG/DAT/VOB/HEVC (Up to [email protected] 50Mbps)’);
INSERT INTO DETAIL VALUES(219, ‘USB Playback ‘, ‘Audio/Picture/Video’);
INSERT INTO DETAIL VALUES(401, ‘USB Playback ‘, ‘Video, Audio, Picture’);
INSERT INTO DETAIL VALUES(230, ‘USB Ports ‘, ‘1’);
INSERT INTO DETAIL VALUES(418, ‘USB Ports ‘, ‘2’);
INSERT INTO DETAIL VALUES(281, ‘USB Ports ‘, ‘3’);
INSERT INTO DETAIL VALUES(329, ‘USB Recording ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(164, ‘USB-C Ports ‘, ‘1’);
INSERT INTO DETAIL VALUES(76, ‘Video Calling ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(8, ‘Video Frames Per Second ‘, ‘[email protected]/[email protected]/[email protected]‘);
INSERT INTO DETAIL VALUES(48, ‘Video Frames Per Second ‘, ‘up to 960fps’);
INSERT INTO DETAIL VALUES(208, ‘Virtual Surround ‘, ‘S-Force Front Surround’);
INSERT INTO DETAIL VALUES(318, ‘Virtual Surround ‘, ‘Yes’);
INSERT INTO DETAIL VALUES(328, ‘Voice Control ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(225, ‘Wall Mountable ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(218, ‘Web Browser ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(183, ‘Webcam ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(413, ‘WiDi Capable ‘, ‘TRUE’);
INSERT INTO DETAIL VALUES(12, ‘Wi-Fi’, ‘802.11 ac’);
INSERT INTO DETAIL VALUES(161, ‘Wi-Fi’, ‘Yes’);
INSERT INTO DETAIL VALUES(17, ‘Wireless Charging Type ‘, ‘Qi’);
INSERT INTO DETAIL VALUES(278, ‘Works with Google Assistant ‘, ‘TRUE’);
— PAUSE ‘Insert PRODUCTDETAIL values’
INSERT INTO PRODUCTDETAIL VALUES(12, 426);
INSERT INTO PRODUCTDETAIL VALUES(9, 201);
INSERT INTO PRODUCTDETAIL VALUES(11, 201);
INSERT INTO PRODUCTDETAIL VALUES(12, 201);
INSERT INTO PRODUCTDETAIL VALUES(10, 257);
INSERT INTO PRODUCTDETAIL VALUES(11, 257);
INSERT INTO PRODUCTDETAIL VALUES(12, 257);
INSERT INTO PRODUCTDETAIL VALUES(10, 256);
INSERT INTO PRODUCTDETAIL VALUES(11, 256);
INSERT INTO PRODUCTDETAIL VALUES(12, 256);
INSERT INTO PRODUCTDETAIL VALUES(2, 56);
INSERT INTO PRODUCTDETAIL VALUES(12, 386);
INSERT INTO PRODUCTDETAIL VALUES(3, 77);
INSERT INTO PRODUCTDETAIL VALUES(4, 77);
INSERT INTO PRODUCTDETAIL VALUES(5, 77);
INSERT INTO PRODUCTDETAIL VALUES(6, 77);
INSERT INTO PRODUCTDETAIL VALUES(9, 199);
INSERT INTO PRODUCTDETAIL VALUES(10, 255);
INSERT INTO PRODUCTDETAIL VALUES(12, 255);
INSERT INTO PRODUCTDETAIL VALUES(2, 37);
INSERT INTO PRODUCTDETAIL VALUES(1, 4);
INSERT INTO PRODUCTDETAIL VALUES(8, 190);
INSERT INTO PRODUCTDETAIL VALUES(8, 185);
INSERT INTO PRODUCTDETAIL VALUES(5, 119);
INSERT INTO PRODUCTDETAIL VALUES(6, 119);
INSERT INTO PRODUCTDETAIL VALUES(11, 119);
INSERT INTO PRODUCTDETAIL VALUES(1, 25);
INSERT INTO PRODUCTDETAIL VALUES(2, 25);
INSERT INTO PRODUCTDETAIL VALUES(3, 25);
INSERT INTO PRODUCTDETAIL VALUES(4, 25);
INSERT INTO PRODUCTDETAIL VALUES(7, 25);
INSERT INTO PRODUCTDETAIL VALUES(12, 411);
INSERT INTO PRODUCTDETAIL VALUES(9, 211);
INSERT INTO PRODUCTDETAIL VALUES(12, 388);
INSERT INTO PRODUCTDETAIL VALUES(10, 266);
INSERT INTO PRODUCTDETAIL VALUES(11, 266);
INSERT INTO PRODUCTDETAIL VALUES(1, 19);
INSERT INTO PRODUCTDETAIL VALUES(2, 19);
INSERT INTO PRODUCTDETAIL VALUES(3, 19);
INSERT INTO PRODUCTDETAIL VALUES(4, 19);
INSERT INTO PRODUCTDETAIL VALUES(9, 234);
INSERT INTO PRODUCTDETAIL VALUES(7, 163);
INSERT INTO PRODUCTDETAIL VALUES(8, 187);
INSERT INTO PRODUCTDETAIL VALUES(1, 14);
INSERT INTO PRODUCTDETAIL VALUES(2, 29);
INSERT INTO PRODUCTDETAIL VALUES(4, 85);
INSERT INTO PRODUCTDETAIL VALUES(6, 85);
INSERT INTO PRODUCTDETAIL VALUES(7, 85);
INSERT INTO PRODUCTDETAIL VALUES(3, 60);
INSERT INTO PRODUCTDETAIL VALUES(5, 60);
INSERT INTO PRODUCTDETAIL VALUES(8, 60);
INSERT INTO PRODUCTDETAIL VALUES(12, 403);
INSERT INTO PRODUCTDETAIL VALUES(11, 335);
INSERT INTO PRODUCTDETAIL VALUES(9, 221);
INSERT INTO PRODUCTDETAIL VALUES(9, 222);
INSERT INTO PRODUCTDETAIL VALUES(12, 404);
INSERT INTO PRODUCTDETAIL VALUES(11, 336);
INSERT INTO PRODUCTDETAIL VALUES(11, 334);
INSERT INTO PRODUCTDETAIL VALUES(9, 220);
INSERT INTO PRODUCTDETAIL VALUES(12, 402);
INSERT INTO PRODUCTDETAIL VALUES(10, 284);
INSERT INTO PRODUCTDETAIL VALUES(11, 284);
INSERT INTO PRODUCTDETAIL VALUES(12, 284);
INSERT INTO PRODUCTDETAIL VALUES(8, 170);
INSERT INTO PRODUCTDETAIL VALUES(10, 277);
INSERT INTO PRODUCTDETAIL VALUES(3, 61);
INSERT INTO PRODUCTDETAIL VALUES(4, 61);
INSERT INTO PRODUCTDETAIL VALUES(2, 30);
INSERT INTO PRODUCTDETAIL VALUES(1, 1);
INSERT INTO PRODUCTDETAIL VALUES(11, 352);
INSERT INTO PRODUCTDETAIL VALUES(12, 352);
INSERT INTO PRODUCTDETAIL VALUES(10, 285);
INSERT INTO PRODUCTDETAIL VALUES(11, 285);
INSERT INTO PRODUCTDETAIL VALUES(12, 285);
INSERT INTO PRODUCTDETAIL VALUES(9, 210);
INSERT INTO PRODUCTDETAIL VALUES(10, 210);
INSERT INTO PRODUCTDETAIL VALUES(11, 320);
INSERT INTO PRODUCTDETAIL VALUES(12, 320);
INSERT INTO PRODUCTDETAIL VALUES(2, 46);
INSERT INTO PRODUCTDETAIL VALUES(6, 127);
INSERT INTO PRODUCTDETAIL VALUES(5, 109);
INSERT INTO PRODUCTDETAIL VALUES(7, 109);
INSERT INTO PRODUCTDETAIL VALUES(8, 172);
INSERT INTO PRODUCTDETAIL VALUES(1, 18);
INSERT INTO PRODUCTDETAIL VALUES(2, 32);
INSERT INTO PRODUCTDETAIL VALUES(3, 32);
INSERT INTO PRODUCTDETAIL VALUES(4, 32);
INSERT INTO PRODUCTDETAIL VALUES(9, 227);
INSERT INTO PRODUCTDETAIL VALUES(10, 227);
INSERT INTO PRODUCTDETAIL VALUES(12, 227);
INSERT INTO PRODUCTDETAIL VALUES(11, 317);
INSERT INTO PRODUCTDETAIL VALUES(9, 205);
INSERT INTO PRODUCTDETAIL VALUES(12, 383);
INSERT INTO PRODUCTDETAIL VALUES(10, 260);
INSERT INTO PRODUCTDETAIL VALUES(10, 261);
INSERT INTO PRODUCTDETAIL VALUES(9, 206);
INSERT INTO PRODUCTDETAIL VALUES(1, 20);
INSERT INTO PRODUCTDETAIL VALUES(9, 224);
INSERT INTO PRODUCTDETAIL VALUES(10, 224);
INSERT INTO PRODUCTDETAIL VALUES(11, 224);
INSERT INTO PRODUCTDETAIL VALUES(12, 224);
INSERT INTO PRODUCTDETAIL VALUES(11, 338);
INSERT INTO PRODUCTDETAIL VALUES(9, 223);
INSERT INTO PRODUCTDETAIL VALUES(10, 223);
INSERT INTO PRODUCTDETAIL VALUES(12, 223);
INSERT INTO PRODUCTDETAIL VALUES(9, 233);
INSERT INTO PRODUCTDETAIL VALUES(10, 288);
INSERT INTO PRODUCTDETAIL VALUES(9, 231);
INSERT INTO PRODUCTDETAIL VALUES(10, 231);
INSERT INTO PRODUCTDETAIL VALUES(11, 231);
INSERT INTO PRODUCTDETAIL VALUES(12, 231);
INSERT INTO PRODUCTDETAIL VALUES(1, 16);
INSERT INTO PRODUCTDETAIL VALUES(2, 16);
INSERT INTO PRODUCTDETAIL VALUES(7, 157);
INSERT INTO PRODUCTDETAIL VALUES(2, 35);
INSERT INTO PRODUCTDETAIL VALUES(1, 9);
INSERT INTO PRODUCTDETAIL VALUES(7, 9);
INSERT INTO PRODUCTDETAIL VALUES(2, 45);
INSERT INTO PRODUCTDETAIL VALUES(3, 45);
INSERT INTO PRODUCTDETAIL VALUES(4, 45);
INSERT INTO PRODUCTDETAIL VALUES(5, 114);
INSERT INTO PRODUCTDETAIL VALUES(6, 132);
INSERT INTO PRODUCTDETAIL VALUES(6, 135);
INSERT INTO PRODUCTDETAIL VALUES(8, 182);
INSERT INTO PRODUCTDETAIL VALUES(5, 117);
INSERT INTO PRODUCTDETAIL VALUES(1, 2);
INSERT INTO PRODUCTDETAIL VALUES(2, 2);
INSERT INTO PRODUCTDETAIL VALUES(7, 2);
INSERT INTO PRODUCTDETAIL VALUES(3, 70);
INSERT INTO PRODUCTDETAIL VALUES(4, 70);
INSERT INTO PRODUCTDETAIL VALUES(1, 21);
INSERT INTO PRODUCTDETAIL VALUES(2, 21);
INSERT INTO PRODUCTDETAIL VALUES(3, 21);
INSERT INTO PRODUCTDETAIL VALUES(4, 21);
INSERT INTO PRODUCTDETAIL VALUES(6, 21);
INSERT INTO PRODUCTDETAIL VALUES(7, 21);
INSERT INTO PRODUCTDETAIL VALUES(8, 180);
INSERT INTO PRODUCTDETAIL VALUES(11, 325);
INSERT INTO PRODUCTDETAIL VALUES(12, 325);
INSERT INTO PRODUCTDETAIL VALUES(9, 217);
INSERT INTO PRODUCTDETAIL VALUES(5, 118);
INSERT INTO PRODUCTDETAIL VALUES(6, 118);
INSERT INTO PRODUCTDETAIL VALUES(8, 118);
INSERT INTO PRODUCTDETAIL VALUES(9, 229);
INSERT INTO PRODUCTDETAIL VALUES(10, 280);
INSERT INTO PRODUCTDETAIL VALUES(11, 280);
INSERT INTO PRODUCTDETAIL VALUES(12, 280);
INSERT INTO PRODUCTDETAIL VALUES(9, 228);
INSERT INTO PRODUCTDETAIL VALUES(11, 228);
INSERT INTO PRODUCTDETAIL VALUES(12, 228);
INSERT INTO PRODUCTDETAIL VALUES(10, 228);
INSERT INTO PRODUCTDETAIL VALUES(9, 198);
INSERT INTO PRODUCTDETAIL VALUES(10, 198);
INSERT INTO PRODUCTDETAIL VALUES(11, 198);
INSERT INTO PRODUCTDETAIL VALUES(12, 198);
INSERT INTO PRODUCTDETAIL VALUES(2, 53);
INSERT INTO PRODUCTDETAIL VALUES(5, 53);
INSERT INTO PRODUCTDETAIL VALUES(6, 53);
INSERT INTO PRODUCTDETAIL VALUES(7, 53);
INSERT INTO PRODUCTDETAIL VALUES(8, 53);
INSERT INTO PRODUCTDETAIL VALUES(10, 53);
INSERT INTO PRODUCTDETAIL VALUES(11, 53);
INSERT INTO PRODUCTDETAIL VALUES(12, 53);
INSERT INTO PRODUCTDETAIL VALUES(2, 34);
INSERT INTO PRODUCTDETAIL VALUES(3, 34);
INSERT INTO PRODUCTDETAIL VALUES(1, 11);
INSERT INTO PRODUCTDETAIL VALUES(4, 90);
INSERT INTO PRODUCTDETAIL VALUES(11, 308);
INSERT INTO PRODUCTDETAIL VALUES(12, 308);
INSERT INTO PRODUCTDETAIL VALUES(3, 81);
INSERT INTO PRODUCTDETAIL VALUES(4, 81);
INSERT INTO PRODUCTDETAIL VALUES(5, 81);
INSERT INTO PRODUCTDETAIL VALUES(6, 81);
INSERT INTO PRODUCTDETAIL VALUES(8, 81);
INSERT INTO PRODUCTDETAIL VALUES(9, 81);
INSERT INTO PRODUCTDETAIL VALUES(10, 81);
INSERT INTO PRODUCTDETAIL VALUES(11, 81);
INSERT INTO PRODUCTDETAIL VALUES(12, 81);
INSERT INTO PRODUCTDETAIL VALUES(1, 7);
INSERT INTO PRODUCTDETAIL VALUES(7, 7);
INSERT INTO PRODUCTDETAIL VALUES(11, 343);
INSERT INTO PRODUCTDETAIL VALUES(12, 343);
INSERT INTO PRODUCTDETAIL VALUES(11, 327);
INSERT INTO PRODUCTDETAIL VALUES(1, 24);
INSERT INTO PRODUCTDETAIL VALUES(2, 24);
INSERT INTO PRODUCTDETAIL VALUES(3, 24);
INSERT INTO PRODUCTDETAIL VALUES(4, 24);
INSERT INTO PRODUCTDETAIL VALUES(9, 203);
INSERT INTO PRODUCTDETAIL VALUES(10, 203);
INSERT INTO PRODUCTDETAIL VALUES(11, 203);
INSERT INTO PRODUCTDETAIL VALUES(12, 203);
INSERT INTO PRODUCTDETAIL VALUES(2, 50);
INSERT INTO PRODUCTDETAIL VALUES(3, 50);
INSERT INTO PRODUCTDETAIL VALUES(4, 50);
INSERT INTO PRODUCTDETAIL VALUES(1, 10);
INSERT INTO PRODUCTDETAIL VALUES(2, 10);
INSERT INTO PRODUCTDETAIL VALUES(3, 10);
INSERT INTO PRODUCTDETAIL VALUES(4, 10);
INSERT INTO PRODUCTDETAIL VALUES(6, 10);
INSERT INTO PRODUCTDETAIL VALUES(1, 22);
INSERT INTO PRODUCTDETAIL VALUES(2, 22);
INSERT INTO PRODUCTDETAIL VALUES(3, 22);
INSERT INTO PRODUCTDETAIL VALUES(4, 22);
INSERT INTO PRODUCTDETAIL VALUES(11, 314);
INSERT INTO PRODUCTDETAIL VALUES(12, 314);
INSERT INTO PRODUCTDETAIL VALUES(12, 381);
INSERT INTO PRODUCTDETAIL VALUES(9, 216);
INSERT INTO PRODUCTDETAIL VALUES(9, 246);
INSERT INTO PRODUCTDETAIL VALUES(10, 300);
INSERT INTO PRODUCTDETAIL VALUES(12, 434);
INSERT INTO PRODUCTDETAIL VALUES(11, 362);
INSERT INTO PRODUCTDETAIL VALUES(9, 244);
INSERT INTO PRODUCTDETAIL VALUES(10, 298);
INSERT INTO PRODUCTDETAIL VALUES(12, 432);
INSERT INTO PRODUCTDETAIL VALUES(11, 360);
INSERT INTO PRODUCTDETAIL VALUES(9, 247);
INSERT INTO PRODUCTDETAIL VALUES(11, 363);
INSERT INTO PRODUCTDETAIL VALUES(12, 435);
INSERT INTO PRODUCTDETAIL VALUES(10, 301);
INSERT INTO PRODUCTDETAIL VALUES(9, 245);
INSERT INTO PRODUCTDETAIL VALUES(10, 299);
INSERT INTO PRODUCTDETAIL VALUES(12, 433);
INSERT INTO PRODUCTDETAIL VALUES(11, 361);
INSERT INTO PRODUCTDETAIL VALUES(10, 271);
INSERT INTO PRODUCTDETAIL VALUES(12, 271);
INSERT INTO PRODUCTDETAIL VALUES(10, 283);
INSERT INTO PRODUCTDETAIL VALUES(11, 283);
INSERT INTO PRODUCTDETAIL VALUES(12, 420);
INSERT INTO PRODUCTDETAIL VALUES(9, 232);
INSERT INTO PRODUCTDETAIL VALUES(1, 13);
INSERT INTO PRODUCTDETAIL VALUES(2, 13);
INSERT INTO PRODUCTDETAIL VALUES(3, 57);
INSERT INTO PRODUCTDETAIL VALUES(4, 57);
INSERT INTO PRODUCTDETAIL VALUES(2, 27);
INSERT INTO PRODUCTDETAIL VALUES(3, 58);
INSERT INTO PRODUCTDETAIL VALUES(4, 58);
INSERT INTO PRODUCTDETAIL VALUES(11, 316);
INSERT INTO PRODUCTDETAIL VALUES(11, 313);
INSERT INTO PRODUCTDETAIL VALUES(12, 378);
INSERT INTO PRODUCTDETAIL VALUES(10, 258);
INSERT INTO PRODUCTDETAIL VALUES(9, 259);
INSERT INTO PRODUCTDETAIL VALUES(3, 67);
INSERT INTO PRODUCTDETAIL VALUES(4, 67);
INSERT INTO PRODUCTDETAIL VALUES(2, 39);
INSERT INTO PRODUCTDETAIL VALUES(7, 152);
INSERT INTO PRODUCTDETAIL VALUES(7, 150);
INSERT INTO PRODUCTDETAIL VALUES(11, 150);
INSERT INTO PRODUCTDETAIL VALUES(12, 150);
INSERT INTO PRODUCTDETAIL VALUES(5, 112);
INSERT INTO PRODUCTDETAIL VALUES(1, 15);
INSERT INTO PRODUCTDETAIL VALUES(2, 15);
INSERT INTO PRODUCTDETAIL VALUES(8, 176);
INSERT INTO PRODUCTDETAIL VALUES(7, 151);
INSERT INTO PRODUCTDETAIL VALUES(6, 130);
INSERT INTO PRODUCTDETAIL VALUES(8, 175);
INSERT INTO PRODUCTDETAIL VALUES(12, 430);
INSERT INTO PRODUCTDETAIL VALUES(9, 238);
INSERT INTO PRODUCTDETAIL VALUES(11, 358);
INSERT INTO PRODUCTDETAIL VALUES(10, 292);
INSERT INTO PRODUCTDETAIL VALUES(10, 296);
INSERT INTO PRODUCTDETAIL VALUES(9, 242);
INSERT INTO PRODUCTDETAIL VALUES(9, 236);
INSERT INTO PRODUCTDETAIL VALUES(12, 428);
INSERT INTO PRODUCTDETAIL VALUES(10, 290);
INSERT INTO PRODUCTDETAIL VALUES(11, 356);
INSERT INTO PRODUCTDETAIL VALUES(9, 240);
INSERT INTO PRODUCTDETAIL VALUES(10, 294);
INSERT INTO PRODUCTDETAIL VALUES(9, 239);
INSERT INTO PRODUCTDETAIL VALUES(12, 431);
INSERT INTO PRODUCTDETAIL VALUES(11, 359);
INSERT INTO PRODUCTDETAIL VALUES(10, 293);
INSERT INTO PRODUCTDETAIL VALUES(9, 243);
INSERT INTO PRODUCTDETAIL VALUES(10, 297);
INSERT INTO PRODUCTDETAIL VALUES(9, 237);
INSERT INTO PRODUCTDETAIL VALUES(10, 291);
INSERT INTO PRODUCTDETAIL VALUES(12, 429);
INSERT INTO PRODUCTDETAIL VALUES(11, 357);
INSERT INTO PRODUCTDETAIL VALUES(9, 241);
INSERT INTO PRODUCTDETAIL VALUES(10, 295);
INSERT INTO PRODUCTDETAIL VALUES(12, 397);
INSERT INTO PRODUCTDETAIL VALUES(6, 131);
INSERT INTO PRODUCTDETAIL VALUES(3, 68);
INSERT INTO PRODUCTDETAIL VALUES(4, 68);
INSERT INTO PRODUCTDETAIL VALUES(5, 113);
INSERT INTO PRODUCTDETAIL VALUES(7, 113);
INSERT INTO PRODUCTDETAIL VALUES(2, 41);
INSERT INTO PRODUCTDETAIL VALUES(1, 3);
INSERT INTO PRODUCTDETAIL VALUES(8, 177);
INSERT INTO PRODUCTDETAIL VALUES(3, 69);
INSERT INTO PRODUCTDETAIL VALUES(4, 69);
INSERT INTO PRODUCTDETAIL VALUES(6, 134);
INSERT INTO PRODUCTDETAIL VALUES(8, 134);
INSERT INTO PRODUCTDETAIL VALUES(2, 42);
INSERT INTO PRODUCTDETAIL VALUES(5, 42);
INSERT INTO PRODUCTDETAIL VALUES(7, 158);
INSERT INTO PRODUCTDETAIL VALUES(1, 5);
INSERT INTO PRODUCTDETAIL VALUES(11, 331);
INSERT INTO PRODUCTDETAIL VALUES(12, 331);
INSERT INTO PRODUCTDETAIL VALUES(11, 332);
INSERT INTO PRODUCTDETAIL VALUES(12, 400);
INSERT INTO PRODUCTDETAIL VALUES(9, 197);
INSERT INTO PRODUCTDETAIL VALUES(10, 253);
INSERT INTO PRODUCTDETAIL VALUES(12, 253);
INSERT INTO PRODUCTDETAIL VALUES(11, 355);
INSERT INTO PRODUCTDETAIL VALUES(9, 235);
INSERT INTO PRODUCTDETAIL VALUES(10, 235);
INSERT INTO PRODUCTDETAIL VALUES(12, 235);
INSERT INTO PRODUCTDETAIL VALUES(3, 62);
INSERT INTO PRODUCTDETAIL VALUES(4, 62);
INSERT INTO PRODUCTDETAIL VALUES(1, 6);
INSERT INTO PRODUCTDETAIL VALUES(9, 196);
INSERT INTO PRODUCTDETAIL VALUES(6, 128);
INSERT INTO PRODUCTDETAIL VALUES(5, 110);
INSERT INTO PRODUCTDETAIL VALUES(7, 148);
INSERT INTO PRODUCTDETAIL VALUES(8, 173);
INSERT INTO PRODUCTDETAIL VALUES(2, 31);
INSERT INTO PRODUCTDETAIL VALUES(10, 252);
INSERT INTO PRODUCTDETAIL VALUES(11, 252);
INSERT INTO PRODUCTDETAIL VALUES(12, 252);
INSERT INTO PRODUCTDETAIL VALUES(12, 373);
INSERT INTO PRODUCTDETAIL VALUES(10, 286);
INSERT INTO PRODUCTDETAIL VALUES(11, 286);
INSERT INTO PRODUCTDETAIL VALUES(12, 286);
INSERT INTO PRODUCTDETAIL VALUES(9, 195);
INSERT INTO PRODUCTDETAIL VALUES(8, 174);
INSERT INTO PRODUCTDETAIL VALUES(7, 149);
INSERT INTO PRODUCTDETAIL VALUES(5, 111);
INSERT INTO PRODUCTDETAIL VALUES(6, 111);
INSERT INTO PRODUCTDETAIL VALUES(10, 251);
INSERT INTO PRODUCTDETAIL VALUES(11, 251);
INSERT INTO PRODUCTDETAIL VALUES(12, 251);
INSERT INTO PRODUCTDETAIL VALUES(11, 344);
INSERT INTO PRODUCTDETAIL VALUES(12, 344);
INSERT INTO PRODUCTDETAIL VALUES(9, 193);
INSERT INTO PRODUCTDETAIL VALUES(10, 249);
INSERT INTO PRODUCTDETAIL VALUES(12, 249);
INSERT INTO PRODUCTDETAIL VALUES(11, 303);
INSERT INTO PRODUCTDETAIL VALUES(9, 194);
INSERT INTO PRODUCTDETAIL VALUES(10, 194);
INSERT INTO PRODUCTDETAIL VALUES(12, 194);
INSERT INTO PRODUCTDETAIL VALUES(11, 304);
INSERT INTO PRODUCTDETAIL VALUES(11, 330);
INSERT INTO PRODUCTDETAIL VALUES(12, 330);
INSERT INTO PRODUCTDETAIL VALUES(10, 268);
INSERT INTO PRODUCTDETAIL VALUES(11, 323);
INSERT INTO PRODUCTDETAIL VALUES(9, 214);
INSERT INTO PRODUCTDETAIL VALUES(12, 391);
INSERT INTO PRODUCTDETAIL VALUES(9, 213);
INSERT INTO PRODUCTDETAIL VALUES(11, 213);
INSERT INTO PRODUCTDETAIL VALUES(12, 213);
INSERT INTO PRODUCTDETAIL VALUES(12, 384);
INSERT INTO PRODUCTDETAIL VALUES(10, 262);
INSERT INTO PRODUCTDETAIL VALUES(9, 207);
INSERT INTO PRODUCTDETAIL VALUES(12, 382);
INSERT INTO PRODUCTDETAIL VALUES(9, 204);
INSERT INTO PRODUCTDETAIL VALUES(8, 178);
INSERT INTO PRODUCTDETAIL VALUES(7, 154);
INSERT INTO PRODUCTDETAIL VALUES(11, 324);
INSERT INTO PRODUCTDETAIL VALUES(12, 392);
INSERT INTO PRODUCTDETAIL VALUES(10, 269);
INSERT INTO PRODUCTDETAIL VALUES(9, 215);
INSERT INTO PRODUCTDETAIL VALUES(7, 167);
INSERT INTO PRODUCTDETAIL VALUES(5, 123);
INSERT INTO PRODUCTDETAIL VALUES(6, 123);
INSERT INTO PRODUCTDETAIL VALUES(8, 191);
INSERT INTO PRODUCTDETAIL VALUES(7, 145);
INSERT INTO PRODUCTDETAIL VALUES(6, 125);
INSERT INTO PRODUCTDETAIL VALUES(5, 107);
INSERT INTO PRODUCTDETAIL VALUES(8, 169);
INSERT INTO PRODUCTDETAIL VALUES(9, 212);
INSERT INTO PRODUCTDETAIL VALUES(10, 212);
INSERT INTO PRODUCTDETAIL VALUES(12, 212);
INSERT INTO PRODUCTDETAIL VALUES(8, 179);
INSERT INTO PRODUCTDETAIL VALUES(5, 115);
INSERT INTO PRODUCTDETAIL VALUES(7, 115);
INSERT INTO PRODUCTDETAIL VALUES(6, 133);
INSERT INTO PRODUCTDETAIL VALUES(1, 23);
INSERT INTO PRODUCTDETAIL VALUES(2, 23);
INSERT INTO PRODUCTDETAIL VALUES(3, 23);
INSERT INTO PRODUCTDETAIL VALUES(4, 23);
INSERT INTO PRODUCTDETAIL VALUES(9, 209);
INSERT INTO PRODUCTDETAIL VALUES(10, 209);
INSERT INTO PRODUCTDETAIL VALUES(11, 209);
INSERT INTO PRODUCTDETAIL VALUES(12, 209);
INSERT INTO PRODUCTDETAIL VALUES(11, 311);
INSERT INTO PRODUCTDETAIL VALUES(12, 311);
INSERT INTO PRODUCTDETAIL VALUES(9, 200);
INSERT INTO PRODUCTDETAIL VALUES(7, 165);
INSERT INTO PRODUCTDETAIL VALUES(2, 51);
INSERT INTO PRODUCTDETAIL VALUES(8, 188);
INSERT INTO PRODUCTDETAIL VALUES(11, 333);
INSERT INTO PRODUCTDETAIL VALUES(9, 219);
INSERT INTO PRODUCTDETAIL VALUES(12, 401);
INSERT INTO PRODUCTDETAIL VALUES(9, 230);
INSERT INTO PRODUCTDETAIL VALUES(12, 418);
INSERT INTO PRODUCTDETAIL VALUES(10, 281);
INSERT INTO PRODUCTDETAIL VALUES(11, 281);
INSERT INTO PRODUCTDETAIL VALUES(11, 329);
INSERT INTO PRODUCTDETAIL VALUES(12, 329);
INSERT INTO PRODUCTDETAIL VALUES(7, 164);
INSERT INTO PRODUCTDETAIL VALUES(3, 76);
INSERT INTO PRODUCTDETAIL VALUES(4, 76);
INSERT INTO PRODUCTDETAIL VALUES(1, 8);
INSERT INTO PRODUCTDETAIL VALUES(2, 48);
INSERT INTO PRODUCTDETAIL VALUES(9, 208);
INSERT INTO PRODUCTDETAIL VALUES(10, 208);
INSERT INTO PRODUCTDETAIL VALUES(11, 318);
INSERT INTO PRODUCTDETAIL VALUES(11, 328);
INSERT INTO PRODUCTDETAIL VALUES(12, 328);
INSERT INTO PRODUCTDETAIL VALUES(9, 225);
INSERT INTO PRODUCTDETAIL VALUES(10, 225);
INSERT INTO PRODUCTDETAIL VALUES(11, 225);
INSERT INTO PRODUCTDETAIL VALUES(12, 225);
INSERT INTO PRODUCTDETAIL VALUES(9, 218);
INSERT INTO PRODUCTDETAIL VALUES(10, 218);
INSERT INTO PRODUCTDETAIL VALUES(11, 218);
INSERT INTO PRODUCTDETAIL VALUES(12, 218);
INSERT INTO PRODUCTDETAIL VALUES(8, 183);
INSERT INTO PRODUCTDETAIL VALUES(12, 413);
INSERT INTO PRODUCTDETAIL VALUES(1, 12);
INSERT INTO PRODUCTDETAIL VALUES(2, 12);
INSERT INTO PRODUCTDETAIL VALUES(3, 12);
INSERT INTO PRODUCTDETAIL VALUES(4, 12);
INSERT INTO PRODUCTDETAIL VALUES(5, 12);
INSERT INTO PRODUCTDETAIL VALUES(6, 12);
INSERT INTO PRODUCTDETAIL VALUES(8, 12);
INSERT INTO PRODUCTDETAIL VALUES(11, 12);
INSERT INTO PRODUCTDETAIL VALUES(7, 161);
INSERT INTO PRODUCTDETAIL VALUES(9, 161);
INSERT INTO PRODUCTDETAIL VALUES(10, 161);
INSERT INTO PRODUCTDETAIL VALUES(12, 161);
INSERT INTO PRODUCTDETAIL VALUES(1, 17);
INSERT INTO PRODUCTDETAIL VALUES(2, 17);
INSERT INTO PRODUCTDETAIL VALUES(3, 17);
INSERT INTO PRODUCTDETAIL VALUES(4, 17);
INSERT INTO PRODUCTDETAIL VALUES(10, 278);
spool/home/username/AT2.txt;
set echo on;
select name,price from product where name like ‘%Wi-Fi%’;
select p.manufacturerName,p.Name,p.imageFileName,p.price from product p
inner join productsubcategory psc on psc.pid=p.pid
inner join subcategory sc on sc.subcatid=psc.subcatid
where sc.name=’4K Ultra HD TVs’;
select p.PID,avg(r.quality), avg(r.val) from product p
inner join productsubcategory psc on psc.pid=p.pid
inner join subcategory sc on sc.subcatid=psc.subcatid
inner join review r on r.pid=p.pid
where sc.name=’4K Ultra HD TVs’
group by p.pid;
select p.pid, count(r.PID) from product p
inner join productsubcategory psc on psc.pid=p.pid
inner join subcategory sc on sc.subcatid=psc.subcatid
inner join review r on r.pid=p.pid
where sc.name=’4K Ultra HD TVs’;
select p.manufacturername,p.name,p.imagefilename,p.price from product p where p.name=’Samsung Galaxy S9+ 256GB (Coral Blue)’;
select p.PID,avg(r.quality), avg(r.val) from product p
inner join review r on r.pid=p.pid
where p.name=’Samsung Galaxy S9+ 256GB (Coral Blue)’
group by p.pid;
select p.pid,count(r.PID) from product p
inner join review r on r.pid=p.pid
where p.name=’Samsung Galaxy S9+ 256GB (Coral Blue)’
group by p.pid;
select p.pid,c.name, c.shortdescription from product p
inner join productcharacteristic pc on pc.pid=p.pid
inner join characteristic c on c.cid=pc.cid
where p.name=’Samsung Galaxy S9+ 256GB (Coral Blue)’;
select p.pid,f.name, f.shortdescription from product p
inner join productfeature pf on pf.pid=p.pid
inner join feature f on f.fid=pf.fid
where p.name=’Samsung Galaxy S9+ 256GB (Coral Blue)’;
select p.PID,p.name,r.subject,r.text,r.quality,r.val from product p
inner join review r on r.pid=p.pid
where p.name=’Samsung Galaxy S9+ 256GB (Coral Blue)’;
set echo off;
spool off;
