Please help me correct my ERD Diagram
When working on the normalization of the data remember... First Normal Form (1NF)
- Like data is grouped together in tables. (accounts, people, orders, etc)
- Create a separate row for each set of related data per it's grouping.
- Identify each set of related data with a primary key.
Second Normal Form (2NF)
- Meets the requirements of 1NF.
- Tables do not have any functional dependency that isn't based on a candidate key relation. (In other words, they have to use PK/FK)
Entityrelationshipdiagram1 - Windows Photo Viewer Eile - Print E-mail Burn Open FIX ID: INTEGER NOT NULL TAG: INTEGER NOT NULL NAME : VARCHAR (20) NOT NUL VALUE : CHAR (2) NOT NULL DESCR: VARCHAR (200) NOT NULL MSGTYPE ORDERS + ID : integer NOT NULL DATATIMESTAMP: TIMESTAMP NOT NULL CLIENTID: VARCHAR (20) NOT NULL PARENTORDID: VARCHAR(10) NOT NULL MSGTYPE : CHAR (2) NOT NULL ORDERID: VARCHAR (10) NOT NULL SYSTEMID: VARCHAR (20) NOT NULL INSTRUMENT:integer NOT NULL ORDERSTATUS : CHAR (1) NOT NULL ORDERTYPE:CHAR (1) NOT NULL VENUE:CHAR (4) NOT NULL SIDE : CHAR (1) NOT NULL ORDERQTY: integer NOT NULL CUMQTY: integer NOT NULL LEAVESQTY:integer NOT NULL PRICE : Float NOT NULL DESCR: VARCHAR (100) NOT NULL ORDSTATUS MIC ORDTYPE - SIDE INSTRUMENT + ID: INTEGER NOT NULL INTRUMENT : VARCHAR (30) NOT NULL RIC: VARCHAR(14) NOT NULL ISIN: VARCHAR (12) NOT NULL SEDOL : VARCHAR(9) NOT NULL CUSIP : VARCHAR (10) NOT NULL BBID: VARCHAR (12) NOT NULL MIC: CHAR (4) NOT NULL NAME : VARCHAR (50) NOT NULL CIK: CHAR (10) NOT NULL MIC : CHAR (4) NOT NULL REUTERS POSTFIX: VARCHAR (3) NOT NULL DESCR: VARCHAR(100) NOT NULL INSTRUMENT MIC CONTRACT + SYM: VARCHAR (5) NOT NULL * PRODUCTCODE : VARCHAR (2) NOT NULL STARTDATE: DATE NOT NULL ENDDATE: DATE NOT NULL HO PRODUCT NAME : VARCHAR (100) NOT NULL EXCHANGE : VARCHAR (5) NOT NULL + PRODUCTCODE : VARCHAR (2) NOT NULL CATEGORY: VARCHAR (20) NOT NULL SUBCATEGORY: VARCHAR (20) NOT NULL CLASS : VARCHAR(10) NOT NULL SZE: VARCHAR (10) NOT NULL PRODUCTCODE 14 5 X Entityrelationshipdiagram1 - Windows Photo Viewer Eile - Print E-mail Burn Open FIX ID: INTEGER NOT NULL TAG: INTEGER NOT NULL NAME : VARCHAR (20) NOT NUL VALUE : CHAR (2) NOT NULL DESCR: VARCHAR (200) NOT NULL MSGTYPE ORDERS + ID : integer NOT NULL DATATIMESTAMP: TIMESTAMP NOT NULL CLIENTID: VARCHAR (20) NOT NULL PARENTORDID: VARCHAR(10) NOT NULL MSGTYPE : CHAR (2) NOT NULL ORDERID: VARCHAR (10) NOT NULL SYSTEMID: VARCHAR (20) NOT NULL INSTRUMENT:integer NOT NULL ORDERSTATUS : CHAR (1) NOT NULL ORDERTYPE:CHAR (1) NOT NULL VENUE:CHAR (4) NOT NULL SIDE : CHAR (1) NOT NULL ORDERQTY: integer NOT NULL CUMQTY: integer NOT NULL LEAVESQTY:integer NOT NULL PRICE : Float NOT NULL DESCR: VARCHAR (100) NOT NULL ORDSTATUS MIC ORDTYPE - SIDE INSTRUMENT + ID: INTEGER NOT NULL INTRUMENT : VARCHAR (30) NOT NULL RIC: VARCHAR(14) NOT NULL ISIN: VARCHAR (12) NOT NULL SEDOL : VARCHAR(9) NOT NULL CUSIP : VARCHAR (10) NOT NULL BBID: VARCHAR (12) NOT NULL MIC: CHAR (4) NOT NULL NAME : VARCHAR (50) NOT NULL CIK: CHAR (10) NOT NULL MIC : CHAR (4) NOT NULL REUTERS POSTFIX: VARCHAR (3) NOT NULL DESCR: VARCHAR(100) NOT NULL INSTRUMENT MIC CONTRACT + SYM: VARCHAR (5) NOT NULL * PRODUCTCODE : VARCHAR (2) NOT NULL STARTDATE: DATE NOT NULL ENDDATE: DATE NOT NULL HO PRODUCT NAME : VARCHAR (100) NOT NULL EXCHANGE : VARCHAR (5) NOT NULL + PRODUCTCODE : VARCHAR (2) NOT NULL CATEGORY: VARCHAR (20) NOT NULL SUBCATEGORY: VARCHAR (20) NOT NULL CLASS : VARCHAR(10) NOT NULL SZE: VARCHAR (10) NOT NULL PRODUCTCODE 14 5 X