Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the ERD for the simple University system we developed in Task 1. In this example we were using North American terminology, and the structure

image text in transcribed
Consider the ERD for the simple University system we developed in Task 1. In this example we were using North American terminology, and the structure was quite simple, lets add more complexity. The term course will be redefined as per the Australian meaning, where a course represents a collection of units (subjects), each course has a course code as before, but a course is composed of a number of Units where each Unit has a unit code a name and a number of credit points associated with it. A Unit could be common to a number of courses. Rather than Sections as per Task 1, each semester a number of units are offered for students to be able to enrol in, as part of their course. A full-time student will normally enrol in a maximum of 4 units per semester, a part-time student will normally enrol in a maximum of 2 units per semester. However these numbers can vary (more or less) depending on departmental approval. Additionally, a student could possibly take leave and not enrol in any units in a particular semester. As well as a the above information consider what attributes would need to be stored in order to be able to printout a student transcript. This details all the Units a student has undertaken for a particular course, and prints out (ordered by semester), each unit, the letter grade obtained, and the total number of points earned in the degree so far. Make the appropriate changes to the ER diagram developed in Task 1 to account for these new expanded requirements

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Algebra With Applications

Authors: Ernest Julius Wilczynski ,Herbert Ellsworth Slaught

1st Edition

1017336490, 978-1017336498

More Books

Students also viewed these Mathematics questions