a partial e r diagram for the registration system is shown below 252916

Required: 8 pts

a. A partial E-R diagram for the registration system is shown below. This diagram follows the REA conventions discussed in class. Complete the diagram as follows:

1. Fill in the names of the missing entities. 2. Show the cardinalities of the various relationships in the diagram. (Note: In the text we usually show the association between agents and events. In some situations, it may be more appropriate to represent the association between products/services and agents. In the registration system, professors are associated with courses rather than specific registration events.)

Course

Professor

b. Summarize the design of the tables in the registration system using the following format:

Table Primary Key Foreign Key Informational (other) attributes Student Professor Course Registration Registration_Detail

3

Attachments:

Related Articles

armstrong helmet company 239138

Armstrong Helmet Company manufactures a unique model of bicycle helmet Question Case project Learning Objectives: Prepare practical applications of course concepts Develop analytical and critical thinking Develop decision-making capabilities Enhance professional...

read more
GET A FREE QUOTE





  
Open chat
Need help? We are Online 24/7
Hello 👋
Can we help you?