salary dept name building budget ID name Watson 70000 22222

salary dept name building budget ID name Watson 70000 22222 Einstein 95000 Physics 90000 Finance Painter 120000 12121 Wu 32343 El Said 60000 History Painter 50000 75000 Comp. Sci Taylor 100000 45565 Katz 85000 80000 Elec. Eng. Taylor 98345 Kim Watson 90000 72000 Biology 76766 Crick 10101 Srinivasan. 65000 Comp. Sci Taylor 100000 Painter 50000 58583 Calif ieri 62000 History 83821 Brandt 92000 Comp. Sci Taylor 100000 Packard 80000 15151 Mozart 40000 Music Watson 70000 87000 Physics 33456 Gold 76543 Singh 80000 Finance Painter 120000

Solution

I don\'t think that there is any problem with you current database, but yes you can improve it even further with breaking the table in some more parts, like you can break the dep_name from this table and also the building column and prepare a relationship between columns like Id and departmentID that way you can improve your database.

if you like this answer, please give a thumbs up and if you have some doubt just ask in the comment section below. I will try to help. Cheers