Purchase Solution

Propose the design of a database

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution
Solution Summary

This job proposes the design of a database.

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 ...

Purchase this Solution
Free BrainMass Quizzes
Basic Computer Terms

We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Word 2010: Tables

Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

View More Free Quizzes
Related BrainMass Solutions

  • Instructional Design and Performance Management

    Let's take a review into the core areas of focus on instructional design: - Explain the purpose of training objectives.

  • Database design process

    Finally, a physical design of the database is produced to implement the database. Outcome: The outcome is a collection of information that is organized so that it can be easily accessed, managed, and updated.

  • Database, table and query design affect database performance

    Database Design: Design database properly, i.e. a normalized database design is usually a good starting point. This depends on the purpose database being used. If this is used for OLTP purpose database has to follow normalized design.

  • Why do databases need redesigning?

    Database Processing - Fundamentals, Design, and Implementation by David M. Kroenke's (10th Edition) 2. My Own experience of working on database. Database design is the process of producing a detailed data model of a database.

  • Survey Responses - Intrinsic Job Satisfaction

    Propose a hypotheses test for the mean intrinsic job satisfaction. a. State the null hypotheses, the alternative hypotheses, and the significance level. b. Using the data in our database, calculate the test statistic. c.

  • design a database

    277469 Design a database Details: Using the same organization you selected in the unit one individual project complete the following. One of the needs of your client is a database.

  • Database Concept and Skipping Documentation and Design Procedure

    As a manager, how do you ensure that the proper database design procedures are followed by database development teams? "What is the main reason(s) that make many developers skip over the documentation and proper design procedures?"

  • To what extent should end users be involved in the selection

    438587 To what extent should end users be involved in the selection of a database management system and database design? To what extent should end users be involved in the selection of a database management system and database design?

  • Two Primary Steps to Database Design

    We discussed the importance of having representatives from all key stakeholders in the conceptual design to ensure the accuracy of the design. We analyzed who should facilitate the conceptual design and create the ER diagram.

View More Related Solutions