Question: Make a logical Relational Schema (Mapping) for this given scenerio Assume your company is developing a generic digital camera online purchasing system that can be
Make a logical Relational Schema (Mapping) for this given scenerio
Assume your company is developing a generic digital camera online purchasing system that can be sold
to different camera stores. An initial analysis phase of the project has resulted in the following informal
description of relevant data for the system.
A store will be selling a variety of digital cameras and lenses. The digital cameras can have following
mutually exclusive optional features:
1. An ability to replace lenses.
2. Cameras with an electronic viewfinder.
3. Cameras with an optical viewfinder.
4. Cameras with an optical rangefinder.
Relevant properties of all cameras are the model number, retail price and the number currently in stock.
Properties of cameras without an ability to replace lenses that are relevant include a focal length range.
Cameras with an ability to replace lenses are related to at least two or more lenses.
Properties of a lens that are relevant include the model number, retail price and the number currently in
stock.
Online customers are either domestic customers or foreign customers. Properties of customers that are
relevant include a unique customer number, a customer name, an email address and a shipping address.
Each customer may have any number of purchase orders. Each purchase order is for only one unit of any
product at a time, either a camera or a lens, and will also have a selling price.
Step by Step Solution
3.45 Rating (148 Votes )
There are 3 Steps involved in it
solution here is the solution Camera modelnumber retailprice stock type Lens modelnumber ret... View full answer
Get step-by-step solutions from verified subject matter experts
