# Activity 6: Normalizing Denormalized Data Using Excel

* **Sheet 1**: employeeData
    

employetbl

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731315102974/cb0390e9-bbfb-4af2-9723-13a94bcbe899.png align="center")

managertbl

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731315288864/d24a48a6-c171-4448-8710-9c9b019baa8e.png align="center")

departmentTbl

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731315358366/4284d560-9818-4725-a3c7-e1f17feb1f08.png align="center")

projectTbl

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731315409024/f282fc00-ba30-4eeb-ab69-a8af21f5e14e.png align="center")

* **Sheet 2**: studentData
    

studentTbl

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731315722656/d32fd56c-afbb-42f3-b92a-368bafdc84fe.png align="center")

teachertbl

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731315820721/71c265d8-e1d6-4878-a9da-38952ee27a8b.png align="center")

classtbl

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731315920064/a4b02241-7f63-4eef-9152-06f92a04605e.png align="center")

coursetbl

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731315933072/57433853-e477-4a09-aee1-0c2ed5fd1d1c.png align="center")

guardiantbl

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731315989977/6eea396d-8eea-4585-bfe4-39d57df9b8e4.png align="center")

* **Sheet 3**: productData
    

productTbl

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731316834137/fb682f82-06e8-4c2f-ba39-9d34c2bea70c.png align="center")

manufacturertbl

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731316967157/a6763bfe-5af9-441b-917f-63a8034f9390.png align="center")

warehousetbl

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731316992308/0e9f2f75-3864-45f3-8fbf-42c37951d62d.png align="center")

suppliertbl

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731317056789/f1a6b197-c324-4134-9db4-c1644b65fcae.png align="center")

categorytbl

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731317096536/6d735fd6-4d8f-43ad-9125-178d7542a861.png align="center")

* **Sheet 4**: orderData
    

ordertbl

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731317233451/21a03a1c-3983-4f3f-9e03-91ddb73a333d.png align="center")

shippingtbl

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731317382498/3af69f2d-75ec-45c2-8080-65b2e3f35fed.png align="center")

productTbl

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731317768563/2487ef6d-7455-4ee2-b356-cee90cdafae0.png align="center")

customertbl

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731317807171/9dbc809a-a80c-40c2-a6cb-a48b873d5d81.png align="center")

* **Sheet 5**: salesData
    

salestbl

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731318290131/845fe37a-2b90-4b36-a4be-5f204059d812.png align="center")

invoicetbl

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731318375143/90e106e5-7fd7-4b0e-8b6d-e81692f190a5.png align="center")

regiontbl

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731318478971/93a9a439-8ba8-4735-a27e-f15193447b3e.png align="center")

salestbl

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1731318447975/632ff616-0c6f-490f-8d2b-cb220ec923ed.png align="center")

[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)

[https://onedrive.live.com/:x:/g/personal/B8543046F6D7E6BF/EURaXicCZYFElaapEWRc4cwBdfh37\_CKI7j5nmmAlhK70A?resid=B8543046F6D7E6BF!s275e5a446502448195a6a911645ce1cc&ithint=file%2Cxlsx&e=luqDpK&migratedtospo=true&redeem=aHR0cHM6Ly8xZHJ2Lm1zL3gvYy9iODU0MzA0NmY2ZDdlNmJmL0VVUmFYaWNDWllGRWxhYXBFV1JjNGN3QmRmaDM3X0NLSTdqNW5tbUFsaEs3MEE\_ZT1sdXFEcEs](https://onedrive.live.com/:x:/g/personal/B8543046F6D7E6BF/EURaXicCZYFElaapEWRc4cwBdfh37_CKI7j5nmmAlhK70A?resid=B8543046F6D7E6BF!s275e5a446502448195a6a911645ce1cc&ithint=file%2Cxlsx&e=luqDpK&migratedtospo=true&redeem=aHR0cHM6Ly8xZHJ2Lm1zL3gvYy9iODU0MzA0NmY2ZDdlNmJmL0VVUmFYaWNDWllGRWxhYXBFV1JjNGN3QmRmaDM3X0NLSTdqNW5tbUFsaEs3MEE_ZT1sdXFEcEs)