Pisces Lin JSP is based on SSM company's commodity purchase, sale and inventory system v1.0

Pisces Lin JSP is an electronic supplier based on the SSM company's commodity purchase, sale and inventory system , which operates both a website and many physical stores. Examples include Best Buy and Circuit City. To learn more about this app, consider any experiences you may have had with online and store purchases and browse their website.

In our hypothetical company, it has been decided to redesign a major part of the database that serves as the basis for the company's operations. Unfortunately, the manager assigned to solicit database design advice was not very computer literate and was unable to provide a very detailed specification on a technical level. Fortunately, you can do this.

Here are a few points to consider:

There are many different products, divided into various (possibly overlapping) categories. Groupings can be by product (camera, phone, etc.), manufacturer (Sony, Apple, etc.), or by other means (for example, a Gateway PC might be packaged with a Sony monitor and an HP printer and sold as a package).
Some customers sign contracts with the company and charge their purchases to account numbers. They are billed monthly. Other customers are uncommon customers who pay by credit or debit card. Card information can be stored for online customers but not for in-store customers.

Online sales must be sent to the shipper. The company needs to store tracking numbers for shipping lines so it can answer customer inquiries.
Inventory must be accurate both in stores and in warehouses for replenishing stores and shipping to online customers. When inventory is low, orders should be resent to the manufacturer and listed in the database. When goods arrive, the inventory is updated and marked as filled for reordering.

Sales data are important for company planning. Marketers may want to view sales data by time, product, product grouping, season, region (store), etc.

Screenshot of Pisces Lin JSP based on SSM company's commodity purchase, sale and inventory system