MAKE SURE YOU CREATE THE DIAGRAM  USING DRAW IO  HAS TO BE UML Crow's Foot ERD
Conceptual database Modelling and ERDs as follows:

• Entities are contained in boxes with the entity name in a top box and written in ALL CAPS
• Entity and Attribute names must be singular in nature. Singular means written as a single word, no spaces.
• Attribute names are written in one of, lower case, pascal case, or camel case.
• Unique identifiers are underlined or included in a separate section of the box.
• required fields are included using bold format.
• foreign keys are identified using FK
•  

Transcribed Image Text:

Database Diagram PK FK CUSTOMERNUMBER PK PK NN NN NN NN NN Payments NN FK CHECKNUMBER PAYMENTDATE AMOUNT ORDERS ORDERNUMBER ORDERDATE REQUIREDDATE SHIPPEDDATE STATUS COMMENTS CUSTOMERNUMBER + V PK NN PK NN NN NN NN NN FK PK PK FK NN NN NN CUSTOMERS CUSTOMERNUMBER CUSTOMERFIRSTNAME PHONE ADDRESSLINE1 ADDRESSLINE2 CITY STATE POSTALCODE COUNTRY SALESREPEMPLOYEENU CREDITLIMIT OREDERDETAILS ORDERNUMBER PRODUCTCODE QUANTITYORDERED PRICEEEACH ORDERNUMBER PRODUCTS PRODUCTCODE PRODUCTNAME PRODUCTLINE NN NN FK NN NN NN NN NN NN MSRP PRODUCTSCALE PRODUCTVENDOR PRODUCTDESCRIPTION QUANTITYYINSTOCK BUYPRICE PK PK NN NN NN NN NN NN OFFICES OFFICECODE CITY PHONE IMAGE ADDRESSLINE1 ADDRESSLINE2 STATE COUNTRY POSTALCODE TERRITORY PK NN NN NN NN FK NN NN NN PRODUCTS Employees EMPLOYEENUMBER LASTNAME FIRSTNAME EXTENSION EMAIL OFFICECODE REPORTSO JOBTITLE PRODUCTLINE TEXTDESCRIPTION HTMLDESCRIPTION Database Diagram PK FK CUSTOMERNUMBER PK PK NN NN NN NN NN Payments NN FK CHECKNUMBER PAYMENTDATE AMOUNT ORDERS ORDERNUMBER ORDERDATE REQUIREDDATE SHIPPEDDATE STATUS COMMENTS CUSTOMERNUMBER + V PK NN PK NN NN NN NN NN FK PK PK FK NN NN NN CUSTOMERS CUSTOMERNUMBER CUSTOMERFIRSTNAME PHONE ADDRESSLINE1 ADDRESSLINE2 CITY STATE POSTALCODE COUNTRY SALESREPEMPLOYEENU CREDITLIMIT OREDERDETAILS ORDERNUMBER PRODUCTCODE QUANTITYORDERED PRICEEEACH ORDERNUMBER PRODUCTS PRODUCTCODE PRODUCTNAME PRODUCTLINE NN NN FK NN NN NN NN NN NN MSRP PRODUCTSCALE PRODUCTVENDOR PRODUCTDESCRIPTION QUANTITYYINSTOCK BUYPRICE PK PK NN NN NN NN NN NN OFFICES OFFICECODE CITY PHONE IMAGE ADDRESSLINE1 ADDRESSLINE2 STATE COUNTRY POSTALCODE TERRITORY PK NN NN NN NN FK NN NN NN PRODUCTS Employees EMPLOYEENUMBER LASTNAME FIRSTNAME EXTENSION EMAIL OFFICECODE REPORTSO JOBTITLE PRODUCTLINE TEXTDESCRIPTION HTMLDESCRIPTION

Answer rating: 100% (QA)

The image youve shared is an EntityRelationship Diagram ERD using Crows Foot notation This type of d... View the full answer