Friday, August 21, 2009
What is a Database?
A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. The data in a database is organised into one or more tables. A table will have one or more fields to organise the data. A row of information in a table is called a record.
For example if you had an e-commerce website ie a webiste where you are selling products(like clothing) online, the database name could be the name of your company. The different tables you could have are categories, colors, sizes, brands and products etc.
Categories table could have a field called category and the possible values could be tops, bottoms, skirts
Colors table could have a field called color which would have all the possible colors for the clothing you are selling example red, light red, shocking red, green, sea green, olive green, blue etc.
Sizes table could have a field called size which would have all the possible sizes for the clothing you are selling example XS, S, M, L, Xl, XXL, 8, 10, 12...
Products table could have the fields - product_sku, product_name, product_category, style, product_brand, product_color, inventory etc
The record in the products table could look like this X123, Red Top, Tops, Peekaboo Top, Hazel, Red, 10
I can create a database driven website for you that increases work efficiencies and reduces working costs. I can create intranet websites so that your company staff/admin can login and maintain company related information like accounts, student information, job postings, news updates, menu for your restaurant, patient data, home owners data, real estate listings, run reports, view invoices, view transactions, view charts etc.
For example if you had an e-commerce website ie a webiste where you are selling products(like clothing) online, the database name could be the name of your company. The different tables you could have are categories, colors, sizes, brands and products etc.
Categories table could have a field called category and the possible values could be tops, bottoms, skirts
Colors table could have a field called color which would have all the possible colors for the clothing you are selling example red, light red, shocking red, green, sea green, olive green, blue etc.
Sizes table could have a field called size which would have all the possible sizes for the clothing you are selling example XS, S, M, L, Xl, XXL, 8, 10, 12...
Products table could have the fields - product_sku, product_name, product_category, style, product_brand, product_color, inventory etc
The record in the products table could look like this X123, Red Top, Tops, Peekaboo Top, Hazel, Red, 10
I can create a database driven website for you that increases work efficiencies and reduces working costs. I can create intranet websites so that your company staff/admin can login and maintain company related information like accounts, student information, job postings, news updates, menu for your restaurant, patient data, home owners data, real estate listings, run reports, view invoices, view transactions, view charts etc.
Labels: Database, MS-Access, MS-SQL Server, MySQL
Why is a Good Website Design Important?
A well designed website can be a great asset to your company by providing insight into who you are and the services you offer. Successful websites have a good, clean design and are easy to navigate. Your company's first impression, your logo will be the deciding factor for many potential customers.
I have the creative talent to make a visually appealing website and the training and knowledge of current web technologies to turn your ideas into a reality! I can create awesome, affordable, and creative logos that can give your business its true identity.
I have the creative talent to make a visually appealing website and the training and knowledge of current web technologies to turn your ideas into a reality! I can create awesome, affordable, and creative logos that can give your business its true identity.
Labels: Flash, Flex, HTML, Illustrator, Photoshop
Subscribe to Posts [Atom]