after reading the proformas that we are provided with i have extracted faculty, department, student, course, entities, room and organization entites which are major entites of the assignment and rest of the 4-5 entities are mentioned in ERD of the assignemnt. In this assignment i have designed web forms for the major entites and some login mechanisam for both faulty members and students to provide them to access to records is also designed.
To dsign the database I designed and define business logic myself where i have don’t get any idea about business rules. For example, one department may have many teacher and one teacher may belong to many department. but it can be considered as one teacher can belong to one department and one department can have many teacher.Anyhow the total entities are 11 in numbers.
Database file is created in appdata folder and forms are located in view folder and the controller of these web forms are in controller class. All of the forms are handled on the sample web application of the default MVC project of visual studio