Relational Database Design -The First Normal Form and Decomposition

[@thebadalkumar]

Thank mam for this video, i need one help, Actually I'm creating a project, in which University releases semester wise results in a PDF.. I've make a script which convert the file into csv and can easily saves in DB..if we need ( means I can able to insert into db from csv). But I don't know what DB schema I've to create so that i can show all semester Result in one place.. Problem: University has many colleges under it. Courses had different batches and semesters. Each semester has different subjects. What i get from PDF file into CSV: Roll Number Name Batch Semester College name Marks with respect to semester subjects I want to store these details in a proper manner into DB So that i can insert all semester record into propert.manner... So that any college student can see the result by entering details. Currently my project is working as there is no update and delete to be done as it comes from University data, only I've to show those data .. But i want good DB design to store those data..

[@ShivamGajjar]

How was it, bro? How did it proceed? Did it work?

[@Jyovita1047316]

Use normalization upto 3NF to design your database