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
Update Operations and Dealing with Constraint Violations There are three basic operations to be executes on relations: Insertion Deletion Update The INSER

Question 1 Discuss about second normal form and third normal form Question 2 Write short note on                        1) Data Manipulation Language 2) Data Definition La

Differentiate OO development from structured development. Structured approach of problem solving is based upon the idea of decomposition of system into subsystem. In this appro

What are stand-alone procedures? Procedures that are not part of a package are called as stand-alone because they independently defined. A good example of a stand-alone procedu

Removing a Synonym: DROP SYNONYM D30;

Describe substring comparison in SQL. For the relation Person (name, address), write a SQL query that retrieves the names of people whose name starts along with ‘A' and address co

draw er diagram using entities crop,employee,department,plot,cultivation plan,machinery,seed,fertilizer

Question 1 Suppose the employee employee id, name, designation, salary, attendance and address of any employee has to be stored in a database. You can store these data in a sequen

Eliminate Columns Not Dependent On Key The Employee Relation satisfies - First normal form - As it has no repeating groups. Second normal form - As it do not have multi-a

Explain the Check Clause The CHECK clause is employed to at the end of a CREATE TABLE statement specify table constraints. This is known as table-based constraint because it ap