Lab $1$ Assignment

Instructions:

The task of this lab is to use CHEN's ERD notation to draw an Entity$-$Relationship

diagram based on the given specifications and submit the diagram in JPG format. In Dia,

choose "File" $$ "Export" from the main Popup Menu to export it as Lab$1$X$.$jpg $($where X is

your last name$).$ If you click File $$ save, the file extension is dia. Note that Blackboard cannot

open a file in the dia format. To ensure your work can be graded, you must submit a JPG

file, which can be opened to display the diagram on Blackboard.

For Mac users, if the Dia does not support your operating systems, you may use

diagrams.net to

create the Entity$-$Relationship diagram. Start with a blank diagram. Scroll down to "Entity

Relation" from the left$-$hand side panel to draw your E$-$R diagram. Once completed, click

"File" $$ "Export" to export the diagram as a jpg file.

Task:

Consider a retail database in which customers place orders. The data requirements are

summarized as follows:

The company's customers are uniquely identified by their identifier $($custID$).$ In

addition, their first and last names, password, and phone numbers are recorded.

A customer may place orders, and each order must be placed by exactly one

customer.

A unique item identifier $($iID$)$ is used to identify the company's items. In addition, the

item name, price, and quantity in stock are tracked.

Each order placed by a customer is given a unique order identifier $($oID$).$ Besides the

order identifier, the order date, shipping date, receiving date, pay amount, and

payment method should be documented.

Each order must include some items of a specific quantity and sale price. An item

may be included in an order.

Based on the above information, draw an E$-$R diagram using a data$-$modeling tool like