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
Comments:
python course in coimbatore
java course in coimbatore
python training in coimbatore
java training in coimbatore
php course in coimbatore
php training in coimbatore
android course in coimbatore
android training in coimbatore
datascience course in coimbatore
datascience training in coimbatore
ethical hacking course in coimbatore
ethical hacking training in coimbatore
artificial intelligence course in coimbatore
artificial intelligence training in coimbatore
digital marketing course in coimbatore
digital marketing training in coimbatore
embedded system course in coimbatore
embedded system training in coimbatore
Post a Comment
<< Home
This is an excellent post that is being shared. Kindly do share more post in this sorts.
Spoken English Classes in Bangalore
English Speaking Course in Bangalore
Best Spoken English Classes in Bangalore
English Classes in Bangalore
Spoken English Class in Bangalore
Spoken English Classes in Bangalore
English Speaking Course in Bangalore
Best Spoken English Classes in Bangalore
English Classes in Bangalore
Spoken English Class in Bangalore
python course in coimbatore
java course in coimbatore
python training in coimbatore
java training in coimbatore
php course in coimbatore
php training in coimbatore
android course in coimbatore
android training in coimbatore
datascience course in coimbatore
datascience training in coimbatore
ethical hacking course in coimbatore
ethical hacking training in coimbatore
artificial intelligence course in coimbatore
artificial intelligence training in coimbatore
digital marketing course in coimbatore
digital marketing training in coimbatore
embedded system course in coimbatore
embedded system training in coimbatore
Subscribe to Post Comments [Atom]
<< Home
Subscribe to Posts [Atom]