Purchase Solution

Identification of dependencies in a database table

Not what you're looking for?

Ask Custom Question

See the attached file.
The following business rules form the basis of the database design.

· A member receives many invitations, and each invitation is sent to many members.

· An invitation may be sent to different members on different dates. The date a member accepts an invitation is recorded.

· Each invitation includes a dinner of a type, and a dinner type may apply to many invitations.

· A dinner is based on a single entrée, but an entrée may be used as the basis for many dinners. For example, a dinner may be composed of a fish entrée, rice, tossed salad, and mixed vegetables. Or the dinner may be composed of a fish entrée, baked potato, vegetable soup, corn, and string beans.

The following table gives the attributes and sample values.

MEMBER NUM MEMBER NAME EMAIL ADDR INVITE NUM INVITE DATE
214 Alice Hanz ah@com 8 2/23/04

ACCEPT DATE DINNER CODE DINNER DESCRIPTION ENTREE CODE
2/27/04 D5 sea delight E3

ENTREE DESCRIPTION
Stuffed crab

The attached file shows the table.

Attachments
Purchase this Solution
Solution Summary

Identification of dependencies in a database table in order to normalize the database is provided.

Solution Preview

PRIMARY KEY

Any single attribute in the table does not satisfy the unique identification of a row condition of a primary key because of the rules outlined in the problem. Therefore a ...

Purchase this Solution
Free BrainMass Quizzes
Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

Word 2010: Table of Contents

Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.

C++ Operators

This quiz tests a student's knowledge about C++ operators.

Javscript Basics

Quiz on basics of javascript programming language.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Dependency Diagrams

    Create a database whose tables are at least in 2NF, showing the dependency diagrams for each table. c. Create a database whose tables are at least in 3NF, showing the dependency diagrams for each table. 2.

  • functional dependencies

    The following exercises are based on the Premiere Products database. Using your knowledge of Premiere Products, determine the functional dependencies that exist in the following table.

  • MS Access database

    This posting contains creation of database tables along with functional dependencies.

  • database concept

    How can the size of a DBMS be one of its disadvantage? 9. Why can a failure in a database environment be more serious than one in a file environment? 10. What is a relational database ? 11.

  • Dependency / Multivalued dependency

    The superkey of this table consists of COURSE, STUDENT, INSTRUCTOR, SEMESTER.

  • Database Concept

    A normalized database prevents such insertion anomalies by ensuring that database relations mirror functional dependencies. - Similarly, such dependencies in non-normalized databases can hinder deletion.

  • redundancy in a database

    Eliminating inconsistent, data dependencies involves ensuring that data is housed in the appropriate Access database table. An appropriate table is a table in which the data has some relation to or dependence on the table.

  • Drawing a Dependence Diagram

    There are examples in the reading assignments of dependence diagrams. In what normal form is this table? Explain why. Decompose the table into a set of 3NF tables. Describe the process to decompose the table.

  • Bottom-up vs Top-down Database Design

    Codd is a generalisation of the key dependencies in E-R approach, whereas join dependencies do not show an E-R counterpart. This method is characterised by normal forms, or de-composition using normalisation theory.

View More Related Solutions