Description
The are two assignments. One is to review some course material; two to create an ER diagram with an annotations
54 file.
55 Precise submission details are given in Section 3.
56 2.2 Assignments
57 1. Please read the file University01.pdf and review the implementation of that application as an ER diagram
58 in Unit 2.
59 2. For the third-person singular pronoun I will generally use “it” and its declensions.
60 Some words are in bold. This has no semantic implications and they are written in this way to make the
61 reading easier.
62 Consider the application described in Section 2.2.1. Do not make any assumptions about the application
63 beyond the specifications listed.
64 Following the notation we used in class, using draw.io and the shapes provided by it, produce an ER diagram
65 for the application. Do not use any other notation. For example, you may not use cardinality constraints in
66 your diagram. Start with the given ER02.drawio and put your own Net ID in the cloud there.
67 Because the software you will use has slight differences compared to what we did, please consult the file
68 NotationForER.pdf so that you know how to produce your diagram.
69 Do not optimize your design, just follow the specification given.
70 Anything that cannot be specified in your ER diagram, put as annotations in text02.txt file, as described
71 in Item 1 of Section 3, starting with 1. and continuing as needed.
72 Do not put anything in the annotations that can be reflected in the ER diagram, make sure that the diagram
73 reflects that. The idea is for you to think what’s needed and where to put it: the diagram or the annotations.
74 2.2.1 The Application
75 Note that you cannot make any assumptions that are not forced by the specifications. For example, if the
76 value of an attribute is not required to be known, you cannot assume that it is always known.
77 There are Companies. A Company may be Small or Big but cannot be both. Companies have
78 an attribute TIN (Tax Identification Number) and RegNumber (Registration Number) and they are
79 always known. No two Companies can have the same TIN and no two Companies can have the same
80 RegNumber.
81 A Company may have one or more Nicknames.
82 Small Companies may Help each other and we want to know which Small Company Helps which
83 Small Company. A Small Company may not Help itself.
Typeset: 2021-09-21T19:26:36Z MD5: C76AAA3A23CAA2BB6421A504FB531362
Page 3 of 3
84 There are Managers. Each has the attribute FamName (Family Name) and the attribute PerName
85 (Personal Name), which are always known. No two Managers can have both the same PerName and the
86 same FamName. Managers also have the attributes Salary and Bonus, which are always known. Bonus
87 is computed as 5% of Salary.
88 A Big Company has the attribute Value. For a Big Company there may be at most one Manager who
89 Supervises it. If a Manager Supervises a Company, that relationship has attribute Start.
90 The domains of the attributes have not been specified.
91 Start with the given ER02.drawio but put your own NetID in the cloud drawn there.
92 If the system does not allow you to upload ER02.drawio, rename your ER02.drawio to be ER02.txt. Then
93 upload ER02.txt, and state that you have done that in Item 1b of Section 3.
94 3 What to submit
95 Please upload 3 files, named exactly as specified and in the format exactly as specified.
96 1. text02.txt in the text format, by modifying the file in this assignment.
97 In that file
98 • Replace the Metadata with your information.
99 • State the required (and only the required) Annotations.
100 • State your responses by placing appropriate text after the item label as listed below (so your first item
101 will labeled “(a)”):
102 (a) Have you done what’s requested in Item 1 of Section 2.2? If yes, just write “Yes”.
103 If not, explain why.
104 (b) If you cannot upload ER02.drawio, state so. Otherwise leave this item empty.
105 2. A file with a diagram in the native format as produced by draw.io. The file should be called ER02.drawio.
106 3. A file with a PDF version of the diagram you have produced. The file should be called ER02drawio.pdf.
Typeset: 2021-09-21T19:26:36Z MD5: C76AAA3A23CAA2BB6421A504FB531362
