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...

f


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. 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.