Sergio's E-Commerce Blog

 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...

 What is ERD Entity relationship diagram also refer as ERD, ER model or diagram is a type of diagram based on database desing, ERD contains different symbols and connectors that visualize two important information; the major entities within the system scope and the inter-relationship among these entities. But what is an entity? we often refer to this as people for example students which is a tangible object, and tangible business objects eg product, relationship is about how these entities relate each other within the system. source: https://www.freepik.com/free-vector/cloud-services-isometric-composition-with-characters-working-people-cabinet-with-folders-server-capsule-vector-illustration_23128898. An ER diagram have entities, attributes and relationshops and we will explain each of these symbols; Entity Atributtes  has a name that describe the type and king of an attribute such as varchar for a string and int for integer, when a ERD is draw it is important to ensure the use...

 Definition  "SDLC stands for software development life cycle, it is a process that enables the production of high quality low cost software, the main goal of SDLC is to produce superior software that meets and exceeds the costumer needs and demand, the SDLC outline detail sections with different stages or  called phases. SDLC enhance the development speed and minimizes project risks and costs associated with methors of production" According to (synopsys, 2018) source:( https://www.freepik.com/free-vector/new-app-development-desktop_10276612) Why is so important? makes the project much easier to track the speed of the development is quicker  make better relation with the client  decrease the project failures  decreasing of cost production  provides a standar framework that define the activities  improve the visibility of the life cycle source:( https://www.freepik.com/free-vector/engineer-developer-with-laptop-tablet-code-cross-platform-developmen...

  I have create a costumer database to provide a visibility over the costumers that buy the products or any services that the company provides.  First step is to assing an specific ID number that will never change and not two same persons could have it therefore every costumer on the Database will be located.

 

 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.