Draw eer diagram includes entity types
The Urban Bike Company database keeps track of the company’s employee, department, customer and orders for its inventory. The system must update the available quantity on hand to reflect that the bike has been sold.
The company has many department. Each department has a unique number, a unique name. One department may have multiple locations.
Business rules.
One customer may or may not place many orders.
One order must be processed by one and only one employee.
One employee must be either a full-time or part-time employee One full-time or part-time employee must be an employee.
|
|
||||
|---|---|---|---|---|---|
| - |
|
|
|||
|
|
||||
|
|
||||
|
|
||||
|
|
participation).
Order
| 3. | Postal Code | Database Logical Design: Map the ER diagram |
|---|---|---|
| Salary | ||
|
||
| Birthday |
Department (FK)
Full or Part-time
| Employee_ID | Employee Salary |
|
Employ |
|
|---|
|
|
Price |
|---|
| Customer Name | ||
|---|---|---|
|
|
F.K. -> P.K.
5. Functional Dependency Analysis for Normalization
