Explore BrainMass

Explore BrainMass

    Propose the design of a database

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    Propose the design of a database. Explain the role of each table in your proposed database and the relationships between the tables.

    © BrainMass Inc. brainmass.com March 4, 2021, 7:20 pm ad1c9bdddf

    Solution Preview

    1) Suppliers
    supplier_code (PK)

    2) item_Suppliers
    item_code ( pk.fk ) ( references inventory_items)
    suplier_code (pk,fk )( references ...

    Solution Summary

    This job proposes the design of a database.