Purchase Solution

database design for RoboBoys

Not what you're looking for?

Ask Custom Question

Scenario:
Jim and Tim are brothers who have a love of robots. They started a home based business called 'RoboBoys' where they custom build robots for fun, gifts, competition and decoration. Both men hold degrees in engineering and started doing this in their garage a year ago to escape the boredom of winter. Little did they know that their pet project was going to turn into an international success. For a school project six months ago, Jim's daughter Jill created a small website that contained photos of their robots and an email address for anyone with questions. People only had one question, "When can I get one?" The people who then became customers wanted their robots personalized with their name, special colors or sayings. Before they knew it, the brothers had to quit their engineering job to keep up with orders. They started using a spreadsheet to track information, but now, their customer list is getting too long. The details of the invoices, shipping and custom requests needed to be tracked in a 'sortable' fashion so that it can be kept current for the customer, the government and their own sanity. You've been hired by Jim and Tim to advise them on possible solutions and implement the solutions they choose. You're leaning toward a relational database management system (RDBMS).

Individual Portion:
Prepare a set of PowerPoint slides explaining the following.

Table structure and fields
Primary keys and data/entity relationships
Business rules
Logical and physical models

Purchase this Solution

Solution Summary

A database design for RoboBoys is shown.

Purchase this Solution


Free BrainMass Quizzes
Inserting and deleting in a linked list

This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.

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.

Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Basic Networking Questions

This quiz consists of some basic networking questions.

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.