Question: Use the entity - relationship diagram ( ERD ) from the previous assignment in topic 1 . Create a database, populate all entities and identify

Use the entity-relationship diagram (ERD) from the previous assignment in topic 1. Create a database, populate all entities and identify attributes, relation instance, domain constraints, and primary key. You may use data from the Generate Data website, located in Class Resources. (make sure the types of attributes are correct)
Provide your CSV (data) files and screenshots depicting successful data in all entities and outline the steps you took to build and populate the database for the previous assignment in topic 1.
Topic 1 Assignment to use for this lab:
Create an ERD (using correct connection symbols for relations) based on the Crow's Foot notation using the following requirements:
An INVOICE is written by a SALESREP. A sales representative can write many invoices, but an invoice is written by a single sales representative.
The INVOICE is written for a single CUSTOMER. However, each customer can have many invoices.
An INVOICE can include many detail lines (LINE); each Line describes one product and the number of product, as well as total cost bought by the customer.
The product information is stored in a PRODUCT entity.
The products vendor information is found in a VENDOR entity. (You may assume each vendor can have many products and a product can be obtained from many vendors).

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!