Thursday, 12 February 2009

Create tables and their relationship entities

Using Microsoft Access as tool to input data entry.
I created 2 tables :
  • "category": contains product types
  • "product": contains products details such as product ID, product name, etc.



In product table, I have 7 columns that are:


  • proID: contains a unique number for each product in the table.
  • proName: contains a name of a product.
  • proDes: contains full description of the product.
  • price: contains the product's current price.
  • image: contains a path to the picture of the product.
  • catID: contains the category of the product.
  • status : check the product is still in stock or temporarily out of stock.
Product Data entries:


In category table, there are 2 columns :


  • catID: contains a unique number for each product type.
  • catName: contains a name of a product type.
Category Data entries:



Relationship entity between category table and product table:

Wednesday, 11 February 2009

Week 2 - register domain name

Firstly, I choose a website, which I can register my domain name for my website, is called "namecheap.com".

On the main page of the "namecheap.com" website, "clothesvn.com" is registered as a domain name for my e-commerce website, which is selling a specialist niche area within the product range of Vietnamese clothes.


After putting my chosen domain name and search, if the name is still available ( it has not been taken by some one, god blesses me,otherwise, I have to choose another name that can be short and easy to remember), a list of different domain appear :


As requirement of E-commerce, I like to choose .com rather than other domain name.
Next step is I must create an account :


the account registered process was done so far, I also paid a fee for my chosen domain name ~ 7 pounds per year.

after logging into my account, I have a screen of my management home page.



Unfortunately, today is not a right day to register with namecheap. its server is under maintenance, so I have to wait until 14th Febuary 2009 (Saturday - Valintine day) to try setting up