Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider a website that partners universities and organisations that are industry leaders to provide courses to learners. Each university/organisation has a unique name, a description
Consider a website that partners universities and organisations that are industry leaders to provide courses to learners. Each university/organisation has a unique name, a description and an email address. In addition, each organisation has a focus area. Each course is offered by a partner and is listed with a unique course code, a course title, a synopsis, the duration of the course (in terms of weeks), the number of hours of material per week, whether it is learner-paced or instructor-led, the number of graded assignments, a subject category such as computer science, math, business, engineering etc and a level category: beginner, intermediate, etc. Each course has a date by which learners must enrol and an end date after which course is unavailable. When the course becomes available again, it will have a new enrol-by date and an end-date. The assignments for a course are weighted and are identified with a running number generated for each course. Courses offered in different periods may differ in course fee, instruction mode, assignments and their weightages, duration of course and hours of material per week. Learners choose to either pay for a course or audit for free. Course materials are available to learners for download if they pay for the course, and these learners are awarded a certificate if they submit assignments and obtain an overall pass grade for the course. The overall grade is computed using the weights for the assignments and the corresponding grades obtained. This, each submission should include a submission date and a grade after it has been graded. A learner who audits for a course may subsequently decide to pay and to submit assignments to earn certification. Once the course fee is paid, no refund is possible. The enrolment date for course is recorded for each learner, and if the course is paid, the payment date and payment reference is recorded as well. The course fee varies from course to course. Courses that are offered by universities may be standalone or may be taken as part of a program. A learner who enrols in a program will earn a specialist certification in addition to the certification for individual courses he selects from the set of courses for a program. Each program will require a learner to pass certain numbers of courses offered at specified levels (beginner, intermediate etc). For example, a program for Data Science A offered by university X may require 3 courses at beginner level and 2 courses at intermediate level. If a course has prerequisites, the learner must take the pre-requisite courses first. The date a learner enrols into a program must also be recorded, and if he completes the program, the date of completion is recorded. There is no time limit to when a program must be completed by. A learner may re-enrol for a course if he does not clear it, regardless of whether the course is taken standalone or as part of a program. To re-enrol, he needs to pay the prevailing course fee when the course becomes available and submits assignments accordingly. Note that two learners may also enrol in the same program or the same course on the same date and complete the same program on the same date. The website offers two types of account: a business account and an individual account. Each account has an email and a name. The gender, full name (for certification purpose) and highest education qualification are recorded for individual account. All learners must have an individual account through which they enrol in program and/or enrol for courses. A business account is a paid account renewable on a per-year basis, and the yearly amount paid is dependent on the number of individual accounts it can create and remove from the business account. Individual accounts created through a business account are eligible for discount on course fee if the duration of the course falls within the paid period. Individual accounts that are removed from a business account function as standalone individual accounts (that is, not tied to any business account) and thereafter, will pay full course fee if a learner is not auditing. Without adding any attribute/identifier not described in the question, construct a conceptual (ER) model from the statements of requirements to represent the data model, showing: - entities, with entities name, relevant attributes and identifier, (10 marks) - relationships with maximum and minimum cardinalities and relationship name (10 marks) State your assumption(s) for only data requirements that are not specified
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started