EB103A- Homework 3 Solved

50                   Description

51                   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.

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”.