Data Modelling: The Wood from the Trees

Synopsis

Forest Products Ltd, a small distribution company based at Liverpool Docks, has set up a database management system to help keep track of timber imports and distribution. Follows the way the external consultant first analysed the company’s requirements and then developed a conceptual data model which he later used in the implementation of the system. Key entities and their relationships are shown in an entity-relationship diagram. Shows how problems such as many-many relationships were resolved, and touches upon the way the the moedel was affected by the consultant’s knowledge of the particular database management system he knew that he would be using.

Series

Data Models and Databases, Course M357

Language

English

Country

Great Britain

Medium

Video; Videocassette. Standard formats. col. 25 min.

Year of production

1990

Availability

OUT OF DISTRIBUTION

Subjects

Information technology

Keywords

computers; database management; mathematical modelling; relational databases

Credits

Producer

Pip Surgey

Production Company

Name

BBC Open University Productions

Distributor

Name

Open University Worldwide

Web

http://www.ouw.co.uk External site opens in new window

Phone

+44 (0) 1908 274066

Address

Walton Hall
Milton Keynes
MK7 6AA

Notes

NB. As of May 2016 Open University Worldwide are no longer distributing DVDs. They have posted this message on their website: ‘Unfortunately Open University Worldwide Limited has decided that product sales are no longer viable given the reduced funding to Higher Education institutions and diminishing demand for the products we have traditionally stocked. At present the Open University Students Association (OUSA) will continue to sell the "Good Study Guide", and we are in discussion with other possible distributors to continue to make The Open University’s products available for purchase. As soon as we have any information on other channels of distribution we will update this notice’. Some products are still available via second hand dealers on Amazon.co.uk