Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw a conceptual data model Photos.com sells prints of photographs. Attributes of the photographs are PhotoID, PhotoDescription, Photographer, and Cost. Attributes of customer are CustomerID,

Draw a conceptual data model

Photos.com sells prints of photographs. Attributes of the photographs are PhotoID, PhotoDescription, Photographer, and Cost. Attributes of customer are CustomerID, CustomerName (composed of FirstName, MiddleInitial, and LastName), CustomerAddress (composed of Street, City, State, and ZipCode), and EmailAddress. Customers can place one or more order. An order is placed by exactly one customer. Attributes of the order are OrderID and OrderDate. An order includes one or more photograph and a photograph can be included in more than one order (or in no orders). For each photograph in an order, the photograph size, frame type, and frame color are tracked.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

4. Devise an interview strategy from the interviewers point of view

Answered: 1 week ago