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
Thursday, November 13, 2008
Affordable Website Solutions
APSWebSolutions provides affordable custom website solutions for small to medium sized business. If you are doing all of your paperwork and data handling manually, I can make your life easier.
My mission is to provide quality website solutions for people who have the vision but limited finances.
I provide website design and website development to suit your needs. I develop content management systems that allow you to manage your website data from anywhere, so that you don’t need to depend on us. I am an expert in E-Commerce websites and proficient in project design.
Technical Highlights: HTML, Photoshop, Illustrator, Flash, Flex, Javascript, Classic ASP, VB Script, ASP.NET, PHP, Ajax, Joomla, OS-Commerce, Drupal, WordPress, Cake PHP, MS-Access, MS-SQL Server, MySQL & Search Engine Optimization.
The reason I have a success story is because I answer the phone, emails, and communicate with you every step of the way. I am sincere in my work, and take every client seriously. Plus I have knowledge in cross-platform technologies (Microsoft or Open Source).
So whether you need maintenance or fixes on your existing website, or if you need a web application built from scratch, I have the expertise to get the job done. 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! With my experience you can be sure that whatever your project demands are, I can deliver! If I cannot, I will be honest with you upfront.
Aparna Subramanian
Owner of APSWebSolutions
Contact : http://www.apswebsolutions.com/
702-516-2006
My mission is to provide quality website solutions for people who have the vision but limited finances.
I provide website design and website development to suit your needs. I develop content management systems that allow you to manage your website data from anywhere, so that you don’t need to depend on us. I am an expert in E-Commerce websites and proficient in project design.
Technical Highlights: HTML, Photoshop, Illustrator, Flash, Flex, Javascript, Classic ASP, VB Script, ASP.NET, PHP, Ajax, Joomla, OS-Commerce, Drupal, WordPress, Cake PHP, MS-Access, MS-SQL Server, MySQL & Search Engine Optimization.
The reason I have a success story is because I answer the phone, emails, and communicate with you every step of the way. I am sincere in my work, and take every client seriously. Plus I have knowledge in cross-platform technologies (Microsoft or Open Source).
So whether you need maintenance or fixes on your existing website, or if you need a web application built from scratch, I have the expertise to get the job done. 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! With my experience you can be sure that whatever your project demands are, I can deliver! If I cannot, I will be honest with you upfront.
Aparna Subramanian
Owner of APSWebSolutions
Contact : http://www.apswebsolutions.com/
702-516-2006
Labels: Ajax, ASP.NET, Cake PHP, Classic ASP, Drupal, Flash, Illustrator, Javascript, Joomla, MS-Access, MS-SQL Server, MySQL, OS-Commerce, Photoshop, PHP, Search Engine Optimization, VB Script, WordPress
Subscribe to Posts [Atom]