Design an Entity-Relationship for each system described below. Use the (min,max) notation. State clearly any additional assumptions you make. Give the relational model by applying the mapping rules (WITH REFERENCES AND ARROWS).
- Design an Entity-Relationship for each system described below. Use the (min,max) notation. State clearly any additional assumptions you make.
- Give the relational model by applying the mapping rules (WITH REFERENCES AND ARROWS).
NOTE: USE CHEN ER DIAGRAM (YOU CAN USE VISIO MICROSOFT(TEMPLATE=CHEN) ONLY SHOWING THE ENTITIES/ATTRIBUTES/WEAK ENTITIES/RELATIONSHIPS/PRIMARY KEY-FK/ (MIN-MAX) NOTATIONS ALSO NOT FORGETTING THE REFERENCES ON THE MAPPING TABLES WITH ARROWS REFERRING THE FOREIGN KEYS. YOUR WORK SHOULD BE SPECIFIC WITH JUSTIFICATION.
We consider a library that contains books that can be borrowed. A book is characterized by a unique number, a title, an author and a publisher. In addition, we describe a book by a number of keywords that indicate the treated subjects. The library has one or more copies of each book; the copy is identified by a number and characterized by its position on the shelves and the date of purchase. A copy can be borrowed by a borrower. This latter is identified by a number of borrower and has a name and an address.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images