Graph documentation: Orders and products

Status: draft
Personnel: Joe Smith
Documentation: ER model was made by JS 5.5.1998

Graph picture: Orders and products

Graph dictionary

Objects	Type of object	Documentation
Buy-order	Entity	Sale department can do a new buy-order, when the "do buy order"-level of has been achieved.
Department	Entity	Company has own departments for Sales, Delivery, Marketing and Research and Development
Product	Entity	Product is stored in the central warehouse
Project	Entity	Project is the certain task to be finished, which is limited on time recourses and costs.
Supplier	Entity	Supplier delivers the products and part to the company.
Worker	Entity	Company has two kinds of employees (full time and part-time workers)
Address	ERAttribute	Postal address
Amount	ERAttribute
Colour	ERAttribute
Delivery date	ERAttribute	Each part has it's own delivery date.
DepartmentID	ERAttribute	DepartmentID identifies the department. 011 means Sales 012 means Delivery 013 means Marketing 014 means Research and Development
Name	ERAttribute	Name-field values can't be Null. Only duplicate values are allowed.
Order date	ERAttribute
OrderID	ERAttribute	OrderID identifies the order
Part#	ERAttribute	Part code identifies the part, which is used in this project.
Project ID	ERAttribute	Each project has it's own ID code.
SupplierID	ERAttribute	SupplierID identifies the supplying company.
WorkerID	ERAttribute	WorkerID identifies the employee.
Entities are reused in the architecture model. Hence, change of Product in ER model changes product information also in the architecture model and vice versa. See Process/Entity Matrix on sales and inventory.	Note	Entities are reused in the architecture model. Hence, change of Product in ER model changes product information also in the architecture model and vice versa. See Process/Entity Matrix on sales and inventory.
Belong	Relationship	Each employee is working for some department.
Contains	Relationship
Delivery	Relationship
Makes	Relationship
Participates	Relationship

Buy-order (Entity)

Properties:

Entity name	Buy-order
Documentation	Sale department can do a new buy-order, when the "do buy order"-level of has been achieved.

Buy-order relationships:

In role	In relationship	With object(s)	In role
Entity part	In relationship	Contains	Relationship role
Entity part	In relationship	Delivery	Relationship role
Entity part	In relationship	Makes	Relationship role
Owner part	Attribute of	Delivery date	Attribute part
Owner part	Attribute of	OrderID	Attribute part
Owner part	Attribute of	Order date	Attribute part

Buy-order links:

Link type	Graph's name
Decomposition	none
Explosions	none

Department (Entity)

Properties:

Entity name	Department
Documentation	Company has own departments for Sales, Delivery, Marketing and Research and Development

Department relationships:

In role	In relationship	With object(s)	In role
Entity part	In relationship	Belong	Relationship role
Owner part	Attribute of	Address	Attribute part
Owner part	Attribute of	DepartmentID	Attribute part
Owner part	Attribute of	Name	Attribute part

Department links:

Link type	Graph's name
Decomposition	none
Explosions	none

Product (Entity)

Properties:

Entity name	Product
Documentation	Product is stored in the central warehouse

Product relationships:

In role	In relationship	With object(s)	In role
Entity part	In relationship	Contains	Relationship role
Owner part	Attribute of	Colour	Attribute part
Owner part	Attribute of	Part#	Attribute part

Product links:

Link type	Graph's name
Decomposition	none
Explosions	none

Project (Entity)

Properties:

Entity name	Project
Documentation	Project is the certain task to be finished, which is limited on time recourses and costs.

Project relationships:

In role	In relationship	With object(s)	In role
Entity part	In relationship	Participates	Relationship role
Owner part	Attribute of	Name	Attribute part
Owner part	Attribute of	Project ID	Attribute part

Project links:

Link type	Graph's name
Decomposition	none
Explosions	none

Supplier (Entity)

Properties:

Entity name	Supplier
Documentation	Supplier delivers the products and part to the company.

