Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
Suppose that Heather Sweeney wants to include records of her consulting services in her database. Extend the data model in Figure 4-27(c) (shown below) to
Suppose that Heather Sweeney wants to include records of her consulting services in her database. Extend the data model in Figure 4-27(c) (shown below) to include CONSULTING_PROJECT and DAILY_PROJECT_HOURS entities. CONSULTING_PROJECT contains data about a particular project for one of Heather's customers. 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 diagram. SEMINAR CUSTOMER CustomeriD ContactNumber ContactType LINE ITEM PRODUCT ImoiceNumber InvoiceNumber InvoiceDate PaymentType Subtotal Shipping LineNumber ProductNumber Tax ProductType Total
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started