Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

There can't be many to many relationships in the final ER diagram so they must be changed to multiple one-to-many relations. please add all the

image text in transcribed

There can't be many to many relationships in the final ER diagram so they must be changed to multiple one-to-many relations. please add all the necessary entities attributes cardinality and relationships

Draw an ERD Problem Description: We are going to design a database that works as a repository of the questions for courses offered at university. Using this repository, we would like to analyze if the learning objectives of the courses have been met. The following shows the business rule. At university, professors teach a variety of courses. Based on the nature of the course, each professor chooses a different combination of assessment types. The assessment type include exams (i.e., midterm(s) and final), projects, assignments, quizzes, in-class activities, surveys, presentations and so on. Each professor may use a combination of assessments for each course that they teach. For example, for a course such as "introduction to database systems", in-class activities, written exams, projects and presentation are means of assessing students, however, no popup quiz is used in this course. For a course such as "Human Computer Interaction", however, no exam is given, instead students work on a group project and present their design at the end of the semester. To each assessment a weight is assigned by the professors. For example, one assignment may have 10% while another holds 15% of the total grade. Some assessments have more than one question, and therefore each question has its own points. We would also like to store a sample solution for some of the assessments. For example, it does not make sense to have a sample solution for a presentation, but for a written exam it is possible . Every question in an assessment covers a learning objective. The learning objectives are classified into six levels including Knowledge, Comprehension, application, analysis, synthesis, and evaluation. For example, a question that is given in an exam may evaluate students' knowledge about a certain topic, while another assesses the application of that knowledge to solve a problem. Each six categories of learning objectives are further categorized to up to 10 subcategories. These subcategories are called Graduate Attribute Indicators (GAI). For example, 6GAl are assigned to analysis, while 10GAl are defined for synthesis. It is important for professors to ensure that they assess students comprehensively such that all the GAls are covered by at least one question/ assessment and all the learning outcomes are tested by two questions during the term. With the queries that we make on this repository, we should be able to answer several questions such as - What percentage of students passed a specific course. What percentage of the assessment for course X, meets the first learning outcome. - What types of assessments have been offered by course X in a specific year and term. - etc., etc., etc. Hint: - Although a course may be thought by many professors, but the type of assessments that they use may not be the same. - A professor teaches at least one course. - A course is only offered, if at least two professors are eligible to teach it. - For every assessment stored in the database, we should be able to identify to which year, term and course it belongs. - One assessment or question can cover only one learning outcome or GAI. - While the maximum cardinality is important, you should use your best judgment for the minimum cardinality, when it is not explicitly mentioned in the text

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_2

Step: 3

blur-text-image_3

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

Accounting And Auditing Research And Databases Practitioner's Desk Reference

Authors: Thomas R. Weirich, Natalie Tatiana Churyk, Thomas C. Pearson

1st Edition

1118334426, 978-1118334423

More Books

Students also viewed these Databases questions