Question: Use the entity - relationship diagram ( ERD ) from the previous assignment in topic 1 . Create a database, populate all entities and identify
Use the entityrelationship diagram ERD from the previous assignment in topic 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
Topic 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
