A student in a university takes one or more courses according to his choice. But in order to be…

Scenario-1 In a university/college, a student called class representative (CR) represents other students of his class. The —STUDENT” entity may have attributes like University-ID, Name, and Phone Number etc. Let us draw an E-R Diagram of this case. Scenario-2 A student in a university takes one or more courses according to his choice. But in order to be a student, he must take at least one course. The course may have one attributes like Course-ID, Course-Name and Course-Fee etc. Draw ER diagram to show the relationship between “Student” and “Course”. Scenario-3 A course is always thought by some course teacher. A teacher cannot exist without corresponding course. A course may be thought by at least one or more teacher. On the other hand, a teacher may teach at least one or more course. Scenario-4 Each department has a HOD ‘chairman while chairman chairs only one department. Show the relationship. Chairman is a week entity because its existence is dependent on corresponding department. The relationship can be read as: “A department has a chairman” or “A chairman may have a department”. Scenario-5 A teacher belongs to only one and only one department. However, a department may have at least one or more teachers. The teacher can be visiting, part-time, or full-time. The relationship between “Teacher” and “Department” can be read as: “A teacher belongs to one or only one department. or “A department may have one or more teacher” Question: Complete ER model for university system to combine all 1,2,3,4 and 5 case scenarios

Attachments:

We are the Best!

course-preview

275 words per page

You essay will be 275 words per page. Tell your writer how many words you need, or the pages.


12 pt Times New Roman

Unless otherwise stated, we use 12pt Arial/Times New Roman as the font for your paper.


Double line spacing

Your essay will have double spaced text. View our sample essays.


Any citation style

APA, MLA, Chicago/Turabian, Harvard, our writers are experts at formatting.


We Accept

Secure Payment
Image 3