Topic:
Know the symbols and vocabulary of UML notation for ERD
Use the symbols to represent the Cardinality Classifications: Mandatory, Optional, 1-M, M-N, 1-1
Understand important relationship patterns: 1-M, M-N, 1-1.
UML Notation
Crown’s Foot Notation
0..1 Zero or one
1..1 Exactly one
0..* Zero or many
1..* One or many Staff Entity name staffNo Primary Key
| Mandatory
o Optional
| One
Many
CourseNo Primary Key
CrsDesc Required/Not Null
CrsUnit Optional/Nullable
Each entity1 { must be | may be} Relationship
_name {one or more | exactly one} entity2
A staff must be assigned to exactly one branch,
A branch must have one or many staffs
A staff may be assigned to one branch, A branc
h may have one or many staffs
A staff may be assigned to exactly one branch, A branch must have one or many staffs
A staff must be assigned to exactly one branch,
A branch may have one or many staffs
A staff must be assigned to one or more branch staffs
es, A branch must have one or many
ABC company, a world-wide company, plan to develop a Sales system to keep and manage sales information of the company. To do this, the company assign some IT staffs to design Sales database. The important data are products, customers, orders, employees and offices. The business constraints are in the following.
Each CUSTOMER must buy one or more ORDERS. Each ORDER must be belonged to exactly one CUSTOMER.
Each EMPLOYEE must be assigned to exactly one OFFICE. Each OFFICE may has one or more EMPLOYEES.
Each PRODUCT may be bought by one or more ORDERS. Each ORDER must have one or more PRODUCTS.
Each EMPLOYEE may be responsible for one or more CUSTOMERS. Each CUSTOMER must be assigned to exactly one EMPLOYEE.
Instructions:
Save your diagram as a “sales_erd_xxxxx.mwb” file stored in your computer.
Save your diagram [Using the menu: Export > Export as PNG…] as an image file with file named “sales_erd_xxxxx.png” and submit the diagram into LEB2 system - Note: xxxxx = your student id
