Skip to main content

Command Palette

Search for a command to run...

Activity 6: Normalizing Denormalized Data Using Excel

Updated
•1 min read•View as Markdown
  • Sheet 1: employeeData

employetbl

managertbl

departmentTbl

projectTbl

  • Sheet 2: studentData

studentTbl

teachertbl

classtbl

coursetbl

guardiantbl

  • Sheet 3: productData

productTbl

manufacturertbl

warehousetbl

suppliertbl

categorytbl

  • Sheet 4: orderData

ordertbl

shippingtbl

productTbl

customertbl

  • Sheet 5: salesData

salestbl

invoicetbl

regiontbl

salestbl

Book 1.xlsx

https://onedrive.live.com/:x:/g/personal/B8543046F6D7E6BF/EURaXicCZYFElaapEWRc4cwBdfh37_CKI7j5nmmAlhK70A?resid=B8543046F6D7E6BF!s275e5a446502448195a6a911645ce1cc&ithint=file%2Cxlsx&e=luqDpK&migratedtospo=true&redeem=aHR0cHM6Ly8xZHJ2Lm1zL3gvYy9iODU0MzA0NmY2ZDdlNmJmL0VVUmFYaWNDWllGRWxhYXBFV1JjNGN3QmRmaDM3X0NLSTdqNW5tbUFsaEs3MEE_ZT1sdXFEcEs

More from this blog

Jov's Blog

48 posts