Member Avatar

Hi, I am working in a company that utilises many systems with their own databases. For example, the cafe has its own CAFE system with its own database (it could be postgresql). The Health Care system has its own database system (it could be MS SQL). The Transport booking has its own database system. And another system uses No-SQL database. I am faced with a task of producing web-based management reports to allow managers to see key performance indicators on screen. What would be the best way of accomplishing this? I would perform cross database queries of the key performance …

Member Avatar
+0 forum 4
Member Avatar

Hi! Im new to MySQL RDMBS. I know the basic CRUD if you know what i mean. Create Read Update Delete. I have 2 tables: Category table and Product Table Products should be categorized. Product table has PK as an ID and FK to Category Table How to INSERT INTO product table linking to specified Catageory Table? How to SELECT products with same FK? as well as UPDATE and DROP? Thanks in advance!

Member Avatar
+0 forum 11

The End.