28 CHAPTER 2. THE RELATIONAL MODEL OF DATA acctNo type 12345savings 12000 23456c

Question

28 CHAPTER 2. THE RELATIONAL MODEL OF DATA acctNo type 12345savings 12000 23456checking 1000 34567savings25 balance The relation Accounts firstName lastName idNo account Robbie Lena Lena Banks Hand Hand 901-222 12345 805-33312345 805-33323456 The relation Customers Figure 2.6: Two relations of a banking database Studio This relation tells about movie studios. We rely on no two studios having the same name, and therefore use name as the key. The other attributes are the address of the studio and the certificate number for the president of the studio We assume that the studio president is surely a movie executive and therefore appears in MovieExec 2.2.9 Exercises for Section 2.2 Exercise 2.2.1: In Fig. 2.6 are instances of two relations that might constitute part of a banking database. Indicate the following: a) The attributes of each relation b) The tuples of each relation. c) The components of one tuple from each relation d) The relation schema for each relation e) The database schema. f) A suitable domain for each attribute g) Another equivalent way to present each relation

Explanation / Answer

1) Attributes of relation accounts

Attributes of relation customer

2) Tuples of relation accounts

Tuples of relation customer

3) Components of one tuple from relation accounts

Components of one tuple from relation customers

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.