How to use traditional database design method

Assignment Help Database Management System

Reference no: EM1372565

Describe how you would follow the three phases of the traditional database design method (Hierarchical, Network, and Relational), considering the following scenario. Feel free to make some assumptions and/or sample data to complete the process. Be sure to detail all your answers.

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. Now, he needs your help to complete the design.

Reference no: EM1372565

Questions Cloud

Determine the number of sells to break even and profit : The Last Outpost is a tourist stop in a western resort community. Kerry Yost, owner of shop, sells hand woven blankets for an average price of 30 dollar per blanket.

What are advantages and disadvantages to this model : Assume that HP is evaluating idea of placing a DC (Distribution Centre) in Europe. What are advantages and disadvantages to this model.

Determine aroma and taste ratings for coffee blend : What is minimum-cost blend that will meet quality standards and provide 1000 pounds of blended coffee product. What is cost per pound for coffee blend. Determine aroma and taste ratings for coffee blend.

Is the motion simple harmonic : The woman then starts walking clockwise around the rim at .75 rad/s. in what direction and with what angular speed does the turntable rotate.

How to use traditional database design method : Explain how you would follow three phases of traditional database design method (Hierarchical, Network, and Relational), considering the following scenario.

Find out the tensions in the rope : A stunt man whose mass is 70kg swings from the end of a 4.50m long rope along the arc of a vertical circle. Assume that he starts from rest when the rope is horizontal, find the tensions in the rope that are required to make him follow his circula..

What is average number of customers in drive through area : What is average length of "place order line". What is average length of "pick up line". What is average number of customers in drive through area.

Create incident response policy covers development-response : Policy to reduce network down-time if future incidents happen. Create incident response policy which covers development of incident response team, disaster recovery process and business continuity planning.

Compute the firms gain or loss at sale : The Weaver Watch firm sells watches for $25; fixed expenses are $140,000; and variable costs are $15 per watch.

User Account

All Pages