Question
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
Get Instant Access to Expert-Tailored 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