Requirement Analysis

-E-Commerce website: If you've a store that sells things, you'll need an eCommerce website, sometimes known as an e-store. A good eCommerce platform will encourage you to manage all of the webpage technical aspects. Opencart, Woocommerce, Zencart, Magento, OsCommerce, and other systems are among the many options for creating an eCommerce site.

-CMS or dynamic website:Dynamic data can be conveyed through a dynamic digital marketing. This entails relying on modifications to happen; the site information is automatically updated based on a few parameters. Its design is based on information management systems (CMS) such as WordPress, Joomla, and others.

- Static website design:A static design is appropriate when you only require a few web pages and not need the data to update. The information on a static site remains the same as previously and does not change over time. HTML, CSS, and Java are used to create static webpages. They're easy to make and search engines can readily crawl them.

Modelling / Design

This is an E-commerce site. The database design for the website was focused on the management of coding systems. Students' attendance can be secured and monitored using the technology. As during verification of presence, the school administrator may have information to the individuals' status. Overall, they are capable of managing and updating student attendance.

The Entity Relationship Diagram for such a Technology is the object of the E-commerce Application portal, that is provided via tables, as seen in the figure above. The databases are designed to suit the system's requirements and to provide considerably more detailed information about each entity inside the system. The goal of this ER Diagram would be to thoroughly comprehend both the E-commerce Website and the column interconnections in the enterprise database design. 

The practise of effectively organising data in a database is known as data normalisation. It eliminates discrepancies and reduces unnecessary data. It's especially important and beneficial for companies that sell and retain data on lots of items with comparable features.Normalizing product data is an important part of efficiently preserving ecommerce shop data since it allows you to receive data in the right structure and data objects in exact fields, as well as standardised and comparable category input parameters.

An e-commerce supply chain is a collection of business activities that explain how online customers engage with e-commerce systems. A supply chain aids in the comprehension of e-commerce business operations and the identification of information requirements for the development of functional database systems.

Implementation

A data model for an e-commerce system is shown below. A column in your databases that uniquely defines that column in ones data store is required for a database system to function effectively. This field is known as the table's Unique Key Field. To connect with some other columns in SQL 7 and other increased database systems, every table must have a Single Row Identification or Primary Key. This is not required by Access, and that will join tables that do not have properly organised relationships. The connections among tables are depicted in the table below. It's possible that not all of those tables or data are required for your project.

Evaluation 

There are some query that describe the given websites.

Output: