Description

3 1 General Instructions 1
4 2 Homework 2
5 2.1 Description . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 6 2.2 Assignments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2
7 3 What to submit 3
8 1 General Instructions
9 1. You need to follow carefully the instructions for the assignment as written below.
10
11
12
13
14
15 2.
16 3.
17
18
19
20
21
22 4.
23
24
25 5.
26
27
28
29 6.
30 31
32
33 7.
34
35
36
37
38
39
40
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 Chengyu Chen, mailto:cc7027@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.
41 Do not communicate with any of the graders concerning a late submission.
45 one-by-one case. All such requests need to be addressed to Zvi Kedem, mailto:zk1@nyu.edu in the way 46 specified in the course syllabus, with a reason for such a request.
47 2 Homework
48 Reminder: If you are not officially registered in the class and the class does not show on Albert for you, do not 49 submit any assignments.
50 Please read and follow carefully the instructions in Section 1.
51 2.1 Description
52 There are a number of small, mostly trivial, assignments (though the description is long).
53 Precise submission details are given in Section 3.
54 2.2 Assignments
55 1. You need to have a CIMS computer account. If you do not have one yet please follow https://cims.nyu. 56 edu/webapps/content/systems/userservices/accounts/obtain to request an account. Your request 57 should generally be automatically granted.
58 2. Read the syllabus for the class, 2433.pdf. Decide whether you fully understand it. If you do not, state what 59 needs to be clarified for full understanding.
60 3. Please read the file University01.pdf and follow the instructions in it.
61 4. As part of this assignment you will make sure that you are able to produce an ER diagram and an associated 62 text file when required. In this assignment,
65 The diagram has the following shapes
66 • rectangles (use the not-rounded version)
67 • diamonds (rhombuses)
68 • rectangles with diamonds inside
69 • ellipses
70 • triangles
71 The diagram has the following types (formats) of lines
72 • regular
73 • double
74 • dashed
75 • with and without arrows
76 The diagram has the following types (formats) of text
77 • regular
78 • underlined
79 • underlined by dots
80 To produce your diagram, use draw.io https://www.draw.io/, which is free and does not require any
81 installation, but installation can generally be done, so you can work locally, if you like. Use the Basic set of 82 templates and in it use the Entity Relation template; if it does not have what you need to complete the 83 diagram, use also the General template. Try to fit it on one page. The native format you will use is drawio.
84 Start with the given ER01.drawio. Your drawing diagram should be a duplicate of the one in this assignment 85 but put your own NetID in the cloud drawn there.
86 Don’t be fanatical about the faithfulness of the duplication. It is enough to make sure that the various shapes 87 are the same as the ones given and placed roughly in the same locations, that the lines are recognizable as 88 the ones given, that the shapes are connected as in the diagram (note particularly that sometime connections 89 are to vertexes and sometime to edges so reproduce that), and that the text in the shapes is formatted as 90 given. But do try to be neat.
91 If the system does not allow you to upload ER01.drawio, state so in Item 1d of Section 3.
92 3 What to submit
93 Please upload 3 files, named exactly as specified and in the format exactly as specified.
94 1. text01.txt in the text format, by modifying the file in this assignment.
95 In that file
96 • Replace the Metadata with your information
97 • Leave the Annotations as they are
98 • Place your responses to items Item 1, Item 2, and Item 3 of Section 2.2 by placing appropriate text 99 after the item label as listed below (so your first item will labeled “(a)”):
100 (a) Do you have a CIMS account or have you requested such an account? If one of the above holds
101 just write “Yes”.
102 If neither holds, explain why.
103 (b) Have you read and understood the syllabus? If that’s the case just write “Yes”.
105 Kedem, mailto:zk1@nyu.edu with the subject line “2433 questions on syllabus” listing any issues 106 that need clarification.
107 If neither holds explain why.
108 (c) Have you read the case study University01.pdf and have you considered what it could mean? If 109 that’s the case, just write “Yes”.
110 If you have not done so, explain why.
111 (d) If you cannot upload any of ER01.drawio, state so. Otherwise leave this item empty.
112 2. A file with a diagram in the native format as produced by draw.io. The file should be called ER01.drawio.
113 3. A file with a PDF version of the diagram you have produced. The file should be called ER01drawio.pdf.