Database Modeling and Design - Database Systems - page 113

2. The following are three software systems for which a database

is to be designed:

· An Inventory Management System

· A Lab Scheduling System for users of a computer lab

· A Bookshop Manager System for an educational institution

For each system, develop a database specification based
on at least three of the five approaches above. Compare the
database specifications derived. Compare the methodologies.
Which one(s) are you most comfortable with and why?

3. How important are surrogates in the design of a database?

By considering an appropriate example, demonstrate how
surrogates may be used in database design.

4. Compare the UML database model with the E-R model. What

are the similarities? What are the differences? You may use
appropriate illustrations in your response.

5.13 References and/or Recommended Readings
[Connolly, 2002] Connolly, Thomas and Carolyn Begg. Database Systems: A Practical
Approach to Design, Implementation and Management 3 rd ed. New York, NY:
Addison-Wesley, 2002. See chapters 13-15.
[Date, 1986] Date, Christopher J. Relational Database: Selected Writings . Reading, MA:
Addison-Wesley, 1986.
[Date, 1990] Date, Christopher J. Introduction to Database Systems 5 h ed. Menlo Park, CA:
Addison-Wesley, 1990. See chapter 22.
[Date, 2004] Date, Christopher J. Introduction to Database Systems 8 h ed. Menlo Park, CA:
Addison-Wesley, 2004. See chapters 12-14.
[Elmasri, 2007] Elmasri, Ramez and Shamkant B. Navathe. Fundamentals of Database
Systems 5 th ed. Reading, MA: Addison-Wesley, 2007. See chapters 7, 10 and 11.
[Garcia-Molina, 2002] Garcia-Molina, Hector, Jeffrey Ullman and Jennifer Widom.
Database Systems: The Complete Book . Upper Saddle River, NJ: Prentice Hall, 2002.
See chapter 3.
[Hoffer, 2007] Hoffer, Jeffrey A., Mary B. Prescott and Fred R. McFadden. Modern
Database Management 8 th ed. Upper Saddle River, NJ: Prentice Hall, 2007. See chapters 5.
[Jensen, 1992] Jensen, C. S. and L. Mark. “Queries on Change in Extended Relational
Model.” IEEE Transactions on Knowledge and Data Engineering Vol. 4 Issue 2 , April 1992.
pp. 192-200.
[Kifer, 2005] Kifer, Michael, Arthur Bernstein and Philip M. Lewis. Database Systems: An
Application-Oriented Approach 2 nd ed. New York: Addison-Wesley, 2005. See chapter 4.