-
Notifications
You must be signed in to change notification settings - Fork 4
Normalization & Finalization
Md Ehsanul Haque edited this page Aug 3, 2023
·
14 revisions
![](https://private-user-images.githubusercontent.com/133691757/257957405-aa07baa3-9065-4ba2-b95b-f21ccd7ca338.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ3Nzc2MjAsIm5iZiI6MTcyNDc3NzMyMCwicGF0aCI6Ii8xMzM2OTE3NTcvMjU3OTU3NDA1LWFhMDdiYWEzLTkwNjUtNGJhMi1iOTViLWYyMWNjZDdjYTMzOC5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODI3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyN1QxNjQ4NDBaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0wOTg4NDJjNjY1ZTc0MzA2MzQ5MzAzMDViNjc3ODU5ZTI1YmU0N2MxMGQxYjIzN2ZkZDFkZGY4YzEzMGNiZDgzJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.j4vBcfxnV4gpdtqwRjvuIgnoIhXEGAOT3BOEPKfIQrk)
![](https://private-user-images.githubusercontent.com/133691757/257957158-f20997de-ce27-4619-8d53-d885e81a9121.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ3Nzc2MjAsIm5iZiI6MTcyNDc3NzMyMCwicGF0aCI6Ii8xMzM2OTE3NTcvMjU3OTU3MTU4LWYyMDk5N2RlLWNlMjctNDYxOS04ZDUzLWQ4ODVlODFhOTEyMS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODI3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyN1QxNjQ4NDBaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0yMDY2ZjBhOTY4YTQ0ZjllZjkyODBkZmQwNTkyOTE4MWI2MTZhYTY1YWNmYTNmMmUwMDM3MjFlODY5OTgwNWNmJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9._F2zMtLQqX26ttDtNIK6bNGJcIN6Svhb5j4J6SomkrI)
- Unnormalized Form: P_ID(PK), P_name, P_duration, P_type, D_ID(PK), D_name, D_head
- 1NF: P_ID(PK), P_name, P_duration, P_type, D_ID(PK), D_name, D_head
-
2NF:
- P_ID(PK), P_name, P_duration, P_type
- D_ID(PK), D_name, D_head
- P_ID(PK), D_ID(FK)
- 3NF: Same as 2NF
- Tables:
- P_ID(PK), P_name, P_duration, P_type
- D_ID(PK), D_name, D_head
- P_ID(PK), D_ID(FK)
![](https://private-user-images.githubusercontent.com/133691757/257956696-f454bcf0-344b-469e-a887-845251330f36.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ3Nzc2MjAsIm5iZiI6MTcyNDc3NzMyMCwicGF0aCI6Ii8xMzM2OTE3NTcvMjU3OTU2Njk2LWY0NTRiY2YwLTM0NGItNDY5ZS1hODg3LTg0NTI1MTMzMGYzNi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODI3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyN1QxNjQ4NDBaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1jZWE4NmFlZDc2OTFkNGU2NDg0YmY1ODRmMmI2ZTkzNzI5MzJiODhiMDQ4YWQwYzNhNmM0Mjc1Y2JiYTA0Yzg1JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.3CabH04qVEGFkJJusmPJ-P4RmWnSopEgQ3eIsbnesDc)
- Unnormalized Form: D_ID(PK), D_name, D_head, E_ID(PK), E_Date, E_type, E_roomno, Mark
- 1NF: D_ID(PK), D_name, D_head, E_ID(PK), E_Date, E_type, E_roomno, Mark
-
2NF:
- D_ID(PK), D_name, D_head, E_ID(FK)
- E_ID(PK), E_Date, E_type, E_roomno, Mark
- 3NF: Same as 2NF
- Tables:
- D_ID(PK), D_name, D_head, E_ID(FK)
- E_ID(PK), E_Date, E_type, E_roomno, Mark
![](https://private-user-images.githubusercontent.com/133691757/257956738-43aeee54-af79-44c7-b50c-3898f5f12dc7.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ3Nzc2MjAsIm5iZiI6MTcyNDc3NzMyMCwicGF0aCI6Ii8xMzM2OTE3NTcvMjU3OTU2NzM4LTQzYWVlZTU0LWFmNzktNDRjNy1iNTBjLTM4OThmNWYxMmRjNy5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODI3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyN1QxNjQ4NDBaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1hN2JhNzI0Yzc0MGY4MTQwZGFjNjlkZmJiZWU3ZjE1YzdkYjBiZTdmOWQ4ZWM4MDQyNTdhNDYzZGUxYzA1ZGRhJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.XA5dy0yUgbhKNFrG0gsO-uS279hd2kH9-YTz3Bb1OBs)
- Unnormalized Form: S_ID(PK), S_name, S_contact, S_mail, EnrollYear, E_ID(PK), E_Date, E_type, E_roomno, Mark
- 1NF: S_ID(PK), S_name, S_contact, S_mail, EnrollYear, E_ID(PK), E_Date, E_type, E_roomno, Mark
-
2NF:
- S_ID(PK), S_name, S_contact, S_mail, EnrollYear
- E_ID(PK), E_Date, E_type, E_roomno, Mark
- S_ID(PK), E_ID(FK)
- 3NF: Same as 2NF
- Tables:
- S_ID(PK), S_name, S_contact, S_mail, EnrollYear
- E_ID(PK), E_Date, E_type, E_roomno, Mark
- S_ID(PK), E_ID(FK)
![](https://private-user-images.githubusercontent.com/133691757/257956126-40f380c1-a0a0-4026-bdaf-d988add6a5a5.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ3Nzc2MjAsIm5iZiI6MTcyNDc3NzMyMCwicGF0aCI6Ii8xMzM2OTE3NTcvMjU3OTU2MTI2LTQwZjM4MGMxLWEwYTAtNDAyNi1iZGFmLWQ5ODhhZGQ2YTVhNS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODI3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyN1QxNjQ4NDBaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT04YTNkNDBlNzdmOTliZjU5NjJjODUwODY0NGI0MDRjNjc1MmE0MTI2OWVjMjAyOTUyYjZiZTFjMDI2OTY3ZjA1JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.cs4s2R7bAjw9C6zKiz-7FivrowWCXzTA07fpNVhMPOI)
- Unnormalized Form: F_ID(PK), F_name, F_contact, F_mail, S_ID(PK), S_name, S_contact, S_mail, EnrollYear
- 1NF: F_ID(PK), F_name, F_contact, F_mail, S_ID(PK), S_name, S_contact, S_mail, EnrollYear
-
2NF:
- S_ID(PK), S_name, S_contact, S_mail, EnrollYear, F_ID(FK)
- F_ID(PK), F_name, F_contact, F_mail
- 3NF: Same as 2NF
- Tables:
- S_ID(PK), S_name, S_contact, S_mail, EnrollYear, F_ID(FK)
- F_ID(PK), F_name, F_contact, F_mail
![](https://private-user-images.githubusercontent.com/133691757/257957080-f46373b5-c45a-4e96-a201-5cd99ab7b675.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ3Nzc2MjAsIm5iZiI6MTcyNDc3NzMyMCwicGF0aCI6Ii8xMzM2OTE3NTcvMjU3OTU3MDgwLWY0NjM3M2I1LWM0NWEtNGU5Ni1hMjAxLTVjZDk5YWI3YjY3NS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODI3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyN1QxNjQ4NDBaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0wZjM4MTE5YWIyM2NiZGQ2YjgzODE2YTVjYWExYTE0ZjViMWNiODdkODBjMmViMDIxM2U3NzU4NmU2MjE5MDNmJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.mmxplo2RDp8iafuYA9X--HfOYOJOIimHbIMgQ8YIodM)
- Unnormalized Form: S_ID(PK), S_name, S_contact, S_mail, EnrollYear, Cl_roomno(PK), Cl_time, Cl_name
- 1NF: S_ID(PK), S_name, S_contact, S_mail, EnrollYear, Cl_roomno(PK), Cl_time, Cl_name
-
2NF:
- S_ID(PK), S_name, S_contact, S_mail, EnrollYear
- Cl_roomno(PK), Cl_time, Cl_name
- S_ID(PK), Cl_roomno(FK)
- 3NF: Same as 2NF
- Tables:
- S_ID(PK), S_name, S_contact, S_mail, EnrollYear
- Cl_roomno(PK), Cl_time, Cl_name
- S_ID(PK), Cl_roomno(FK)
![](https://private-user-images.githubusercontent.com/133691757/257957320-8c272be5-3ed9-4c24-8db2-cd0600cee53e.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ3Nzc2MjAsIm5iZiI6MTcyNDc3NzMyMCwicGF0aCI6Ii8xMzM2OTE3NTcvMjU3OTU3MzIwLThjMjcyYmU1LTNlZDktNGMyNC04ZGIyLWNkMDYwMGNlZTUzZS5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODI3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyN1QxNjQ4NDBaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT1jOWJlZWY4YTMyNjVhMjdjMzQ2ODc0MmI0YWNmNjUwZWVlZGI4M2UzYzk3Y2E3YzdlYWUxMjZiZWVlY2ZlNjcwJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.PbXSUCiWexgE91ozEF_wI8nkXOEaFNZxDkMkqazlzSw)
- Unnormalized Form: S_ID(PK), S_name, S_contact, S_mail, EnrollYear, P_ID(PK), P_name, P_duration, P_type
- 1NF: S_ID(PK), S_name, S_contact, S_mail, EnrollYear, P_ID(PK), P_name, P_duration, P_type
-
2NF:
- S_ID(PK), S_name, S_contact, S_mail, EnrollYear
- P_ID(PK), P_name, P_duration, P_type
- S_ID(PK), P_ID(FK)
- Tables:
- S_ID(PK), S_name, S_contact, S_mail, EnrollYear
- P_ID(PK), P_name, P_duration, P_type
- S_ID(PK), P_ID(FK)
![](https://private-user-images.githubusercontent.com/133691757/257956639-5a2f84cc-80cc-4b3d-92bb-7d18f04a4ec0.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ3Nzc2MjAsIm5iZiI6MTcyNDc3NzMyMCwicGF0aCI6Ii8xMzM2OTE3NTcvMjU3OTU2NjM5LTVhMmY4NGNjLTgwY2MtNGIzZC05MmJiLTdkMThmMDRhNGVjMC5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODI3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyN1QxNjQ4NDBaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT05ZmU4MjhkMjY2MGZkZmZlN2VmODk4NjQ2ZmJjMGU3MTgyM2I1OTU3YjQ1OWVmMDM0OTEyZWZiNzkwOGMyMjE5JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.ZJQcwiPWnBmXrpIUQuF17NGXqFgvyDSM0lYgKIWR6Gk)
- Unnormalized Form: S_ID(PK), S_name, S_contact, S_mail, EnrollYear, C_ID(PK), C_name, C_duration, C_credit
- 1NF: S_ID(PK), S_name, S_contact, S_mail, EnrollYear, C_ID(PK), C_name, C_duration, C_credit
-
2NF:
- S_ID(PK), S_name, S_contact, S_mail, EnrollYear
- C_ID(PK), C_name, C_duration, C_credit
- S_ID(PK), C_ID(FK)
- 3NF: Same as 2NF
- Tables:
- S_ID(PK), S_name, S_contact, S_mail, EnrollYear
- C_ID(PK), C_name, C_duration, C_credit
- S_ID(PK), C_ID(FK)
![](https://private-user-images.githubusercontent.com/133691757/257956343-2542a3ae-64a2-4c38-b4c5-6f989d036a3d.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ3Nzc2MjAsIm5iZiI6MTcyNDc3NzMyMCwicGF0aCI6Ii8xMzM2OTE3NTcvMjU3OTU2MzQzLTI1NDJhM2FlLTY0YTItNGMzOC1iNGM1LTZmOTg5ZDAzNmEzZC5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODI3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyN1QxNjQ4NDBaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0zNzYxNWY1YjMyZGFjMWYxNjk3YWJhMDA5OGFmYjU2YTc0YmE5NDI5YzA1ZjI1OGVlYTFhZDFiYjhiZTlhNDdjJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.IAx7elicOtiYIIRWjkBsWlX6xmdtafFovtvciaVbnMg)
- Unnormalized Form: F_ID(PK), F_name, F_contact, F_mail, C_ID(PK), C_name, C_duration, C_credit
- 1NF: F_ID(PK), F_name, F_contact, F_mail, C_ID(PK), C_name, C_duration, C_credit
-
2NF:
- F_ID(PK), F_name, F_contact, F_mail
- C_ID(PK), C_name, C_duration, C_credit
- F_ID(PK), C_ID(FK)
- 3NF: Same as 2NF
- Tables:
- F_ID(PK), F_name, F_contact, F_mail
- C_ID(PK), C_name, C_duration, C_credit
- F_ID(PK), C_ID(FK)
![](https://private-user-images.githubusercontent.com/133691757/257956197-5e72ea2b-2504-43a9-b7ad-1342121f00a4.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ3Nzc2MjAsIm5iZiI6MTcyNDc3NzMyMCwicGF0aCI6Ii8xMzM2OTE3NTcvMjU3OTU2MTk3LTVlNzJlYTJiLTI1MDQtNDNhOS1iN2FkLTEzNDIxMjFmMDBhNC5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODI3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyN1QxNjQ4NDBaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0xNjdjM2ZjMWM4ODBmMmVjNGM1NzgyM2VlMjEyMGFhNTIzM2JhMmQ5NmQzNTMzY2UxMDU5YTQwY2IxYzI1ZGRmJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.FTKw0HN9Cl-QtcgfXn4FMF4bpz835jlw1K_zfwwJdd0)
- Unnormalized Form: C_ID(PK), C_name, C_duration, C_credit, E_ID(PK), E_date, E_type, E_roomno, Mark
- 1NF: C_ID(PK), C_name, C_duration, C_credit, E_ID(PK), E_date, E_type, E_roomno, Mark
-
2NF:
- C_ID(PK), C_name, C_duration, C_credit
- E_ID(PK), E_date, E_type, E_roomno, Mark, C_ID(FK)
- 3NF: Same as 2NF
- Tables:
- C_ID(PK), C_name, C_duration, C_credit
- E_ID(PK), E_date, E_type, E_roomno, Mark, C_ID(FK)
![](https://private-user-images.githubusercontent.com/133691757/257956585-07ac9428-28c7-4a07-81a4-cf60013f9277.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ3Nzc2MjAsIm5iZiI6MTcyNDc3NzMyMCwicGF0aCI6Ii8xMzM2OTE3NTcvMjU3OTU2NTg1LTA3YWM5NDI4LTI4YzctNGEwNy04MWE0LWNmNjAwMTNmOTI3Ny5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODI3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyN1QxNjQ4NDBaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT05OGRkM2I2Y2U2N2RiMjE3OTc4OWUyOGE1MzdhNGQ4OGE5NDJkMzQyNDYzYWJjMjBiYWZlOTM2MTg5NzFlY2FkJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.LSCZUyQQF2mq-oQB24is5aQTgn1DJNuP8qfpsekzgUY)
- Unnormalized Form: D_ID(PK), D_name, D_head, F_ID(PK), F_name, F_contact, F_mail, C_ID(FK), C_name, C_duration, C_credit
- 1NF: D_ID(PK), D_name, D_head, F_ID(PK), F_name, F_contact, F_mail, C_ID(FK), C_name, C_duration, C_credit
-
2NF:
- D_ID(PK), D_name, D_head
- F_ID(PK), Fname, F_contact, F_mail, C_ID(FK), Cname, C_duration, C_credit, D_ID(FK)
- 3NF: Same as 2NF
- Tables:
- D_ID(PK), D_name, D_head
- F_ID(PK), Fname, F_contact, F_mail, C_ID(FK), Cname, C_duration, C_credit, D_ID(FK)
![](https://private-user-images.githubusercontent.com/133691757/257956398-424df486-4a52-4f43-9015-1ee6be54c8ab.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ3Nzc2MjAsIm5iZiI6MTcyNDc3NzMyMCwicGF0aCI6Ii8xMzM2OTE3NTcvMjU3OTU2Mzk4LTQyNGRmNDg2LTRhNTItNGY0My05MDE1LTFlZTZiZTU0YzhhYi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODI3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyN1QxNjQ4NDBaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT00OTM3ZDVhNGU5MDExYTgyNjcwZjZhMWNmZTdhOGE4NDIwMzMzNjMwZmM3MTBiMWVhMjA3NTg4NDc3ZmQyY2RhJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.kvXv3F5r1DKA80lfiO9d9Xm3TXyBmYxZ_hkcCct2cjU)
- Unnormalized Form: D_ID(PK), D_name, D_head, A_mail(PK), A_name, A_role, A_contact
- 1NF: D_ID(PK), D_name, D_head, A_mail(PK), A_name, A_role, A_contact
-
2NF:
- D_ID(PK), D_name, D_head, A_mail(FK)
- A_mail(PK), A_name, A_role, A_contact
- 3NF: Same as 2NF
- Tables:
- D_ID(PK), D_name, D_head, A_mail(FK)
- A_mail(PK), A_name, A_role, A_contact
![](https://private-user-images.githubusercontent.com/133691757/257956962-1ab39668-da83-486e-acce-6e7b09535cb3.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ3Nzc2MjAsIm5iZiI6MTcyNDc3NzMyMCwicGF0aCI6Ii8xMzM2OTE3NTcvMjU3OTU2OTYyLTFhYjM5NjY4LWRhODMtNDg2ZS1hY2NlLTZlN2IwOTUzNWNiMy5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODI3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyN1QxNjQ4NDBaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT0wM2IyMDI4MDZhMWUzMzIxMzAzYzk1YzcyZDkxMDlhNDgxZDk5N2U5Y2I5N2FjYjVlMmNmMzlkZGE4NDRmODIxJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.8rfgTYK7j1tS_M_6mAsEo4sGokBNKvp0ZejXFYXm5HU)
- Unnormalized Form: S_ID(PK), S_name, S_contact, S_mail, EnrollYear, G_ID(PK), CGPA, Semester, Sem_year
- 1NF: S_ID(PK), S_name, S_contact, S_mail, EnrollYear, G_ID(PK), CGPA, Semester, Sem_year
-
2NF:
- S_ID(PK), S_name, S_contact, S_mail, EnrollYear, G_ID(FK)
- G_ID(PK), CGPA, Semester, Sem_year
- 3NF: Same as 2NF
- Tables:
- S_ID(PK), S_name, S_contact, S_mail, EnrollYear, G_ID(FK)
- G_ID(PK), CGPA, Semester, Sem_year
![](https://private-user-images.githubusercontent.com/133691757/257956817-b5380d6c-ea48-41d7-aa1d-83f3a0ee7d6b.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ3Nzc2MjAsIm5iZiI6MTcyNDc3NzMyMCwicGF0aCI6Ii8xMzM2OTE3NTcvMjU3OTU2ODE3LWI1MzgwZDZjLWVhNDgtNDFkNy1hYTFkLTgzZjNhMGVlN2Q2Yi5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwODI3JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDgyN1QxNjQ4NDBaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT01NzE0Mjc3YjYzMWE4YTQxZjcyMzVlODE4ZGMxZmNkMTdhY2Q4OWJjYTQ3YjMxYTI2ODFiMDY3NDVhNGViMDY4JlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.fVbw9la3IUX3r_5EFXGuW-rZFCSMIwmKtzn-Rbh_4as)
- Unnormalized Form: F_ID(PK), F_name, F_contact, F_mail, G_ID(PK), CGPA, Semester, Sem_year
- 1NF: F_ID(PK), F_name, F_contact, F_mail, G_ID(PK), CGPA, Semester, Sem_year
-
2NF:
- F_ID(PK), F_name, F_contact, F_mail
- G_ID(PK), CGPA, Semester, Sem_year, F_ID(FK)
- 3NF: Same as 2NF
- Tables:
- F_ID(PK), F_name, F_contact, F_mail
- G_ID(PK), CGPA, Semester, Sem_year, F_ID(FK)
- P_ID(PK), P_name, P_duration, P_type
- D_ID(PK), D_name, D_head
- P_ID(PK), D_ID(FK)
- D_ID(PK), D_name, D_head, E_ID(FK)
- E_ID(PK), E_Date, E_type, E_roomno, Mark
- S_ID(PK), S_name, S_contact, S_mail, EnrollYear
E_ID(PK), E_Date, E_type, E_roomno, Mark
- S_ID(PK), E_ID(FK)
- S_ID(PK), S_name, S_contact, S_mail, EnrollYear, F_ID(FK)
- F_ID(PK), F_name, F_contact, F_mail
S_ID(PK), S_name, S_contact, S_mail, EnrollYear
- Cl_roomno(PK), Cl_time, Cl_name
- S_ID(PK), Cl_roomno(FK)
S_ID(PK), S_name, S_contact, S_mail, EnrollYearP_ID(PK), P_name, P_duration, P_type
- S_ID(PK), P_ID(FK)
S_ID(PK), S_name, S_contact, S_mail, EnrollYear
- C_ID(PK), C_name, C_duration, C_credit
- S_ID(PK), C_ID(FK)
F_ID(PK), F_name, F_contact, F_mailC_ID(PK), C_name, C_duration, C_credit
- F_ID(PK), C_ID(FK)
C_ID(PK), C_name, C_duration, C_credit
- E_ID(PK), E_date, E_type, E_roomno, Mark, C_ID(FK)
D_ID(PK), D_name, D_head
- F_ID(PK), Fname, F_contact, F_mail, C_ID(FK), Cname, C_duration, C_credit, D_ID(FK)
- D_ID(PK), D_name, D_head, A_mail(FK)
- A_mail(PK), A_name, A_role, A_contact
- S_ID(PK), S_name, S_contact, S_mail, EnrollYear, G_ID(FK)
- G_ID(PK), CGPA, Semester, Sem_year
F_ID(PK), F_name, F_contact, F_mail
- G_ID(PK), CGPA, Semester, Sem_year, F_ID(FK)
Table Name | Table Columns | Primary Key | Foreign Key |
---|---|---|---|
program | P_ID, P_name, P_duration, P_type | P_ID | |
dept | D_ID, D_name, D_head | D_ID | |
prodept | P_ID, D_ID | P_ID | D_ID |
deptexm | D_ID, D_name, D_head, E_ID | D_ID | E_ID |
exam | E_ID, E_Date, E_type, E_roomno, Mark | E_ID | |
student | S_ID, S_name, S_mail, S_contact, EnrollYear | S_ID | |
stdexam | S_ID, E_ID | S_ID | E_ID |
stdfac | S_ID, S_name, S_contact, S_mail, EnrollYear, F_ID | S_ID | F_ID |
faculty | F_ID, F_name, F_contact, F_mail | F_ID | |
classroom | Cl_roomno, Cl_time, Cl_name | Cl_roomno | |
stdcls | S_ID, Cl_roomno | S_ID | Cl_roomno |
stdpro | S_ID, P_ID | S_ID | P_ID |
course | C_ID, C_name, C_duration, C_credit | C_ID | |
stdcrs | S_ID, C_ID | S_ID | C_ID |
faccrs | F_ID, C_ID | F_ID | C_ID |
crsexam | E_ID, E_date, E_type, E_roomno, Mark, C_ID | E_ID | C_ID |
deptofferfaccrs | F_ID, F_name, F_contact, F_mail, C_ID, C_name, C_duration, C_credit, D_ID | F_ID | C_ID, D_ID |
deptauth | D_ID, D_name, D_head, A_mail | D_ID | A_mail |
authority | A_mail, A_name, A_role, A_contact | A_mail | |
stdgrade | S_ID, S_name, S_contact, S_mail, EnrollYear, G_ID | S_ID | G_ID |
grade | G_ID, CGPA, Semester, Sem_year | G_ID | |
facgrade | G_ID, CGPA, Semester, Sem_year, F_ID | G_ID | F_ID |