Description

3 1 General Instructions 1
4 2 Homework 2
5 2.1 Description 2
6 2.2 Assignments 2
7 2.2.1 The Application 2
8 3 What to submit 3

9 1 General Instructions
10 1. You need to follow carefully the instructions for the assignment as written below.
11
12
13
14
15
16 2.
17 3.
18
19
20
21
22
23 4.
24
25
26 5.
27
28
29
30 6.
31
32
33
34 7.
35
36
37
38
39
It is advisable to print out this document and check off various points as they are addressed. It is easy to miss something when switching between the assignment and the solution on a single screen, especially on a laptop with a relatively small screen.
If you do not have access to a printer, at least review your solution before the submission to make sure that you did all that you were requested to do and only what you were requested to do.
If you want to refer to a specific line in this document, refer to the small numbers in the left margin.
If you have questions concerning this homework email Yiqi Yuan, mailto:yy3754@nyu.edu, in the way specified in the course syllabus.
If you still have unresolved questions, email Zvi Kedem, mailto:zk1@nyu.edu, including all relevant correspondence with the assistant(s) listed above, in the way specified in the course syllabus.
It is important that you follow the directions precisely. Also, please check that you submitted what you intended to submit, as you are responsible for making sure of that. The best way to do is to download what you submitted to check that.
And the best way to manage your work is to dedicate a folder/directory to each assignment.
Do not email your submission to any of the assistants. If you did not submit your solution on time, please email Zvi Kedem, mailto:zk1@nyu.edu, in the way specified in the course syllabus with an explanation of
what has happened, and if you have a solution (possibly partial), email the solution also.
42 Do not communicate with any of the graders concerning a late submission.
46 one-by-one case. All such requests need to be addressed to Zvi Kedem, mailto:zk1@nyu.edu in the way 47 specified in the course syllabus, with a reason for such a request.
48 2 Homework
49 Reminder: If you are not officially registered in the class and the class does not show on Albert for you, do not 50 submit any assignments.
51 Please read and follow carefully the instructions in Section 1.
52 2.1 Description
53 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.
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.
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.
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.