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
|