Using MS Excel, create a product database with at least 10 entries, with screenshots to document and show your progress

-

 I created a product chart with the product id, product name, unit price, sale price, stock quantity, stock sold, total cost and total sale. whit this information from my website products i have been able to see the total profit my products will make.



For the calculation i used different formulas such as SUM and MIN.



Comments

Post a Comment

Popular posts from this blog

Explore the computing definition of an E-commerce websites

-
Image
DEFINITION OF E-CCOMERCE It is also called 'Electronic Commerce' , it is the trade of services or goods on the internet, there are many  companies that sells products every day to different parts of the world, but there are also people that use ecommerce as their main strategy to engage with people they can use physical stores or other type of channel to sell their products. (Source: https://www.freepik.com/free-vector/ecommerce-web-page-concept-illustration) The huge advantage of ecommerce is that allows small business , or even well known companies to sell and to reach their costumers across the world just by using a webpage and of course having internet connection, also the second advantage is that you can use their service 24 hours every day without the need to go out and try the product by your own which for some people could be a very important disadvantage.  "A sales channel that crosses all industries that sell or promote brand awareness online and is considered...
Read more

Write about your understanding of databases. Explore the database advantages and write about database concepts such as primary and foreign keys

-
Image
 Definition  "A database is an organized collection of structured information, or data, tipycally stored electronically in a computer system. A database is usually controlled by a database managment system also called DBMS. Together the data and the DMBS alonf with the applicacions associated with them are referred to as a data system often shortened to just data base" acording to (Oracle, 2022) A very typical used modeled in rows and columns which make a table this is used to make the process of data and querying much efficient, the data can be managed and organized, most of this databases are structured on query language SQL for writing information. source:  https://www.freepik.com/free-vector/server-room-cloud-storage-icon-datacenter-database-concept-data-exchange-process_3628676. Differences between a spreadsheet and a database How the information is stored who can access the information  and how much of the data can be stored Databases are desing to store a much...
Read more

Types of E-Commerce

-
Image
 Business to Consumer (B2C) E-commerce is the use of web pages as a form of marketing where Business can promoted their own products to their consumers, Thanks to the modern internet business transactions has become more easy providing consumers the ease to purchase and explore virtually from every part 24 hours a day. Business to Business (B2B) It is basically the sales of goods between two Business via an online platform, B2B is growing so much during the last few years, some estimates the global market value is over 12 trillion. This B2B sellers must work with a wide range of sectors such as wholesalers, large retailers, organizations like schools and resellers.   Consumer to Consumer (C2C) I would like to talk about the most common is between costumers where they trade each other through out an online environment, this could be using eBay as the main platform, the good thing about this is that consumers benefit from the competition and often a third party.  Consu...
Read more