CIS111 - Entity Relationship Lab
For this exercise, you will use the Oracle data modeler to create an ERD. Even though you can use other
programs, you will need to create an ERD for project 1 and the quiz.
When complete with your ERD, please print to a PDF format.
print diagram>
You can download the Oracle data modeler from either Moodle or Teams. There is a version for the
MacBook’s, and two versions for Windows. If one of the Windows versions won’t work, the other
should.
Please see the Moodle announcement for the due date.
Creating an entity relationship diagram.
Once the entities and attributes have been determined, it’s time to make the table relationships. This
part is important, as your ERD relies on this relationship.
Using the tables/attribute below, you can make the ERD. Please see the online video on how ut make an
ERD using the Data Modeler.
Vendors
VendorID(pk) VendorName VendorCity VendorState VendorZip
InvoiceID (fk)
Invoices
InvoiceID(pk) InvoiceDate InvoiceTerms InvoiceTotal
ItemID (fk)
InvoiceLineItem
ItemID(pk) ItemDesciption ItemWeight
Now that we have the tables, we can create the ERD
CIS111 - Entity Relationship Lab
Follow as I create the ERD
The reason for using the data modeler from Oracle is that the software can be unzipped into a USB
thumb drive and run directly. There is no need to install the software.