Description
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.
61 Following the notation we used in class, using draw.io and the shapes provided by it, produce an ER diagram
62 for the application. Do not use any other notation. For example, you may not use cardinality constraints in
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.
75 A Company Helps exactly one Company; a Company may Help itself. For such a Help, a Company
76 charges a Fee and its value is not necessarily known.
77 A Company may Own Stores and no two Companies may Own the same Store. Each Store has at78 tributes Number and Size. Number is always known and no two Stores Owned by the same Company
79 may have the same Number. If Size is known, it is at least 100,000.
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.
82 Stores Sell Books. If a Store Sells a Book, we may know the StartDate when that Store started
83 selling that Book.
84 Sales may be Approved by one or more Companies.
Typeset: 2021-10-03T02:46:21Z MD5:
Page 3 of 3
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.
92 You may encounter some difficulties running the software so here are possible workarounds.
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
97 Also, if your Java version is too old you may need to update it. Please see https://www.java.com/
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.
Typeset: 2021-10-03T02:46:21Z MD5:
