Design an enhanced entity relationship diagram

Assignment Help Database Management System

Reference no: EM131252370

Consider a grade book database in which instructors within an academic department maintain scores/points obtained by individual students in their classes. The data requirements are summarized as follows:

• Students are identified by a unique student id, their first and last names, and an email address.

• The instructor teaches certain courses each term. The courses are uniquely identified by a course number, a section number, and the term in which they are taught. The instructor also assigns grade cutoffs (example 90, 80, 70, and 60) for letter grades A, B, C, D, and F for each course he or she teaches.

• Students are enrolled in courses taught by the instructor.

• Each course being taught by the instructor has a number of grading components (such as mid-term, final exam, project, etc.). Each grading component has a maximum number of points (such as 100 or 50) and a weight (such as 20% or 10%). The weights of all the grading components of a course usually add up to 100.

• Finally, the instructor records the points earned by each student in each of the grading components in each of the courses. For example, student with id=1234 earns 84 points for the grading component mid-term for the course CSc 2310 section 2 in the fall 2005 term. The mid-term grading component may have been defined to have a maximum of 100 points and a weight of 20% of the course grade.

Design an enhanced Entity-Relationship diagram for the grade book database and enter the design using a data-modeling tool such as ERWin.

Reference no: EM131252370

Questions Cloud

Did you agree or disagree with the information provided : Were there information in the article that you did not know prior to the article? What were those information? What else was missing from the paper? Did the author forget to include other information? Did you agree or disagree with the information pr..

Research children health issue focus on environmental factor : Research children's health issues, focusing on environmental factors and links to poverty. The assessment of environmental processes includes agents and factors that predispose communities and populations to injury, illness, and death.

Discuss the use of figurative language in the poem plum : Discuss the use of figurative language in the poem "Plum" (205) - Discuss how the AIDS epidemic is portrayed in the poem "Thinking about Bill. Dead of AIDS" (634).

Describe at least three special education services : Describe at least three special education services for students with impairments in sight and hearing;

Design an enhanced entity relationship diagram : Design an enhanced Entity-Relationship diagram for the grade book database and enter the design using a data-modeling tool such as ERWin.

Design an entity relationship diagram : Design an Entity-Relationship diagram for the auction database and enter the design using a data-modeling tool such as ERWin.

Calculate the firm marginal revenue and marginal cost : Calculate the firm's marginal revenue and marginal cost at every level of output. Is this firm operating in perfect competition? How do you know? Find the firm's maximum profit output and maximum profit price

Develop a thesis pertaining to the assigned film text : Writing an outline for a five paragraph analytical essay building on a clear and concise thesis statement, including topic sentences and secondary supports. Identifying and explaining three scenes from the film text in support of the thesis statem..

What are two main goals of federal aviation administration : What are two main goals of Federal Aviation Administration? Describe them. Who is current FAA Administrator? Tell me about him. According to the text, list and describe the six safety certificates issued by the FAA.

User Account

All Pages