Project Detail

Description

Looking for someone to build AND POPULATE 4 MySQL databases with information from online retailers of computer memory. We will provide the websites to crawl, and you will write the code to extract their DB info and save it in a new MySQL database as described below.

Database ONE ("computers") will contain:
0. index
1. computer_manufacturer (e.g., Dell)
2. series (e.g. Dimension)
3. model_num (e.g., 1100)
4. number_memory_slots (e.g. 2 sockets)
5. maximum_memory (e.g. 2.0 GB)
6. standard_memory (e.g. 128MB removable)


Database TWO ("attributes") will contain:
0. index
1. atribute_description

Contents for DB Two, for example:
1, "Processor"
2, "Chipset"
3, "FSB Speed"
4, "Supported Memory Type"

Database Three ("attribute_values") will contain:
0. index
1. db_two_index
2. description

Contents for DB Three, for example:
1, 1, "Intel Pentium 4"
2, 1, "Intel Celeron"
3, 2, "865GV"
4, 3, "533 MHz"
5, 3, "800 MHz"
6, 4, "PC2700 DDR SDRAM DIMMs"
7, 4, "PC3200 DDR SDRAM DIMMs"
8, 4, "Dual Channel"

Database Four ("supported_memory")
0. index
1. memory_capacity
2. memory_speed
3. memory_type
4. memory_description

Contents for DB four, for example
1, "128 MB", "333 MHZ", "PC2700 DDR SDRAM DIMMS", "128MB PC2700 333MHz DDR 184-Pin DIMM Standard Non ECC"
2, "256 MB", "333 MHZ", "PC2700 DDR SDRAM DIMMS", "256MB PC2700 333MHz DDR 184-Pin DIMM Standard Non ECC"
3, "512 MB", "333 MHZ", "PC2700 DDR SDRAM DIMMS", "512MB PC2700 333MHz DDR 184-Pin DIMM Standard Non ECC"
4, "1 GB", "333 MHZ", "PC2700 DDR SDRAM DIMMS", "1GB PC2700 333MHz DDR 184-Pin DIMM Standard Non ECC"
5, "128 MB", "400 MHZ", "PC2700 DDR SDRAM DIMMS", "128MB PC3200 400MHz DDR 184-Pin DIMM Standard Non ECC"
6, "256 MB", "400 MHZ", "PC2700 DDR SDRAM DIMMS", "256MB PC3200 400MHz DDR 184-Pin DIMM Standard Non ECC"
7, "512 MB", "400 MHZ", "PC2700 DDR SDRAM DIMMS", "512MB PC3200 333MHz DDR 184-Pin DIMM Standard Non ECC"
8, "1 GB", "400 MHZ", "PC2700 DDR SDRAM DIMMS", "1GB PC3200 400MHz DDR 184-Pin DIMM Standard Non ECC"