home / study / questions and answers / engineering / computer science / the text

Question

home / study / questions and answers / engineering / computer science / the textbook identifies 8 characteristics of a ...

Question

The textbook identifies 8 characteristics of a table that make it a relation. The following table is a relation (Figure 2-a):

ISBN

Title

Publisher

Copyright

0-671-66398-4

Seven Habits of Highly Effective People

Fireside

1994

0-8109-8052-5

The Art of Walt Disney

Abradale

1986

0-9616878-6-X

Classics, US Aircraft of World War II

Howell Press

1987

0-87477-888-3

Seven Years in Tibet

Tarcher /Putman

1997

1. What is the entity being described in the table above?

< Your answer here>

2. Copy 1 attribute or field from Figure 2-a above

(Paste your table here)

3. Copy 1 tuple or record from Figure 2-a above.

(Paste your table here)

4. Copy and modify 1 record of Figure 2-a so it violates the relation rule Rows contain data about an entity. Highlight the modification and describe it.

(Paste your table here)

< Your answer here>

5. Copy and modify Figure 2-a so it violates the relation rule Columns contain data about attributes of the entity. Highlight the modification and describe it.

(Paste your table here)

< Your answer here>

6. Copy and modify Figure 2-a so it violates the relation rule Each column has a unique name. Highlight the modification and describe it.

(Paste your table here)

< Your answer here>

7. Write Figure 2-a in Relation Structure, the format:
TABLE_NAME(Primary_Key_Field, Field2, Field3, etc.)

< Your answer here>

8. Choose a composite candidate key for this entity and rewrite the relation structure so the table uses that candidate key as the primary key. Choose a candidate key that would have unique values for this type of entity.

< Your answer here>

9. Create a relation structure for a Category entity. Include the category description and the location in a store. Add a surrogate key.

< Your answer here>

10. Rewrite the relation structures for questions 7 and 9 and include the foreign key (italics):
TABLE_NAME(Primary_Key_Field, Field2, Field3, etc., Foreign_Key_Field)
Remember that multiple books may be in one category, but for our example, each book will belong to only 1 category.

< Your answer here>

11. Create the 2 tables from question 10 and populate the tables with data. You may copy the data from Figure 2-a for existing fields. For category data, use the descriptions: Art, Self Help, and History only. For the location, use either Front or Back. All books within a category will be found in the same location in the store. Therefore, you will not find art books in the front and the back of the store. Eliminate data duplication as much as you can.

Then, describe how the data in the 2 tables are related.

(Your first table here)

(Your second table here)

< How are the tables related?>

ISBN

Title

Publisher

Copyright

0-671-66398-4

Seven Habits of Highly Effective People

Fireside

1994

0-8109-8052-5

The Art of Walt Disney

Abradale

1986

0-9616878-6-X

Classics, US Aircraft of World War II

Howell Press

1987

0-87477-888-3

Seven Years in Tibet

Tarcher /Putman

1997

Explanation / Answer

Ans:

1. A book

2.Title

3. Seven Years in Tibet

4.Change publisher of Seven Years of Tibet to "@(*@#@#@*#@TN INJHJ@B#*&J "

5. Add a column and add random data

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

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