Jim and Tim have been toying with a new prototype for a robot. It is a miniature robotic dog that can bark, roll over, come when called by name and learn other tricks. Some loyal customers have been part of the process and are already interested in making a purchase. Due to the envisioned popularity of this new robot, Jim and Tim will need to track its inventory. Since the design of this prototype is comprised of various materials, it would be best to keep this product in separate tables.
item_code ( pk.fk ) ( references inventory_items)
suplier_code (pk,fk )( references ...
This job proposes the design of a database.