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
    https://brainmass.com/computer-science/memory-management/propose-the-design-of-a-database-94967

    Solution Preview

    1) Suppliers
    _____________
    supplier_code (PK)
    supplier_name
    supplier_address
    supplier_email
    supplier_phone
    other_supplier_details

    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.

    $2.49

    ADVERTISEMENT