1 / 3

CLIENT ClientID TaxPayerID CName CTel CAddres s CCity CState CZip CFax CEmail

MIS 3500, Homework on normalization. Class diagram for American tax filing. Business rules: 1. A client requests many tax filings, and each tax filing is for one particular client. 2. A client can have many appointments, and each appointment is for one client.

isolde
Download Presentation

CLIENT ClientID TaxPayerID CName CTel CAddres s CCity CState CZip CFax CEmail

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MIS 3500, Homework on normalization Class diagram for American tax filing Business rules: 1. A client requests many tax filings, and each tax filing is for one particular client. 2. A client can have many appointments, and each appointment is for one client. 3. A client requests many tax filing, and each tax filing is for one client. 4. A tax filing produces many tax files, an d each tax file is produced by a tax filing. 5. A tax file is a state tax file or a federal tax file. 6. Each Form 1040 is part of one federal tax file, and each federal tax file includes one Form 1040 . 7. Each Schedule A is part of one federal tax file, and each federal tax file includes one Schedule A. 8. Each Schedule C is part of one federal tax file, and each federal tax file includes one Schedule C. 9. Each Form W2 is part of one federal tax file, and each federal tax file includes two Forms W2 . 10. Each Form 1099is part of one federal tax file, and each federal tax file includes four Forms 1099 . 10. An employee hosts many appointments, and each appointment is hosted by one employee. 11. One employee performs tax filing, and each tax filing is done by an employee. APPOINTMENT AppointmentID Date Time EmployeeID Title Subject Length Cancelation CLIENT ClientID TaxPayerID CName CTel CAddress CCity CState CZip CFax CEmail 1 1 makes * EMPLOYEE EmployeeID EName 1 * 1 hosts performs requests FORM1040 Form1040ID 1 FEDERAL-TAX-FILE FTaxFileNo TotalFederalTax AverageRate 1 TAX-FILING FilingNo TaxYear EmployeeID ClientID FilingDate Fee 1 * SCHEDULE-A AScheduleID 1 * part of produces is SCHEDULE-C CScheduleID STATE-TAX-FILE STaxFileNo State StateTax TaxRate 1 * TAX-FILE TaxFileNo Year AGI Prepaid TaxDue/Refund 2 FORMW2 FormW2ID CopyNo KEY: Classes: 12 * 0.5 = 6 Associations: 12 * 0.25 = 3 Part-of relationship: 2 Is relationships: 1 Biz rules: 11 * 0.5 = 5.5 Multiplicity: 16 * 0.15 = 2.5 SUM: 20 FORM1099 Form1099ID CopyNo 4 Minus marks: - missing assoc. name or attribute, unmarked key= -0.1

  2. Schema for American tax filing APPOINTMENT Appointment ClientID Date Time EmployeeID Title Subject Length Cancelation CLIENT ClientID TaxPayerID CName CTel CAddress CCity CState CZip CFax CEmail 1 1 * • KEY: • Tables: 12 * 0.5 = 6 • Associations: 12 * 0.25 = 3 • Multiplicity: 20 * 0.25 = 5 • SUM: 14 • Minus marks: • missing PK-FK assoc. or attribute, • unmarked key= -0.1 EMPLOYEE EmployeeID EName 1 * 1 FORM1040 Form1040ID 1 1 1 1 1 1 FEDERAL-TAX-FILE FTaxFileNo TotalFederalTax AverageRate 1 TAX-FILING FilingNo TaxYear EmployeeID ClientID FilingDate Fee 1 * SCHEDULE-A AScheduleID 1 * SCHEDULE-C CScheduleID STATE-TAX-FILE STaxFileNo State StateTax TaxRate TAX-FILE TaxFileNo FilingNo Year AGI Prepaid TaxDue/Refund 1 1 1 1 * FORMW2 FormW2ID CopyNo FTaxFileNo FORM1099 Form1099ID CopyNo FTaxFileNo 2 4

  3. Analysis CLASS DIAGRAM One important part of the data analysis is to recognize special relationships. One is a generalization-specialization relationship between an annual tax file (the parent) and the federal and state tax files (children classes). The children (or sub-classes) share most of the tax file attributes but two each (notice the green coloring of the shared attributes and of those unique to children). Another peculiar aspect of design is a part-whole relationship between a federal tax file and its 5 forms; the former is an assembly of the latter. The for4ms come in 1 or more copiers, which detr3mines their multiplicity (1, 2 or 4). The rest of design is straightforward, with some optional solutions. The 5 part-whole relationships, increase the number of business rules. SCHEMA The class diagram should translate direcl5ty into schema, with all relationships and multiplicities preserved. A small challenge is how to implement 1:1 multiplicity, which occurs in both special relationships. As practiced in the lab, this is done by sharing a key between tables. Specifically, TaxFileNo in TAX-FILE table, is the same as STaxFileNo in STATE-TAX-FILE and FTaxFileNo in FEDERAL-TAX-FILE. Column names can be the different and the only condition is that the key columns be of the same data type. Values of TaxFileNo are either values of STaxFileNo or of FTaxFileNo(they are “generalized” to the parent class). The 1:1 multiplicity appears in 3 part-whole relationships as well (e.g., between FEDERAL-TAX-FILE and FORM1040). It is implemented so that a value of the whole table’s key is shared by the key in a part table; say, the value of FTaxFileNo is 2013 for the 2013 tax year, and the value of corresponding Form1040ID is also 2013.

More Related