Wednesday, September 2, 2020

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 qualities of the semester assessment framework are†¦Ã¢â‚¬ ¦.. The college has numerous divisions which are distinguished fundamentally by the department_id. Likewise the offices have a specific area (grounds). ? Every division has educators. Every instructor 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 office however he will have a place with a specific office. ? A specific office may offer hardly any 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 relating subject_id. ? Subject_id for a course of an office is one of a kind. ? An understudy must enroll to show up in the test. An enlisted understudy is considered as test applicant. ? Test can be of two kinds â€regular and valuable. If there should arise an occurrence of beneficial an up-and-comer might not need to show up in all the subjects appointed to a specific semester. ? The test controller segment is the head of this entire assessment framework. Substance SETS USED IN E-R DIAGRAM For building a reasonable composition of this information base, the element sets and the related properties are given underneath (as our particular of the E-R diagram)†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦.. Substance SETS 1. Understudy 2. Division 3. Educator 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 joins up with a course in a specific division, every understudy has a roll no by which they are distinguished interestingly, and every understudy additionally has an enrollment number. Every understudy needs to select to show up in the assessment as an up-and-comer. An understudy likewise have additionally have contact number and address. ? Office: University has such a large number of offices. Every division has a remarkable department_id, name. The offices have their separate area and contact number. ? Instructor Each division has numerous educators. Every educator has their relating teacher_id, contact no. , name and status. Every educator is exceptionally distinguished by the property teacher_id. Contact no. of the instructors may have numerous 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 distinguished by their relating subject_id. Same subject can be instructed in a few offices 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 †customary and advantageous. Exam_id is the essential key of this substance. All characteristics 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 particularly recognized by his test roll no. It contains up-and-comer name, roll no. , sub_id and exam_id. ? Result : Each test must have their comparing results. Result is likewise connected with the understudies. In this manner the aftereffect of an understudy of a specific semester is distinguished utilizing roll no, subject_id, exam_id. It likewise contains evaluation and date of distribution of the outcome as properties ? 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 depicted beneath: ? Has This is the 1-to-numerous double relationship set among division and understudy element sets. Also, the cooperation of the frail substance set. We additionally have a balanced paired 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 instructor yet for an educator just 1 office is fixed. What's more, the investment of the instructor substance sets in this connection transport sets is incomplete. ? Trains This is the many-to-numerous twofold relationship sets among instructor and subjects. Enlists This is the balanced paired relationship sets among Student and Exam Candidate. Part properties are: date, month, and year. ? Sits for This is a many-to-numerous paired relationship sets between the Exam Candidate and the Examination. ? Planned This is the relationship that holds between the assessment and the test schedule. ? Holds This is a many-to-numerous paired relationship set between the office and the assessment. ? ISA This is a relationship set that holds between the test and the two class of test normal and strengthening. 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 enlists booked routine time room no date test id (fk) Sub-id customary sits for beneficial of has test id (fk) selected gets sub-id sub-id grade roll no. (fk) test id (fk) roll no. results Date distributed

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.