chapter 4 in-class exercises

chapter 4 in-class exercises - CGS 2545: Database Concepts...

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

View Full Document Right Arrow Icon
CGS2545: Database Concepts (Chapter 4 Exercises) Page 1 © Mark Llewellyn CGS 2545: Database Concepts Spring 2010 Chapter 4 – In Class Exercises School of Electrical Engineering and Computer Science University of Central Florida Instructor : Dr. Mark Llewellyn markl@cs.ucf.edu HEC 236, 407-823-2790 http://www.cs.ucf.edu/courses/cgs2545/spr2010
Background image of page 1

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

View Full DocumentRight Arrow Icon
CGS2545: Database Concepts (Chapter 4 Exercises) Page 2 © Mark Llewellyn Problem #1 Add a subtype discriminator for each of the supertypes shown in the ERD.
Background image of page 2
CGS2545: Database Concepts (Chapter 4 Exercises) Page 3 © Mark Llewellyn Solution to Problem #1
Background image of page 3

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

View Full DocumentRight Arrow Icon
CGS2545: Database Concepts (Chapter 4 Exercises) Page 4 © Mark Llewellyn Construct an ERD for the following scenario: A nonprofit organization depends on a number of different types of persons for its successful operation. The organization is interested in the following attributes for all of these persons: SSN, Name, Address, City/State/Zip, and Telephone. Three
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 13

chapter 4 in-class exercises - CGS 2545: Database Concepts...

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

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