Purchase Solution

Database Design for Fernando

Not what you're looking for?

Ask Custom Question

Fernando Culebra has always been fascinated by skateboards. Fernando has won several contests, both locally and nationally. His interest in skateboards led him to open Fernando's Skate Shop in Denton, Maine. Fernando sells street, trick, and children's skateboards. The store has only been open for a couple of months, yet sales have been very high. Recently, Fernando has come to realize that he will need some help to manage the information his business is creating. He has contacted you to help him design a database.

After meeting with Fernando, you have learned that he purchases the skateboards he sells from three suppliers, but he plans to add new suppliers in the near future. Fernando has realistic expectations that his business will continue to grow, and soon, he will be unable to manage the information on suppliers and products. He realizes the database will need to contain two tables: a supplier table and a product table. He also knows that there will be have to be a relationship between the two tables.

Fernando Culebra, owner of Fernando's Skate Shop, still needs your help. Apply what you have learned about the steps of the design process to help Fernando get started in the design of his new database. Complete steps 1 and 2 of the design process by creating a database mission statement and database mission objectives. Then, think of at least five questions you would ask Fernando and at least five questions you would ask his sister, Carlita, who works as a clerk in the shop.

Here is more background information about the business:

While at the store, you observe a transaction in which a customer buys a skateboard. Carlita takes the skateboard and, on an index card, writes down the skateboard model, supplier, and price. Then, she calculates the tax on the cash register and provides the customer with a receipt upon payment.
Carlita then asks the customer if they would like to be added to a mailing list for local skateboarding events and issues. If they agree, the customer information is hand-written on an index card. Fernando then tells you that part of why he thinks his business is so successful is the active participation of the skateboarding community at events he sets up and puts on his mailing list.

Prepare your mission statement, mission objectives, and questions.

Purchase this Solution

Solution Preview

Please note that there are THREE TABS within the attached (solution) spreadsheet that includes:

(1) ...

Purchase this Solution


Free BrainMass Quizzes
Javscript Basics

Quiz on basics of javascript programming language.

Basic Networking Questions

This quiz consists of some basic networking questions.

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.

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.

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.