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
What are the uses of ODBC? Under what circumstances we use this technology? ODBC expose database capabilities within a standardized way to the application programmer by an ap

Critically evaluate the bulleted list of information-related items in this case study. How are each contradictory to the notion of being an information-literate knowledge worker?

Define the Wait for graph Ans: The wait-for-graph is a directed graph and consist of nodes and directed arcs; the nodes of the graph are active transactions. An arc of the grap

An entity set that does not have sufficient attributes to form a primary key is called? An entity set that doesn't have sufficient attribute to form a primary key is known as w

Consider the relation PERSON. If you want to display details of persons having age less than or equal to 30 than the select operation will be used as follows: σ AGE The resu

The following variant of the primary copy asynchronous-update replication protocol has been proposed for totally replicated systems. (a)  A transaction executing at site A updat

What is meant by log-based recovery? The most widely used structures for recording database changes is the log. The log is a sequence of log records, recording all the update a

What is an Operand? The data on which the operation is to be performed is known as an Operand

what characterizes the levels in RAID technology

Define the basic operations of the relational algebra?     Ans: Basic operators of relational algebra are: 1. Union (∪) - Selects tuples which are in either P or Q or in bot