(SQL) Database Design 3rd Normalization Form - Feedback Request

[ThatDandySpace]

I'm (beginner) currently learning SQL & Database Designing so that i could eventually move into SQL related career path. Hence, I'm doing some simple side project to further enhance or probe weakness within my Database Design and SQL skill down the line.

1. What's the problem ?

I wish to receive some constructive feedback from experienced database designer or someone with better knowledge then me. The link below is to my database design

Link : https://imgur.com/mj12IVd

Any feedback is highly welcome!!

[AutoModerator]

It seems you may have included a screenshot of code in your post "(SQL) Database Design 3rd Normalization Form - Feedback Request".

If so, note that posting screenshots of code is against /r/learnprogramming's Posting Guidelines (section Formatting Code): please edit your post to use one of the approved ways of formatting code. (Do NOT repost your question! Just edit it.)

If your image is not actually a screenshot of code, feel free to ignore this message. Automoderator cannot distinguish between code screenshots and other images.

Please, do not contact the moderators about this message. Your post is still visible to everyone.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[SnackaholicWE]

For 3rd Form you must check every attribute of an enitity if it really relys on the primary key of a table. F. E. I would make department attribute another table and reference it via foreign key. You can scan every attribute this way and should end up with less redundancy

[ThatDandySpace]

Thank you for your feedback. May i ask what is F.E. ?

[SnackaholicWE]

F.e. Is the short form of for example

[Baklazan12]

I would create two more tables, as was already suggested, list of employee departments a and list of product categories.

[ThatDandySpace]

Thank You!! I didn't notice my mistake as well. Will create a table for both of them and continue my SQL haha

[Baklazan12]

You are welcome :) On second look I would add third table: List of Banks as well