hw02.366 - . . Winter 2008 CPE/CSC 366: Database Modeling,...

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

View Full Document Right Arrow Icon
. Winter 2008 CPE/CSC 366: Database Modeling, Design and Implementation Alexander Dekhtyar . . Homework 2 Due date: Thursday, Feb 7, in class. Problem 1 Exercise 4.5.4.a, (A First Course, 3d Ed., p. 164. 2nd Ed: 3.2.4.a pp 75-76.) Problem 2 Exercise 4.5.2.a, (A First Course, 3d Ed., p. 163-164. 2nd Ed: 3.2.2.a, p. 75.) Problem 3 Exersise 4.6.2., (A First Course, 3d Ed., p. 171. 2nd Ed.: 3.3.2, pages 81–82.) Problem 4 Consider the Entity-Relationship diagram describing the oper- ations of a software company (Figure 1). Let the entity sets in the diagram have the following attributes: Projects(Id , CodeName, StartDate, EndDate, Budget); Developers(SSN ,Name, StartDate, Position, Salary); Languages(Id , Name, Type); Platforms(Id , Hardware, OS); 1. Convert the E-R diagram into the relational model. Describe all rela- tions, their attributes and keys. Problem 5 The E-R diagram in Figure represents a simple music industry database. The following a brief descriptions of the entity and relationship sets involved:
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/19/2008 for the course CSC 365 taught by Professor Dekhtyar during the Spring '08 term at Cal Poly.

Page1 / 5

hw02.366 - . . Winter 2008 CPE/CSC 366: Database Modeling,...

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