EB103A- Homework 5 Solved

Description
There is one assignment: To create a relational implementation of an ER diagram.
2 Assignments
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
57 Crow’s feet notation and including the needed (but only the needed) annotations. Replace zk1 with your Net 58 ID and note what’s specified in Item 1a. You should follow exactly the ER diagram given and the example 59 of the University database we covered in class. Do not create better relational implementations if such are 60 possible by deviating from the ER diagram.

(a) Specify the following using SQL Power Architect and everything else that needs to be specified (if
anything) put in annotations by modifying Solution05.txt
tables
attributes, including for each that
– it must not be NULL (if applicable)
– it is a part of the primary key (if applicable)
– it is a part of a foreign key (if applicable)
It is not important for us what the domains of the attributes are, so use VARCHAR as the domain
for all attributes
many-to-one mappings between tables (or one-to-one as applicable)
Please,
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.

Solution05.txt in the text format, by modifying the file in this assignment.
In that file
Replace the Metadata with your information.
State the required (and only the required) Annotations.
A file with a diagram in the native format as produced by SQL Power Architect. The file should be called
architect.
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
SQL Power Architect sometimes produces inconsistent diagrams such as our R-S diagram in Figure 1. In R-S,
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