Limited Offer Get 25% off — use code BESTW25
No AI No Plagiarism On-Time Delivery Free Revisions
Claim Now
Prices start at $5 per page · plagiarism-free papers · free revisions for 14 days 24/7 support: support@bestwriters.com
Uncategorized

Complete ER model for university system

  • Posted
  • Authoradmin
  • Length284 words
  • Reading time2 min
Write My Assignment FREE

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

The post Complete ER model for university system appeared first on My Assignment Online.

Plagiarism Free Assignment Help

Expert Help With This Assignment — On Your Terms

✓ Native UK, USA & Australia writers ✓ Deadline from 3 hours ✓ 100% Plagiarism-Free — Turnitin included ✓ Unlimited free revisions ✓ Free to submit — compare quotes

admin

Academic writer and editor at BestWriters.

Get your paper off your plate tonight

Post your instructions for free. Prices start at $5 per page.

Place an order