Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Each manufacturer manufactures many disk-drives, and the manufacturer assigns each disk-drive a serial number. The serial number is unique within a manufacturer, but not across
Each manufacturer manufactures many disk-drives, and the manufacturer assigns each disk-drive a serial number. The serial number is unique within a manufacturer, but not across all other manufacturers. The manufacturer registers the model of the disk-drive it produces to the intellectual property Office of Singapore (IPOS) so that the model of the disk drive is protected and cannot be used by other manufacturer. The disk-drives are manufactured by batch, and all the disk-drives manufactured in a batch are of the same model, and all the disk- drives of the same model have the same capacity. A distributor collaborates with many manufacturers to help the manufacturers to distribute the disk-drives the distributor receives to retailers. A distributor creates a relational table DISK_DRIVE to store the information/attributes of the disk drive it distributes to retailers as follows: DISK_DRIVE(serialNum, manufacturer, model, batch, capacity, retailer)
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