Looking for a data modelling expert using Erwin Community Edition
$10-30 USD
Completed
Posted over 7 years ago
$10-30 USD
Paid on delivery
Hi,
I have a simple university assignment on database modelling task that needs to be accomplished using Erwin Community Edition. You need to make a logical/physical model of the scenario below. Its extremely simple and not that complex as industrial projects.
Scenario :
[login to view URL] semester,all students apply for and take courses offered.
[login to view URL] can cancel only courses that apply for in course registration period.
[login to view URL] will earn points and receive information about the courses they have completed.
[login to view URL] database manages the student's student number, name, department, gender, date of birth, address, and phone number.
[login to view URL] have a fixed number of credits and limited attendance.
[login to view URL] database provides subject code, subject name, purpose of subject, summary, subject progress chart and professor's information.
[login to view URL] data model provides classes and times for the courses you are taking.
[login to view URL] data model manages the advisor for the student, while the graduate student manages the title and research field of the thesis.
[login to view URL] data model manages faculty numbers, names, departments, and research areas for faculty.
[login to view URL] professor of students manages the hours of study counseling for each semester's students.
[login to view URL] professor of the graduate student manages the time for the dissertation for graduate students each semester.
[login to view URL] information manages department code, department name, department head professor, telephone number, and location.
The design must reflect the following:
You design a double binary relationship for applications and coursework.