|
xxxxxx-1. COMPANY �뜲�씠�꽣踰좎씠�뒪�쓽 珥덇린 媛쒕뀗�쟻 �꽕怨�
1. 媛쒖껜 ����엯 DEPARTMENT�뒗 Name, Number, Location, Manager, ManagerStartDate �냽�꽦�쓣 媛�吏꾨떎. Location��� �쑀�씪�븳 �떎移� �냽�꽦�씠�떎. Name怨� Number�뒗 媛� 遺��꽌留덈떎 �쑀�씪�븯�떎怨� 紐낆떆�뻽湲� �븣臾몄뿉 媛곴컖 �궎 �냽�꽦�쑝濡� 吏��젙�븷 �닔 �엳�떎
2. 媛쒖껜 ����엯 PROJECT�뒗 Name, Number, Locations, ControllingDepartment �냽�꽦�뱾�쓣 媛�吏꾨떎. Name怨� Number媛� 媛곴컖 �궎 �냽�꽦�씠�떎.
xxxxxx. 媛쒖껜 ����엯 EMPLOYEE�뒗 Name, SSN, Sex, Address, Salary, BirthDate, Department, Supervisor �냽�꽦�뱾�쓣 媛�吏꾨떎. �궗�슜�옄媛� �궗�썝 Name�쓽 媛� 援ъ꽦�슂�냼(FirstName, MiddleInitial, LastName)��� Address�쓽 媛� 援ъ꽦�슂�냼瑜� 李몄“�븷 寃껋씤吏��쓽 �뿬遺�瑜� �븣湲� �쐞�빐�꽌 �궗�슜�옄��� �떎�떆 �삊�쓽�빐�빞 �븳�떎.
4. 媛쒖껜 ����엯 DEPENDENT�뒗 Employee, DependentName, Sex, BirthDate, Relationship
(�궗�썝怨쇱쓽 愿�怨�) �냽�꽦�뱾�쓣 媛�吏꾨떎.
xxxxxx-2. COMPANY �뜲�씠�꽣踰좎씠�뒪 援ъ꽦 Relation
|
인 쇄
바로가기
愿�怨꾨���닔 愿�怨꾪빐�꽍 SQL�솢�슜�삁.doc
[Size :
287 Kbyte
]
장바구니
