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 A An SQL Power Architect bug: Please read 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 Akshay Rita, mailto:ar6618@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 There is one assignment: To create a relational implementation of an ER diagram.
54 2.2 Assignments
55 1. You will need to create a relational implementation modifying relational05.architect, of the ER diagram 56 Assignment05.drawio satisfying the annotations in Assignment05.txt, using SQL Power Architect with
61 (a) Specify the following using SQL Power Architect and everything else that needs to be specified (if
62 anything) put in annotations by modifying Solution05.txt
63 • tables
64 • attributes, including for each that
65 – it must not be NULL (if applicable)
66 – it is a part of the primary key (if applicable)
67 – it is a part of a foreign key (if applicable)
68 It is not important for us what the domains of the attributes are, so use VARCHAR as the domain
69 for all attributes
70 • many-to-one mappings between tables (or one-to-one as applicable)
71 Please,
72 • Do not make any assumptions about the application beyond the specifications listed. 73 • Do not optimize your design, just follow the specification given.
74 • Do not use any other capabilities that SQL Power Architect provides; for example do not use 75 Index Properties or Remarks for Column Properties.
76 • Anything that cannot be specified in your SQL Power Architect diagram, put as annotations in 77 Solution05.txt file, as described below.
78 • Do not put anything in the annotations that can be reflected in the SQL Power Architect imple79 mentation; make sure that the implementation reflects that.
80 (b) Modify the file Solution05.txt as specified in Item 1 of Section 3.
81 3 What to submit
82 Please upload 3 files, named exactly as specified and in the format exactly as specified.
83 1. Solution05.txt in the text format, by modifying the file in this assignment.
84 In that file
85 • Replace the Metadata with your information.
86 • State the required (and only the required) Annotations.
87 2. A file with a diagram in the native format as produced by SQL Power Architect. The file should be called
88 Relational05.architect.
89 3. A file with a PDF version of the diagram you have produced. The file should be called Relational05.pdf.
90 A An SQL Power Architect bug: Please read
91 SQL Power Architect sometimes produces inconsistent diagrams such as our R-S diagram in Figure 1. In R-S,
92 attribute A in S can be NULL but the left side of the line between R and S has a stroke | indicating that the 93 binary many-to-one mapping from S to R is total. Only R1-S1 and R2-S2 are correct. So make sure that your
94 diagram is correct, fixing what SQL Power Architect produces, if necessary. This is easy to do by modifying 95 Relationship Properties.

Figure 1: Read the text of Appendix A