Using , create a customer database with at least 10 entries

Hasibul khan

 MS Excel


My database including first and last names was necessary for my website, which I created for an e-commerce assignment. Details about the city and a mobile number. Where I can view people's personal information from the shop.



my second database is called the products table


The product's name, ID number, unit price, stock sold price, sale price, stock quality, total cost, total sales, and profit are all listed here. But, there are also graphs so you can clearly see them. This database is a little complex, but it was created to make your job easier and show you how to have overall control over the items.


The product id explained. We need this id to understand how to identify each product well and if we see products online on our website then it becomes very easy to identify. product id is made up of a series of numbers. each one is different from the other





To understand which product is being discussed, one must understand the full name of the products. In any database system's table, the products' names and addresses are crucial.



The unit price is shown in this column. It's essential to understand how each product is evaluated.




This column is Sold Stock




The price of the things being sold is listed in this column.




This column has the stock quantity.


When you combine these two clones, the column's total cost, unit price, and stock quantity will appear.





You will get this when you mix these two clones, such as Stock Sold and Sale Price Total SALE




The graph ought to look like this. total cost and Total SALE



The last graphic is about. It's about the chart title 








Thank you







Comments

Post a Comment

Popular posts from this blog

Advantages and disadvantages of Meta tags

Hasibul khan
Image
 Advantages and disadvantages of Meta tags Advantages  of Meta tags   Why is the meta tag important? Meta tags are the first impression someone has of your page on a SERP. A good meta description will entice users to click through and visit your site. They ensure that search engines know what your content is about, so they will be able to show the website with the appropriate results. Think of it this way: You're browsing a store shelf and see a product with an outdated and generally unappealing label. Leave out important information, like what is the product made of? Then you see a label on another product that is fresh and appealing, with a visible ingredient list. You are about to buy the product with the best label. It's the same with meta tags, if your meta description is wrong, no one will click on your content. Meta descriptions are often the primary information that determines which result in users click on, so it's crucial that you use high-quality meta tags on y...
Read more

Website project initial idea

Hasibul khan
Image
 My Web Project Ideas (geralt, 2021) My ideas for creating the web page will be different first of all to create a web page you have to spend time. As an example, a new baby, first of all, must be kept well maintained same thing goes for a web page if I don't keep well maintained then my page will be lost and will be out of rank. for this reason, the first thing to make a web page is to be patient, and the second thing is to keep constantly updated. The third thing to do is the ability to comment and reply. The fourth thing does not accept any advertising. The fifth thing is to always give new updates. The sixth thing doesn't make the web page become heavy because otherwise, it will have a lot of trouble reloading. The seventh thing Home page must be very simple and beautiful to look at, certain moments we put so many things that it becomes chaotic. The eighth thing is always given opportunities like this It will make giant traffic on the page. The ninth thing is to not apply i...
Read more

Advantages and disadvantages of e-commerce

Hasibul khan
Image
Advantages and disadvantages of e-commerce What Are the Advantages of E-commerce? You came to learn what are the advantages of having an e-commerce business. Top of the list of advantages of e-commerce is the low financial cost, but other pros include selling internationally, retargeting customers, personalization of the buying experience, etc. These benefits of e-commerce will help you determine if starting an online store is right for you. ( Ferreira and  Oberlo (2022)  #1: Low financial cost #2: 24/7 Income Potential #3: Sell internationally #4: Bestsellers that are easy to showcase #5: Personalized online experiences #6: Convenient employees #7: Easier to encourage impulse buying #8: Easy retargeting or remarketing for customers #9: Customers get a less intrusive experience #10: Easily access customer data #11: Able to process a large number of orders #12: Can scale the business quickly #13: Grow your business organically with content ( Ferreira and  Oberlo (2022) Meh...
Read more