Supplier relationships:

In role	In relationship	With object(s)	In role
Entity part	In relationship	Delivery	Relationship role
Owner part	Attribute of	Name	Attribute part
Owner part	Attribute of	SupplierID	Attribute part

Supplier links:

Link type	Graph's name
Decomposition	none
Explosions	none

Worker (Entity)

Properties:

Entity name	Worker
Documentation	Company has two kinds of employees (full time and part-time workers)

Worker relationships:

In role	In relationship	With object(s)	In role
Entity part	In relationship	Makes	Relationship role
Entity part	In relationship	Participates	Relationship role
Entity part	In relationship	Belong	Relationship role
Owner part	Attribute of	WorkerID	Attribute part
Owner part	Attribute of	Address	Attribute part
Owner part	Attribute of	Name	Attribute part

Worker links:

Link type	Graph's name
Decomposition	none
Explosions	none

Address (ERAttribute)

Properties:

Attribute name	Address
Type of data	CHAR
Constraint
Documentation	Postal address

Address relationships:

In role	In relationship	With object(s)	In role
Attribute part	Attribute of	Worker	Owner part
Attribute part	Attribute of	Department	Owner part

Address links:

Link type	Graph's name
Decomposition	none
Explosions	none

Amount (ERAttribute)

Properties:

Attribute name	Amount
Type of data	INTEGER
Constraint
Documentation

Amount relationships:

In role	In relationship	With object(s)	In role
Attribute part	Attribute of	Contains	Owner part

Amount links:

Link type	Graph's name
Decomposition	none
Explosions	none

Colour (ERAttribute)

Properties:

Attribute name	Colour
Type of data	INTEGER
Constraint
Documentation

Colour relationships:

In role	In relationship	With object(s)	In role
Attribute part	Attribute of	Product	Owner part

Colour links:

Link type	Graph's name
Decomposition	none
Explosions	none

Delivery date (ERAttribute)

Properties:

Attribute name	Delivery date
Type of data	DATE
Constraint
Documentation	Each part has it's own delivery date.

Delivery date relationships:

In role	In relationship	With object(s)	In role
Attribute part	Attribute of	Buy-order	Owner part

Delivery date links:

Link type	Graph's name
Decomposition	none
Explosions	none

DepartmentID (ERAttribute)

Properties:

Attribute name	DepartmentID
Type of data	INTEGER
Constraint	NOT NULL PRIMARY KEY
Documentation	DepartmentID identifies the department. 011 means Sales 012 means Delivery 013 means Marketing 014 means Research and Development

DepartmentID relationships:

In role	In relationship	With object(s)	In role
Attribute part	Attribute of	Department	Owner part

DepartmentID links:

Link type	Graph's name
Decomposition	none
Explosions	none

Name (ERAttribute)

Properties:

Attribute name	Name
Type of data	CHAR
Constraint	NOT NULL UNIQUE
Documentation	Name-field values can't be Null. Only duplicate values are allowed.

Name relationships:

In role	In relationship	With object(s)	In role
Attribute part	Attribute of	Project	Owner part
Attribute part	Attribute of	Supplier	Owner part
Attribute part	Attribute of	Worker	Owner part
Attribute part	Attribute of	Department	Owner part

Name links:

Link type	Graph's name
Decomposition	none
Explosions	none

Order date (ERAttribute)

Properties:

Attribute name	Order date
Type of data	DATE
Constraint
Documentation

Order date relationships:

In role	In relationship	With object(s)	In role
Attribute part	Attribute of	Buy-order	Owner part

Order date links:

Link type	Graph's name
Decomposition	none
Explosions	none

OrderID (ERAttribute)

Properties:

Attribute name	OrderID
Type of data	REAL
Constraint
Documentation	OrderID identifies the order

OrderID relationships:

In role	In relationship	With object(s)	In role
Attribute part	Attribute of	Buy-order	Owner part

OrderID links:

