chapter 3 in-class exercises

chapter 3 in-class exercises - COP 4710: Database Systems...

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

View Full Document Right Arrow Icon
COP 4710: Database Systems (Chapter 3) Page 1 © Mark Llewellyn COP 4710: Database Systems Fall 2007 Chapter 3 – In Class Exercises School of Electrical Engineering and Computer Science University of Central Florida Instructor : Dr. Mark Llewellyn [email protected] HEC 236, 823-2790 http://www.cs.ucf.edu/courses/cop4710/fall2007
Background image of page 1

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

View Full DocumentRight Arrow Icon
COP 4710: Database Systems (Chapter 3) Page 2 © Mark Llewellyn • Transform each of the ER diagrams shown on this and the following few pages, into a set of relational schemas which show referential integrity constraints. Introduction Problem #1
Background image of page 2
COP 4710: Database Systems (Chapter 3) Page 3 © Mark Llewellyn Solution for Problem #1 Employee_ID Employee_Name Address Date_Employed Employee_ID Skill EMPLOYEE SKILL EMPLOYEE Multi-valued attribute is contained in a separate table. Derived attribute is “replaced” with the attribute actually maintained in the database. Transformation technique is not indicated at this level.
Background image of page 3

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

View Full DocumentRight Arrow Icon
COP 4710: Database Systems (Chapter 3) Page 4 © Mark Llewellyn Problem #2
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.

This note was uploaded on 02/22/2009 for the course COP 4710 taught by Professor Dr. mark llewellyn during the Fall '07 term at University of Central Florida.

Page1 / 17

chapter 3 in-class exercises - COP 4710: Database Systems...

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