1. Choose a company/business currently existing in the Philippines (Content should be within Philippine context) 2. Indicate the present database/data warehousing management scheme practiced by the business. Cite specific functions or schemas (e.g. Sales, Production, Logistics, Human Resource) 3. Signify the current issue(s) the company faces today (has faced in the past; or potentially will face in the near future) in relation to their database/data warehouse management.
1. Choose a company/business currently existing in the Philippines (Content should be within Philippine context)
2. Indicate the present database/data warehousing management scheme practiced by the business. Cite specific functions or schemas (e.g. Sales, Production, Logistics, Human Resource)
3. Signify the current issue(s) the company faces today (has faced in the past; or potentially will face in the near future) in relation to their database/data warehouse management.
4. Create a database model (using SQL Database Modeler --> https://sqldbm.com/Home/Links to an external site.) to mitigate the issues being faced by the company/business. Create relational tables and if possible, kindly connect such tables between AT LEAST TWO different SCHEMAS. Make a brief explanation of the tables, columns, and relationships formulated in the process.
Step by step
Solved in 7 steps
