최종완성본은  아래 사진과 같은데

이 전글에서 답변 주신거대로 해보는 것보다 제 생각대로 해보고 고쳐나가는게 좋을거 같다는 생각이 들어서

제가 맞다고 생각하는데로 해보았습니다.

틀린 부분이나 처음부터 다시해야한다면 상세하게 좀 알려주시면 참고하여 다시 제작해보겠습니다.

학비 700만원을 날리고 싶지 않아요 도와주세요 ㅜㅜ

*참고 사항*

a.       Based on the expense report, start with the following original table schema:

Expense (StatementNumber, EmployeeID, Name, Title, Email, Department, Manager, StartDateOfTrip, Nbdays, TripPurpose, ExpenseLineNumber, ExpenseDate, Account, Description, Vendor, Category, PaymentMethod, Amount). Consider (StatementNumber, ExpenseLineNumber) as PK. Draw the dependency diagram. Make sure you label the transitive and/or partial dependencies.

Account refers to a general ledger (GL) account created to hold expense information. Every single type of expense has a GL code or account that is composed of department and type of expense. For instance, an employee working in the IT department (has id 10) has to enter the airplane expense (category T with ID 100) in the first line of the expense report, the GL account is then 10100.  

Definition:  A general ledger is a complete record of financial transactions over the life of a company. The ledger holds account information that is needed to prepare financial statements, and includes accounts for assets, liabilities, owners' equity, revenues and expenses.

General Ledger

A general ledger represents the formal ledger for a company's financial statements with debit and credit account records validated by a trial balance.