Question

Consider the scenario where the School has to automate its systems and wants to store details of its staff Details like their sno, name, salary, dob, doj, experience, age, gender and phNo . Sno is the primary key, experience is a derived attribute. The student details like regNo, Name, sem, age, city, dob, age, phNo are stored. RegNo is the primary Key, phNo is a single valued attribute, and Students have to mandatorily register Courses (ccode, cname, credits) are taught by staffs. Students and staffs are associated with one or the other departments which has only one attribute dname , this also serves as a primary key. Draw the ER diagram with appropriate notations, relationships with cardinalities and participation constraints.

Answer 1

An ER diagram consist of three things

1)Entities:-School,Student,Course,Department,Staff_details

2)Attributes:-sno,name,salary,dob,doj,phno,age,ecperience,ccode,cname,credits,regNo,sem,dname,etc

3)Relationship:-has,stores,register,taught by,assciated with

Note:Cardinality is shown in the above diagram

********************************************************************************************************************

In case of any doubt do ask in the comment section