Q1) LIBRARY INFORMATION SYSTEM
Draw an ER diagram for a university library information system which stores information about books, journals, publishers, students, staff, borrowing of books, and reservation of books. Note that the library may have more than one copy for some of the books. You may add entities.
Q2) A database is being constructed to keep track of the teams and games of a sports league. A team has a number of players, not all of whom participate in each game.
Copyright By PowCoder代写 加微信 powcoder
It is desired to keep track of the players participating in each game for each team, the positions they played in that game, and the result of the game. Try to design an ER schema diagram for this application, stating any assumptions you make. Choose your favorite sport (soccer, football, baseball …).
Q3) Identify all the important concepts represented in the library database case study described here. In particular, identify the abstraction of classification (entity types and relationship types), aggregation, identification, and specialization/generalization. Specify (min, max) cardinality constraints whenever possible. Draw an EER diagram of the library database.
程序代写 CS代考 加微信: powcoder QQ: 1823890830 Email: powcoder@163.com