HARTA ___________________________ ________________________ | | | | | | | | | | | | | | | | | ORD | | | DEPT | | | |_____________| | | | | | | | | |_____________| | | | | | | | |ordid|custid| orderdate | | | | | | | | | deptno | dname | | | | commplan | | | | | | | | | | loc | | | | shipdate | | | | | | | | | | | | | | total | | | | | | | | | | | | | | maxline | | | | | | | | | | | | | | | | | | |_____|______|_____________| |________|_____________| | |__________________ |____________ | | | __|______________________ _|______________________ __|________________________ | | | | | | | | | | | | | | | o | i | p | ITEM | | | | CUSTOMER | | | | | EMP | | r | t | r |___________| | c | r |___________| | d | e | s |________| | d | e | o |actualprice| | u | e |name | | e | m | a |job | | i | m | d |qty | | s | p |address | | p | p | l |mgr | | d | i | i |itemtot | | t | i |town | | t | n | |ename | | | d | d | | | i | d |country | | n | o | |hiredate| |___|___|___|___________| | d | |pcode | | o | | |comm | | | | |phone | |______|_____|___|________| | | | |creditlimit| | | | | | |comments | | | | |_____|_____|___________| | | _______________| |________________| | | _________| | _|___ | | | _|_____________ ____________________________________ __|_____|________________ | p | | | p | | | | | | | | | r | PRODUCT | | r | | | PRICE | | | | SALGRADE | | o |_________| | o | | |_________| | | |___________| | d |descript | | d |stdprice|startdate|minprice | |losal|hisal|grade | | i | | | i | | |enddate | | | | | | d | | | d | | | | | | | | |___|_________| |_____|________|_________|_________| |_____|_____|___________| | | |_______________|