Solution-A company makes use of a computerised flat file

A company makes use of a computerised flat file information

Assignment Help Database Management System

Reference no: EM13346793

A company makes use of a computerised flat file information retrieval and storage system. The company is experiencing problems due to the use of this flat file system and decides to convert to relational database systems. Currently, there are three files in use: customer, stock and orders. Examples from the three files are shown below. During conversion to a relational database system, these files could need to be normalised into relations. Normalise these files up to third normal form.

Please show your process. But there should be a clear section at the end just for your final relation schemas for the entire database.

Note: In the normalization process, the data should be carefully studied to figure out the functional dependencies. If something is unclear, DB designer should consult with the customer. For this assignment, think about the functional dependencies (FDs) based on keys. Do not make unreasonable assumptions about FDs. For example, City ->PostCode is an example of unreasonable assumption.

1056_Functional dependencies.png

2123_Functional dependencies1.png

Reference no: EM13346793

Questions Cloud

I describe the application that you would like to design : i. describe the application that you would like to design. this should include the purpose of the application and an

Case study 1 berts bonsai bbberts bonsai is a small company : case study 1 berts bonsai bbberts bonsai is a small company started by a retired plant scientist which sells bonsai

Define nosocomial infections explain the factors that might : define nosocomial infections. explain the factors that might influence whether a patient can acquire nosocomial

The so2 concentration in a stack is 400 ppm the stack : the so2 concentration in a stack is 400 ppm the stack diameter is 10 ft and the stack gas velocity is 50 ftsec. the gas

A company makes use of a computerised flat file information : a company makes use of a computerised flat file information retrieval and storage system. the company is experiencing

1 every convergent sequence contains either an increasing : 1 every convergent sequence contains either an increasing or a decreasing subsequence.?proof suppose that limas n goes

Dissect an email you have received first get the original : dissect an email you have received. first get the original ascii text of the email including the headers and the blank

Prepare worlddataapp project it implements the nameindex : prepare worlddataapp project. it implements the nameindex portion includingbull creating it implemented as a binary

The theory of the businessin a thought-provoking article in : the theory of the businessin a thought-provoking article in the septemberoctober 1994 edition of the harvard business

User Account

All Pages

A company makes use of a computerised flat file information

Reference no: EM13346793

Reference no: EM13346793

Questions Cloud

Reviews

Write a Review

Database Management System Questions & Answers

Knowledge and data warehousing

Design a database schema

Entity-relationship diagram

Implement a database of courses and students for a school

Prepare the e-r diagram for the movie database

Design relation schemas for the entire database

Prepare the relational schema for database

Data modeling and normalization

Use cases perform a requirements analysis for the case study

Knowledge and data warehousing

Stack and queue data structure

Practice on topic of normalization

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT