The Relational Model - Database Systems - page 52

• Cardinality

• Multiplicity

• Degree

Develop an illustrative data model to explain how these concepts
are related.

2. Give the formal definition of a relation. Explain the different

kinds of relations that may be found in a database.

3. Outline the steps to be observed in constructing a relational

database system.

4. What are the types of relationships that may exist among

information entities? For each, explain how it is identified,
and how it is implemented.

5. Think about a problem that requires a small database system

(requiring six to twelve entities or object types). Do the
following:

• Identity all required entities (object types).

• Identify relationships among the entities (object types).

• Develop an ERD or ORD.

• Propose a relation-attributes list (RAL) and a relationship list

(RL) to represent your model.

3.10 References and/or Recommended Readings
[Bruegge, 2002] Bruegge, Bernard and Allen H. Dutdt. Object-Oriented Software
Engineering: Conquering Complex and Changing Systems . Upper Saddle River, NJ:
Prentice Hall, 2002.
[Chen, 1994] Chen, Peter. “The Entity-Relationship Model - Toward a Unified View of
Data,” In Readings in Database Systems 2 nd ed., pages 741-754. San Francisco, CA: Morgan
Kaufmann, 1994.
[Chen, 2007] Chen, Peter. http://bit.csc.lsu.edu/~chen/display.htm l
[Connolly, 2002] Connolly, Thomas and Carolyn Begg. Database Systems: A Practical
Approach to Design, Implementation and Management 3 rd ed. New York: Addison-Wesley,
2002. See chapters 3 and 11.
[Date, 2004] Date, Christopher J. Introduction to Database Systems 8 th ed. Menlo Park,
California: Addison-Wesley, 2004. See chapters 3 and 6.
[Edward, 1992] Edward, David . Information Modeling: Specification and Implementation .
Eaglewood Cliffs, NJ: Prentice Hall, 1992. See chapters 2-4.
[Elmasri, 2007] Elmasri, Ramez and Shamkanf B. Navathe. Fundamentals of Database
Systems 5 th ed. Reading, Massachusetts: Addison-Wesley, 2007. See chapters 3 and 7.