Project manager

Knowlegde with elementary database basics know-how   1. Relational Data Structure

2. Operational Data

3. Domains and attributes

4. Integrity rules normalisation

Translate Project facts into  

tables and relations

ajavermijs@xs4all.nl

         Table column           : 1:1 related attributes

         Table identification   :       primary key  

         Relation                  :       foreign key

Start Determinist Reason Example Address

 MyShop Facts

 MyShop User Interface

BuySell

Date

SupplierCustomer

Article(1-n)

OperatorSupplierCustomer

Name

Customers

Article

Name

BuySell

BuyPrice

SellPrice

MyShop INPUT

MyShop Views

Suppliers

Stock

Vat

Invoices

MyShop DataBase

RDBMS

OOP

Programms

MyShop Database

Name

BuySell

BuyPrice

SellPrice


Primary Key

A_Id


Foreign Key

OSC_Id




 

Amount







Primary Key

Foreign Key BS_Id  

+

Foreign Key A_Id


NAW

OperatorSupplierCustomer


Primary Key

OSC_Id

(3)

Nummer

BuySell

Date

 Primary Key  BS_Id     


Foreign Key

OSC_Id


ABSA (1-N)

 OSCA (N-1)

BSBSA (N-1)

OSCBS (1-N)

Article

BuySell

BuySellArticle

BuySell

Number

Amount(1-n)

OperatorSupplierCustomer

NAW


Edifact

MyShop legend:  abbreviations by nouns begin characters in capital


Identification:Table Identifier, Primary Key:(X_Id),  Relation Identifier: Foreign Key (X_Id)                                                                                                                  

Tables:         1.   OperatorSupplierCustomer  (OSC_Id),  2.   Article               (A_Id),

                     3.   BuySell,                                 (BS_Id),    4.   BuySellArticle   (BS_Id+A_Id)                                                                                                                          Foreign Keys

Relations       `1.   OSCA   : OperatorSupplierCustomer 1-N with Article                  (OSC_Id)                      2.   OSCBS : OperatorSupplierCustomer  1-N with BuySell                (OSC_Id)                      3.   ABSA   : Article                               1-N with BuySellArticle       (A_Id)                      4.   BSBSA : BuySell                              1-N with BuySellArticle       (BS_Id)

Operators

LeverancierKlant

OperatorSupplierCustomer

MyShop manager

MyShop Operators

 MyShop Customers

buy

Articles

MyShop Suppliers  

 sell

Articles

MyShop Input

Operators

Suppliers

Customers

Articles

Buying’s

Selling's

MyShop Views

Suppliers

   Articles

   Payments

Orders

   Invoices

   Vat

Stock

Edifact


UML

MyShop Project

       

MyShop Facts

….

Operator

(1)

(2)

(4)