Week2Tutorial - ERD. 7. Using Figure P2.7 as your guide,...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
ITC-423/114 WEEK (2) TUTORIAL 1. Discuss the importance of data modeling. 2. Describe the basic features of the relational data model, and discuss their importance to the end user and the designer. 3. Explain how the entity relationship (ER) model helped produce a more structured relational database design environment. 4. What are the differences between an object and a class in the object oriented data model (OODM)? 5. What is a relationship, and what three types of relationships exist? 6. Use the contents of Figure 2.4 to work the problems below. Figure 2.4 is reproduced below: FIGURE 2.4 Linking Relational Tables i) Write the relationship statement that governs the relationship between AGENT and CUSTOMER. ii) Given the relationship you wrote in Problem 1, create the basic Chen ERD. Make sure that you identify the connectivities. Database name: Ch02_InsureCo Table name: AGENT (first six attributes) Table name: CUSTOMER Link through AGENT_CODE
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
iii) Given the relationship you wrote in Problem 1, create the basic Crow’s Foot
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ERD. 7. Using Figure P2.7 as your guide, work Problems 1-3. The DealCo relational schema shows the initial entities and attributes for the DealCo stores, located in two regions of the country. Figure P2.7 The DealCo Relational Schema 1. Identify each relationship type and write all the relationships. 2. Draw the basic Chen ERD that corresponds to the relational schema. 3. Convert the Chen ERD you created in Problem 2 to the basic Crow’s Foot ERD. 8.. Using Figure P2.10 as your guide, work Problems 10-14. The Tiny College relational schema shows the initial entities and attributes for the Tiny College university. Figure P2.10 The Tiny College Relational Schema i) Identify each relationship type and write all the relationships. ii) Draw the basic Chen ERD that corresponds to the relational schema. iii) Convert the Chen ERD you created in problem ii to the basic Crow’s Foot ERD....
View Full Document

This note was uploaded on 01/13/2012 for the course ITC 114 taught by Professor Ray during the Three '11 term at Charles Sturt University.

Page1 / 2

Week2Tutorial - ERD. 7. Using Figure P2.7 as your guide,...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online