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 Nancy Nigam, mailto:nn2163@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 The are 2 assignments. (1) To create an ER diagram with annotations; (2) To download, install, and open SQL 53 Power Architect.
54 Precise submission details are given in Section 3.
55 2.2 Assignments
56 1. Below is the description of the application under consideration.
57 For the third-person singular pronoun I will generally use “it” and its declensions.
58 Some words are in bold. This has no semantic implications and they are written in this way to make the 59 reading easier.
60 Do not make any assumptions about the application beyond the specifications listed.
63 your diagram.
64 Because the software you will use has slight differences compared to what we did, please consult the file 65 NotationForER.pdf so that you know how to produce your diagram. 66 Do not optimize your design, just follow the specification given.
67 Anything that cannot be specified in the ER diagram, put as annotations in text03.txt file, as described in 68 Item 1 of Section 3, starting with 1. and continuing as needed.
69 Do not put anything in the annotations that can be reflected in the ER diagram, make sure that the diagram 70 reflects that. The idea is for you to think what’s needed and where to put it: the diagram or the annotations.
71 Note that you cannot make any assumptions that are not forced by the specifications. For example, if the 72 value of an attribute is not required to be known, you cannot assume that it is always known.
73 There are Companies. Companies have an attribute TIN (Tax Identification Number) and it is always 74 known. No two Companies can have the same TIN.
80 There are Books. A Book has two attributes ISBN and Price. ISBN is always known and no two books 81 can have the same ISBN.
85 The domains of the attributes have not been specified.
86 Start with the given ER03.drawio but put your own NetID in the cloud drawn there.
87 If the system does not allow you to upload ER03.drawio, rename your ER03.drawio to be ER03.txt. Then 88 upload ER03.txt, and state that you have done that in Item 1b of Section 3.
89 2. You will need to use SQL Power Architect to specify relational databases in a future assignment. Please
90 download and install the latest version of the community edition from http://www.bestofbi.com/page/ 91 architect_download_os. Make sure that you can open it.
93 (a) A number of students in a previous class could not make the Mac version work on Mac, but the 94 Unix/Generic version did work. Please use the link for direct download : http://www.bestofbi.com/
95 downloads/architect/1.0.9/SQL-Power-Architect-generic-1.0.9.tar.gz.
96 Detailed steps can be found here : http://www.bestofbi.com/page/architect-start
98 en/download/manual.jsp.
99 (b) Sometimes it is not possible to save a new file. This bug is intermittent. However, it was always possible to
100 open an existing file, modify it, and just save it. Therefore a blank file relationalDatabase.architect 101 is enclosed. You can just copy it to a directory of your choice and work with it.
102 State in text03.txt whether you have installed SQL Power Architect and were able to open it.
103 3. Modify text03.txt by putting in it
104 1. Your metadata
105 2. The list of the annotations as requested above
106 3. Have you done what is requested in Item 2 of Section 2.2? If that’s the case, just write “Yes”.
107 If you have not done so, explain why. And if you run into difficulties doing that part of the assignment 108 after applying all the workarounds described, also send email to Nancy Nigam, mailto:nn2163@nyu.edu, 109 explaining what the difficulties were.
110 3 What to submit
111 Please upload 3 files, named exactly as specified and in the format exactly as specified.
112 1. text03.txt in the text format, by modifying the file in this assignment.
113 In that file
114 • Replace the Metadata with your information.
115 • State the required (and only the required) Annotations.
116 • State your responses by placing appropriate text after the item label as listed below (so your first item 117 will labeled “(a)”):
118 (a) Have you done what’s requested in Item 2 of Section 2.2? If yes, just write “Yes”.
119 If not, explain why.
120 (b) If you cannot upload ER03.drawio, state so. Otherwise leave this item empty.
121 2. A file with a diagram in the native format as produced by draw.io. The file should be called ER03.drawio.
122 3. A file with a PDF version of the diagram you have produced. The file should be called ER03drawio.pdf.