Coursework for database design

Wine Zone Project Table of contents

: Page Abstract . 2

Global Domain .2

Statement of global User Requirements .3

View Integration .5

Entity Relationship Diagram .7

Physical Design .13

Sizing Analysis . 13

Volatility Analysis .15

Transaction Analysis . 15

Prototype 19

Prototype Structure Discussion (Menu Layout . 22

Main Screen of the Sales View Prototype .24

Appendix I (Tables Record Results from SQL . 35

Abstract

Database design is the process of transforming a logical data model into an actual physical database . After the logical data

model is complete though , what must be done to implement a physical database

This presents the global domain , statement of user requirements and the integration process carried out to merge the three views (Sales , Purchas and Stock . Then it covers the necessary physical design activities and its analysis before the prototype is designed for the chosen view , Sales view

Global Domain

Bela Pinga , Ltd is a growing company in the wine business industry . The aim of the company is to evolve in E-commerce solution and making full use of the database . However , as a started firm , it has a very limited resources and a small customer base . For example , there are two PC 's linked to run accounting package at the sales office and another PC at the purchase office . These computers have basic programs like word processing and spread sheet with an internet connection . Moreover , this business depends on writing things down as well as based procedures to do the...