Instr. teaches (0,m) Instructor (0,n) Section Semester |(0,n) Section C is offered in S (0,n) Student enrolls in Section (0,m) Student Grade (0,m) Course (0,n) Course belongs to Major (8,12) Major The picture above shows the Data Model (Entity Relationship Diagram) of a Student Information System. Please answer the following questions about this data model: Question 1: Why is the "Grade" attribute associated with the relationship type between Student and Section? What would happen if we associated it either with Section, or with Student instead? Please explain your reasoning (5 points) Question 2: How many majors can a given course belong to at most? (5 points)

Instr. teaches (0,m) Instructor (0,n) Section Semester |(0,n) Section C is offered in S (0,n) Student enrolls in Section (0,m) Student Grade (0,m) Course (0,n) Course belongs to Major (8,12) Major The picture above shows the Data Model (Entity Relationship Diagram) of a Student Information System. Please answer the following questions about this data model: Question 1: Why is the "Grade" attribute associated with the relationship type between Student and Section? What would happen if we associated it either with Section, or with Student instead? Please explain your reasoning (5 points) Question 2: How many majors can a given course belong to at most? (5 points)

Principles of Information Systems (MindTap Course List)

12th Edition

ISBN:9781285867168

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter5: Database Systems And Applications

Section: Chapter Questions

Problem 4PSE: Using a graphics program, develop an entity-relationship diagram for a database application for an...

See similar textbooks

Similar questions

Data modeling is most often accomplished through the use of a(n) __________________. a. entity-relationship diagram b. data-flow diagram c. functional decomposition diagram d. activity diagram
Data modelling is most often accomplished through the use of a(an) ________________. a. entity-relationship diagram b. data-flow diagram c. functional decomposition diagram d. activity diagram
A new sales ordering system needs a relational database that contains a customer table, a product inventory table, and an order table. Use a word-processing, graphics, or spread-sheet program to draw an entity-relationship diagram showing the relationships among these entities. Next, design each of these tables showing the keys and attributes to be included in each table. Include five sample records for each table.
For a business of your choice, use a graphics program to develop a data-flow diagram of one of its main processes and an entity-relationship diagram showing the data within the scope of the system.
What is the minimal data rule in conceptual design? Why is it important?
Suppose you are working within the framework of the conceptual model in Figure Q4.5. FIGURE Q4.5 THE CONCEPTUAL MODEL FOR QUESTION 5
The ______________ model is a simple but highly useful way to organize data into collections of two-dimensional tables called relations.
Discuss two ways in which the 1:M relationship between COURSE and CLASS can be implemented. (Hint: Think about relationship strength.)