make the ER model

Database design principle: 1) Designing database duplicate data or record is not good it waste space and increase errors. 2) The data or record which u insert is must be accurate and complete. 3) Records are must normalize in form to avoid redundency. Relational table database is designed for college database: Student INT Sam VARMA AS VARDAS Degree VARDAR (45) Pastebe VAROR:49) Studenten SNT StudentDegree See Degean VASAR Durat Leam Regret Module MIGE VROUREUS Module leader Malue Jeader Module Jederm VARCHAR(453 Mode Mode Movie Studeepee Suderer DT Middle_eaderVRDUR SVAR Department ARCHAR45 Sudeeree Sud Student Studie Sudent Sudeer Teach Share on Lecturer Lecture Lecture VMD45) Let VARORES Modile_ender_Module_N Module_made_Module Mode Module Meader Module Sider Dete Study Question 4 A database is to be designed for a college to monitor students' progress throughout their course of study. The students are reading for a degree (such as Diploman, Advance Diploma, Bachelors, Masters, etc) within the framework of the modular system. The college provides a number of module, cach being characterised by its code , title, credit value, module leader, teaching staff and the department they come from. A module is co- ordinated by a module leader who shares teaching duties with one or more lecturers. A lecturer may teach (and be a module leader for) more than one module. Students are free to choose any module they wish but the following rules must be observed: some modules require pre-requisites modules and some degree programmes have compulsory modules. The database is also to contain some information about students including their numbers, names addresses, degrees they read for, and their past performance (ie. modules taken and examination results). Answer for, basic draw Normalization table design in database ,Describe the principles of database design and apply them to practical situations, Determine the method for organizing and recording the data and Carry out Logical and Physical database design. Database design principle: 1) Designing database duplicate data or record is not good it waste space and increase errors. 2) The data or record which u insert is must be accurate and complete. 3) Records are must normalize in form to avoid redundency. Relational table database is designed for college database: Student INT Sam VARMA AS VARDAS Degree VARDAR (45) Pastebe VAROR:49) Studenten SNT StudentDegree See Degean VASAR Durat Leam Regret Module MIGE VROUREUS Module leader Malue Jeader Module Jederm VARCHAR(453 Mode Mode Movie Studeepee Suderer DT Middle_eaderVRDUR SVAR Department ARCHAR45 Sudeeree Sud Student Studie Sudent Sudeer Teach Share on Lecturer Lecture Lecture VMD45) Let VARORES Modile_ender_Module_N Module_made_Module Mode Module Meader Module Sider Dete Study Question 4 A database is to be designed for a college to monitor students' progress throughout their course of study. The students are reading for a degree (such as Diploman, Advance Diploma, Bachelors, Masters, etc) within the framework of the modular system. The college provides a number of module, cach being characterised by its code , title, credit value, module leader, teaching staff and the department they come from. A module is co- ordinated by a module leader who shares teaching duties with one or more lecturers. A lecturer may teach (and be a module leader for) more than one module. Students are free to choose any module they wish but the following rules must be observed: some modules require pre-requisites modules and some degree programmes have compulsory modules. The database is also to contain some information about students including their numbers, names addresses, degrees they read for, and their past performance (ie. modules taken and examination results). Answer for, basic draw Normalization table design in database ,Describe the principles of database design and apply them to practical situations, Determine the method for organizing and recording the data and Carry out Logical and Physical database design