The Relational Model and Data Normalization
Not what you're looking for?
1. Define functional dependency and give an example.
2. What are insertion and deletions anomalies?
3. List and briefly describe first, second and third normal form.
4. Describe a one-to-one relationship.
5. Describe the many-to-many attribute relationship.
Purchase this Solution
Solution Summary
The Relational Model and Data Normalization points are highlighted.
Solution Preview
Question 1.
A functional dependency is a relationship between or among attributes. If we are given the value of one attribute, we can obtain the value of another attribute. For example, if we know the social security number of a student, we can look up the student's name. Student Name is therefore functionally dependent on their social security number. In general terms, attribute A is functionally dependent on attribute B if the value of B determines the value of A: if we know the value of A, we can obtain the value of B.
Question 2.
A deletion anomaly is when, by deleting the facts about one entity, we inadvertently delete facts about another entity; with one deletion, we lose facts ...
Purchase this Solution
Free BrainMass Quizzes
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
C# variables and classes
This quiz contains questions about C# classes and variables.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
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.