Suppose that Heather Sweeney wants to include records of her consulting ser- vices in her database. Extend

Question:

Suppose that Heather Sweeney wants to include records of her consulting ser- vices in her database. Extend the data model in Figure 4-20

(c) to include CONSULTING PROJECT and DAILY PROJECT HOURS entities. CONSULTING PROJECT contains data about a particular project for one of Heather's customers, and DAILY PROJECT HOURS contains data about the hours spent and a description of the work accomplished on a particular day for a particular project. Use strong and/or weak entities, as appropriate. Specify minimum and maximum cardinalities. Use the IE Crow's Foot E-R model for your E-R diagrams.

AppendixLO1

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Database Concepts

ISBN: 9780133544886

6th Edition

Authors: David M Kroenke, David J Auer

Question Posted: