Determine set of minimal functional dependency-normalization, Database Management System

1. Determine the set of minimal functional dependencies for the following data.

The local bakery, Happy Cakes, needs your help designing a database that will support a kiosk in the store for customers tomake special orders.  Orders are limited to cakes and cannot include cookies, pies, or pastries.  Several flavors each of cake and frosting are available, and they can be made in a number of different sizes and shapes.  Combinations of cake and frosting flavors are considered cake styles, and there will be a photograph of each style.  All photographs will be taken with one piece cut from the cake, in order to make the interior visible.All cakes can be customized with decorations and messages (one type of decoration and one message per cake) which have a main color as requested by the customer.  Each order will include customer and cake information as well as the date that the customer needs the cake.

Data:

cakeFlavor: the flavor of the cake
frostingFlavor: the flavor of the frosting
style: one of the typical combinations of cake and frosting flavors
picture: the filename of the picture of the cake style
shape: the shape of the cake
size: the size of the cake (diameter for rounds, length-by-width for rectangles)
layers: the number of layers
decoration: the type of decorations on the cake
color: the main color of the cake's decorations
message: the message that will be written across the finished cake |
orderNumber: the identification number for an order
orderDate: the date that the cake is needed
customerName: the customer's name (only one customer allowed per order)

Posted Date: 3/29/2013 2:12:59 AM | Location : United States







Related Discussions:- Determine set of minimal functional dependency-normalization, Assignment Help, Ask Question on Determine set of minimal functional dependency-normalization, Get Answer, Expert's Help, Determine set of minimal functional dependency-normalization Discussions

Write discussion on Determine set of minimal functional dependency-normalization
Your posts are moderated
Related Questions
Product adder required for Ecommerce website Project Description: Want a product adder for 500 products I have a magento website and need products pulled from site A to my si

The Structured Query Language INTRODUCTION Database is an organised set of information about an entity having controlled redundancy and serves numerous applications. DBMS

Control as a State Machine Engine First let us define the state machine: "the state machine is a machine which is an object but not an application object. It is a part of lang

What is persistency? Persistency ensures which data is stored and that after the object is no longer available (program stops running) the data will be available to other users

Replicating Data One approach that may support efficient access to dissimilar applications as above may be to give access to every of the applications from dissimilar replicate

Have a look around the site, and at some of the sites they have featured. These are all examples of bad design, and also offer an explanation about why they fall into this category

What is the difference between internal tables and extract datasets? The lines of an internal table always have the similar structure. By using extract datasets, you can ha

What is recursive closure? Why is it not possible to describe this operation in relational algebra? Recursive closure is applied to recursive relationship. An instance of rec

Problem : AirwaysCentre, an international airline booking company currently uses a relational database system for their operations, which includes the following relations: P

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4