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,

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, phNo are stored. 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. Students have to mandatorily register for Courses (ccode, cname, credits) that are taught by staff. Students and staffs are associated with one or the other departments which have only one attribute dname which also serves as a primary key. Draw the ER diagram with appropriate notations, relationships with cardinalities and participation constraints. (Note: Make no new assumptions regarding the design and strictly adhere to the given details only)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

ER diagram as ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!