# Activity 6: Normalizing Denormalized Data Using Excel

### **Steps for the Activity**

1. Open Excel and create a new workbook.
    
2. Rename each sheet to correspond with the following datasets:
    

## **employeeData**

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1727932473136/34db8f07-370d-4b7d-aaeb-c5d060b3221c.png align="center")

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1727932489661/a727567a-41cc-4539-99c3-525b1d04c7e7.png align="center")

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1727932554305/dd34ccca-d5f0-4b10-ab40-7a6aad2f68c7.png align="center")

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1727932568685/67ef9128-dd73-4957-ae5f-e625e245d559.png align="center")

studentData

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1727933212987/76b60895-9472-4dfb-b251-94cb20523077.png align="center")

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1727933354631/d5debc54-6289-49d4-bb1e-d4168c373ea5.png align="center")

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1727933370740/6b907cc3-dea9-476d-a718-4796f383f459.png align="center")

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1727933380424/08e72594-0254-4819-9138-7508e1e0218f.png align="center")

productData

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1727933650534/8a147346-b20e-4ae6-81e7-660997d6083c.png align="center")

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1727933868636/f4f94f2d-35d1-4287-8f65-6b11cb864999.png align="center")

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1727933970730/3dd3387b-ea8f-4b18-8aff-5ffd9dcfb0f9.png align="center")

orderData

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1727934180410/3f3877c7-8112-4c68-9718-4036150527b7.png align="center")

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1727934190912/565c86fd-150f-4247-b54f-b3ff8131be6e.png align="center")

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1727934209409/5c3c0c70-3748-4408-a316-3a462d5f1e9f.png align="center")

salesData

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1727934381420/438dd970-905b-4034-8cb2-5a38c49dd917.png align="center")

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1727934578205/60cecc83-4539-426c-a17c-b67c36cc9e27.png align="center")

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1727934595913/3838b0db-8f90-4b3b-bfdd-09ed577a8781.png align="center")

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1727934613803/c0f73a14-1d16-41ac-aee6-728794d330bf.png align="center")

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1727934630872/c756488c-fd55-4f3c-90cd-faf83ad5e7d5.png align="center")

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1727934646709/a097b002-656b-496e-9500-b6a72d5eaf14.png align="center")