Purchase Solution

Data Normalisation

Not what you're looking for?

Ask Custom Question

1. In a car garage, how would you describe the relationship between vehicles and service, MOT or repairs. Is it one to many or many to many?

2. Same question for car parts and repairs.

3. How about repairs and accidents. Can one say it is a one to one relationship?

Purchase this Solution
Solution Summary

Types of Relationships among data items are explained.

Solution Preview

1. In a car garage, how would you describe the relationship between vehicles and service, MOT or repairs. Is it one to many or many to many?

One car may need many services
Many cars may need the same ...

Purchase this Solution
Free BrainMass Quizzes
Basic Networking Questions

This quiz consists of some basic networking questions.

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++ Operators

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

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.

Javscript Basics

Quiz on basics of javascript programming language.

View More Free Quizzes
Related BrainMass Solutions

  • NORMALISATION

    21897 NORMALISATION Transform the following entities into 3NF entities. Draw the original and final data models, and state any reasonable assumptions.

  • Bottom-up vs Top-down Database Design

    This method is characterised by normal forms, or de-composition using normalisation theory. Normalisation arranges relationships into appropriate forms using decompositions (Lewis et.al, 2001).

  • Sales Invoice Normalisation

    506097 Sales Invoice Normalisation Consider a typical sales invoice that would include the information below. Design a single table to hold all of the information required to store an invoice including this information.

  • Database Models

    Involves normalisation for arrangement Commonly used (e.g., MySQL, MS SQL, MS Access) Object-Oriented: Works with unstructured data (e.g., Photos, Audio, Video, PDF) Objects have Data & instructions Organise using Objects, classes,entities,attributes

  • Normalisation of Database Design

    It also shows the SQL statements constructed to manipulate data for reading, inserting, and updating purposes.

  • American Immigrant Experiences: Germans and Italians

    They were also responsible for much of the development and normalisation of leisure activities such as picnics, card games and bowling.

  • Managerial Education and Structure

    Also included are the collection, normalisation, and analysis of large volumes of critical data in a controlled environment.

  • Bivariate data: Correlation

    ______ a. the x, y data set b. the u, v data set c. the w, t data set d. the m, n data set e. none of the data sets Answer d the m, n data set 3.

  • Data Warehouse and Data Mart

    610675 Data Warehouse and Data Mart Please help me with at least 200 words discussing the differences between data warehouses and data marts. Also, discuss how organizations can use data warehouses and data marts to acquire data.

View More Related Solutions