Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: THEend8_
ISYS2120 Assignment
Value: 5%
Late work policy: (from unit outline) Late submissions for assignments will incur a penalty of 5% of the maximum awardable marks for each day, or part-day, past the due date, up to a maximum of 7 days (as after this time, feedback on on-time submissions will be available, resulting in an unfair advantage if submissions after this time were accepted). After 7 days late submissions will not be accepted. Where special consideration is granted for these assessments, extensions of a maximum of 7 days will be permitted. After 7 days, reweighting of other relevant tasks will be applied.
Summary (but details further down are authoritative)
Done individually. You are allowed to use GenerativeAI, but if so, you must submit an appendix showing each prompt you used, and the corresponding output from the computer; you will be marked only for what you have contributed, not on what was done by the computer.
Provided for you: an Entity-Relationship diagram for a domain, along with some text about the domain.
You produce: a relational schema that is good for storing the information about a state of the domain; it should allow any reasonable information that fits the ER diagram, and also it should enforce constraints that are shown in the ER diagram, or implied by general knowledge.
Submit: a report with structure as described in detail below [submit on Canvas], and a text file with SQL statements to create tables [submit on Canvas]
The task Below we show a conceptual data model, for a system used by a real estate management company, to hold information relating to apartments in the buildings (“complexes”) for which the company is responsible, as well as tracking their owners and (sometimes) renters, and the agents of the company who provide the management services for the apartments. When an apartment is available for renting, a customer may make an offer to rent that apartment. The system tracks the TFN (tax file number) and bank account of each owner, so any rent payments can be put to the appropriate account, and the tax office is notified. For a renter, the system records the balance of funds held for them; this starts positive when the renter provides a bond, and it decreases as various charges are accrued, and the balance increases whenever the renter provides more money to the management company. The system also tracks how recently an agent has been in contact with a customer. The task for the group is to produce a relational schema that corresponds to the ER conceptual data model we provide. We expect you to first identify tables and their attributes, along with primary key and foreign key constraints; this will be expressed using a relational schema diagram. Then you must give SQL CREATE TABLE statements that would be executed to define the schema in a DBMS. Some aspects of the conceptual model are not explicitly specified (for example, it does not indicate the data type for attributes); you need to make sensible choices for these, so that the SQL statements can be executed by the PostgreSQL system used by Edstem for its SQL code windows.
It is important that your proposed schema should try to capture the integrity constraints from the conceptual model, but even more crucial that your schema does not unduly restrict the data -- for example, if the ER diagram allows some situation, your schema must not prevent data showing that situation from being stored (unless the restriction is anyway implied by general knowledge, for example, it will be necessary to restrict what is stored for an attribute so that it fits into the data type on the column).