Question: Relational database question, please answer all parts Exercise 3 (total 25 pts): Given the Tiny Collage conceptual model shown below, briefly answer the following questions.
Relational database question, please answer all parts
Exercise 3 (total 25 pts): Given the Tiny Collage conceptual model shown below, briefly answer the following questions. Recall that a class is a specific instance of a course for a given term and year. STUDENT ENROLL + enrolls in is taken by # CLASS PROFESSOR ROOM used for teaches, generates COURSE 1. (2 pts) What kids of a model is it? 2. (3 pts) Give a list of all the entities and relations. Give the multiplicities (the relation types). 3. (10 pts) Convert this model into a UML class diagram. 4. (5 pts) Explain the use of the entity ENROLL? Can you give some important attributes you might put in this entity? 5. (2 pts) Give three possible business rule for this model. 6. (3 pts) Give one possible business rule that needs to be enforced by the application software
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
