Product Database

 Product Database








I have ten products listed in the product table with its unique ID, name, price, quantity and profit using the respective formula shown above in the second picture. I have used a pie chart to show the products and sale prices. I have also used a bar chart to show the profit gained or lost in the product table.

Comments

Post a Comment

Popular posts from this blog

Customer Database (Excel)

Image
Customer Database Below is my work of creating a customer database using Microsoft Excel: The table above organizes the data of all the customers that the suppliers needed to send or ship their products to them accurately. This also includes personal information such as phone numbers and email as a way to contact them in case any problem arises during the shipment of their products. The table also includes the customers' own unique ID to identify each of them separately. Their names and addresses must always be included so that the supplier could know each of their locations and identity. 
Read more

Advantages and Disadvantages

Image
  Advantages Reduces cost: Making an e-commerce website reduces most of the cost of setting up its own shop in reality such as displaying signs, arranging furniture, putting up the equipment and designs. Worldwide: Could sell much more products to customers globally from different countries and areas. Convenient: The customers could buy the products anywhere just by accessing their website. It also contains various functions and options for the customers to use to find products that suits their own taste. Cookies: E-commerce websites contain cookies that could help the seller check what the buyer has previously purchased which is a necessary information to provide complimentary items, Fast: Customers could buy the products more faster and saves time with just a few clicks. In addition, e-commerce websites could digest large amounts of client information in a short amount of time.  Privacy: The privacy of the clients when buying the products is much higher than buying them in r...
Read more

Understanding of Database

Database Database is a collection of structured information or data stored in electronical devices usually managed by Database Management System (DBMS). It is commonly used by displaying rows and columns of tables. The data structured inside would then be easily accessed, controlled, managed and modified. For example: emails, phonebooks and newspapers (Oracle, 2023).  Advantages of Using Database More organized and structured data Data errors can be checked so it is more accurate and reliable Prevents incorrect information being stored Easier to backup and recover data Increased security that reduces chances of mistakes in the data Protected by passwords and encrypted that denies unauthorized access Information can be retrieved faster East to use and learn Can be shared easily to everyone reduces amount of disk space and avoids multiple copies of the same data Easy to recover loss data (Williams, 2022) References Oracle (2023)  What Is a Database? Available at: https://ww...
Read more