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

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

Essential Features

Image
 Essential Features There are many features in an e-commerce website. According to a few of the most successful e-commerce websites, there are many essential features that are most commonly found and took part in its success (Purwati, 2011). Logo A logo represents the website or seller and instills trust in the customers. Each product has a logo that represents the seller or the website. It helps differentiate the brands and helps the customers in choosing the right product to buy. It communicates with the customers through images of different shapes, sizes and colors ( 'What makes a good ecommerce logo?', 2008). Navigation System Firstly, there is the navigation system. Its function is to help customers find their way through the website while shopping for products  to buy. In addition, it must be user friendly to better appeal to the customers. There are 3 types of navigation menus such as top navigation, side navigation and mega navigation. Top navigation is used when there...
Read more

4Ps of Marketing Strategies

4Ps of Marketing Strategies Marketing is a process of buying, selling, delivering and exchanging of products between businesses, and customers (American Marketing Association, 2022). Product It is basically the products of what your company sells to the customers which could be online or offline. It is promoted through the other 3Ps of marketing strategies. For example: Apple selling smartphones (American Marketing Association, 2022). Price It is the amount of value you charge the customers for buying your products. Depending on the fairness of the prices, you could either get a profit or none at all (American Marketing Association, 2022). Place This is the location of where you should sell your products and how it is delivered to the market. It could either be a place is real life or online (American Marketing Association, 2022). Promotion This includes advertising and promoting your products to the customers, showing them why they should spend their money on it and how it is useful t...
Read more