Link type	Graph's name
Decomposition	none
Explosions	none

Part# (ERAttribute)

Properties:

Attribute name	Part#
Type of data	INTEGER
Constraint	NOT NULL PRIMARY KEY
Documentation	Part code identifies the part, which is used in this project.

Part# relationships:

In role	In relationship	With object(s)	In role
Attribute part	Attribute of	Product	Owner part

Part# links:

Link type	Graph's name
Decomposition	none
Explosions	none

Project ID (ERAttribute)

Properties:

Attribute name	Project ID
Type of data	INTEGER
Constraint	NOT NULL
Documentation	Each project has it's own ID code.

Project ID relationships:

In role	In relationship	With object(s)	In role
Attribute part	Attribute of	Project	Owner part

Project ID links:

Link type	Graph's name
Decomposition	none
Explosions	none

SupplierID (ERAttribute)

Properties:

Attribute name	SupplierID
Type of data	INTEGER
Constraint	NOT NULL PRIMARY KEY
Documentation	SupplierID identifies the supplying company.

SupplierID relationships:

In role	In relationship	With object(s)	In role
Attribute part	Attribute of	Supplier	Owner part

SupplierID links:

Link type	Graph's name
Decomposition	none
Explosions	none

WorkerID (ERAttribute)

Properties:

Attribute name	WorkerID
Type of data	REAL
Constraint	NOT NULL PRIMARY KEY
Documentation	WorkerID identifies the employee.

WorkerID relationships:

In role	In relationship	With object(s)	In role
Attribute part	Attribute of	Worker	Owner part

WorkerID links:

Link type	Graph's name
Decomposition	none
Explosions	none

Entities are reused in the architecture model. Hence, change of Product in ER model changes product information also in the architecture model and vice versa. See Process/Entity Matrix on sales and inventory. (Note)

Properties:

Documentation

Entities are reused in the architecture model. Hence, change of Product in ER model changes product information also in the architecture model and vice versa. See Process/Entity Matrix on sales and inventory. relationships:
none

Entities are reused in the architecture model. Hence, change of Product in ER model changes product information also in the architecture model and vice versa. See Process/Entity Matrix on sales and inventory. links:

Link type	Graph's name
Decomposition	none
Explosions	none

Belong (Relationship)

Properties:

Relationship name	Belong
Documentation	Each employee is working for some department.

Belong relationships:

In role	In relationship	With object(s)	In role
Relationship role	In relationship	Department	Entity part
Relationship role	In relationship	Worker	Entity part

Belong links:

Link type	Graph's name
Decomposition	none
Explosions	none

Contains (Relationship)

Properties:

Relationship name	Contains
Documentation

Contains relationships:

In role	In relationship	With object(s)	In role
Owner part	Attribute of	Amount	Attribute part
Relationship role	In relationship	Product	Entity part
Relationship role	In relationship	Buy-order	Entity part

Contains links:

Link type	Graph's name
Decomposition	none
Explosions	none

Delivery (Relationship)

Properties:

Relationship name	Delivery
Documentation

Delivery relationships:

In role	In relationship	With object(s)	In role
Relationship role	In relationship	Supplier	Entity part
Relationship role	In relationship	Buy-order	Entity part

Delivery links:

Link type	Graph's name
Decomposition	none
Explosions	none

Makes (Relationship)

Properties:

Relationship name	Makes
Documentation

Makes relationships:

In role	In relationship	With object(s)	In role
Relationship role	In relationship	Buy-order	Entity part
Relationship role	In relationship	Worker	Entity part

Makes links:

Link type	Graph's name
Decomposition	none
Explosions	none

Participates (Relationship)

Properties:

Relationship name	Participates
Documentation

Participates relationships:

In role	In relationship	With object(s)	In role
Relationship role	In relationship	Worker	Entity part
Relationship role	In relationship	Project	Entity part

Participates links:

Link type	Graph's name
Decomposition	none
Explosions	none