Semester Exam System Erd Essay Example

Semester Exam System Erd Essay Example Semester Exam System Erd Essay Semester Exam System Erd Essay Semester Examination System DBMS Lab Assignment Group III Srimanta Singh (004) Samik Saha (015) Prasenjit Gayen (016) third yr. first sem. , Department of Computer Sc. Engg. Jadavpur University ASSUMPTIONS Data prerequisites: ? The significant attributes of the semester assessment framework are†¦Ã¢â‚¬ ¦.. The college has numerous offices which are distinguished fundamentally by the department_id. Likewise the offices have a specific area (grounds). ? Every division has educators. Every educator is doled out to show a specific subject. He likewise needs to make question paper and assess the appropriate response content. WE have expected that an instructor can take classes in various division yet he will have a place with a specific office. ? A specific division may offer not many courses. At least one subjects might be same for various courses just as offices. Same subject (name) in two courses or office is independently distinguished by the comparing subject_id. ? Subject_id for a course of a division is one of a kind. ? An understudy must enroll to show up in the test. An enrolled understudy is considered as test up-and-comer. ? Test can be of two sorts â€regular and valuable. If there should arise an occurrence of beneficial an applicant might not need to show up in all the subjects doled out to a specific semester. ? The test controller segment is the executive of this entire assessment framework. Element SETS USED IN E-R DIAGRAM For building a reasonable construction of this information base, the substance sets and the related traits are given underneath (as our determination of the E-R diagram)†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦.. Substance SETS 1. Understudy 2. Division 3. Instructor 4. Subject 5. Test ASSOCIATED ATTRIBUTES Name, Roll No, Reg. No, Contact No Department_id, Name, Location Teacher_id, Name, Contact No, Status Name, Subject_id ,Course, Dept Exam_id, Roll No, Sub_id, Exam roll no. 6. Test Candidate Semester, Year, Exam_id, Sub_id 7. Result 8. Routine Roll no, Exam_id, Sub_id, Grade, Date_of_publish Date, Time, Room No, Exam_id ? Understudy: Student tries out a course in a specific office, every understudy has a roll no by which they are distinguished exceptionally, and every understudy likewise has an enlistment number. Every understudy needs to select to show up in the assessment as a competitor. An understudy likewise have additionally have contact number and address. ? Division: University has such a large number of offices. Every division has a one of a kind department_id, name. The divisions have their particular area and contact number. ? Educator Each office has numerous instructors. Every educator has their relating teacher_id, contact no. , name and status. Every instructor is remarkably recognized by the property teacher_id. Contact no. of the instructors may have various qualities. ? Subject: Each office offers numerous courses and each course comprises of subjects. Here each subject have subject name, subject_id. The subjects are extraordinarily recognized by their relating subject_id. Same subject can be educated in a few divisions yet all things considered the subject_id will be extraordinary. ? Test : The entire semester assessment framework is sorted out in scarcely any tests. These tests are recognized by the exam_id, semester and year in which the test is taken. Test might be of two kinds †ordinary and valuable. Exam_id is the essential key of this substance. All properties are nuclear. ? Test Candidate : Each understudy needs to enlist his name for the assessment. After enrollment for the test he accomplishes the candidature for that specific test. An up-and-comer is remarkably distinguished by his test roll no. It contains competitor name, roll no. , sub_id and exam_id. ? Result : Each test must have their relating results. Result is additionally connected with the understudies. Subsequently the consequence of an understudy of a specific semester is distinguished utilizing roll no, subject_id, exam_id. It additionally contains evaluation and date of distribution of the outcome as traits ? Routine : Each test has a relating routine which comprises of date, time, room no. also, exam_id. RELATIONSHIP SETS FOR DATA BASE In our E-R chart determined relationship sets and mapping cardinalities are portrayed beneath: ? Has This is the 1-to-numerous double relationship set among office and understudy substance sets. What's more, the support of the feeble substance set. We additionally have a coordinated twofold has connection between the test and the test results. ? Has a place with This is the 1-to-numerous double connection transport set among DEPARTMENT and TEACHER sets. Since for a specific division there are numerous educator yet for an instructor just 1 office is fixed. Furthermore, the investment of the educator substance sets in this connection transport sets is halfway. ? Trains This is the many-to-numerous parallel relationship sets among educator and subjects. Selects This is the balanced twofold relationship sets among Student and Exam Candidate. Segment properties are: date, month, and year. ? Sits for This is a many-to-numerous parallel relationship sets between the Exam Candidate and the Examination. ? Booked This is the relationship that holds between the assessment and the test schedule. ? Holds This is a many-to-numerous parallel relationship set between the division and the assessment. ? ISA This is a relationship set that holds between the test and the two classification of test customary and advantageous. Of This connection holds between the test and subjects just as the subject and results. ? Gets This is the relationship sets between Exam Candidate and the Results. name dept. no. name has a place with office contact no. instructor educator id has of sub-id name roll no. understudy regd. no. contact no. dept. no. (fk) assigne d to instructs sem year test id test sub-id (fk) ISA of subject name selects booked routine time room no date test id (fk) Sub-id ordinary sits for valuable of has test id (fk) enlisted gets sub-id sub-id grade roll no. (fk) test id (fk) roll no. results Date distributed