27 FIT2094-FIT3171 Exam 31 Workshop Session 2 and 5 – Data Modelling INCLUDING BUT NOT LIMITED TO THESE TOPICS… ▪Conceptual vs Logical Level ▪Entity –Strong vs weak –Associative entity ▪Types of attributes ▪Relationship –Type : one-to-one, one-to-many, many-to-many –Cardinality and Participation –Identifying vs Non-identifying. ▪Mapping from Conceptual to Logical –E.g. Mapping many-to-many ▪FIT3171 – UML 32 Workshop Session 3 – Relational Model INCLUDING BUT NOT LIMITED TO THESE TOPICS… ▪Relational model properties. ▪Keys –Superkey, Candidate Key, Primary Key –Foreign Key ▪Data Integrity –Entity integrity –Referential Integrity ▪Relational Algebra –Understanding of efficiency 33 Workshop Session 4 – Normalisation INCLUDING BUT NOT LIMITED TO THESE TOPICS… ▪UNF to 3 NF –Mapping form to UNF –UNF to 1 NF – remove repeating group. –1NF to 2 NF – remove partial dependency. –2NF to 3NF – remove transitive dependency. ▪Dependency diagrams –Use the general definition –Partial in 1NF, Transitive in 2NF, Full in 3NF •use this notation: cust_id → cust_name, cust_address ▪Be careful in choosing the PK! ▪Mapping a set of 3NF relations to a logical model 34 Workshop Sessions 6 and 8– DDL and DML INCLUDING BUT NOT LIMITED TO THESE TOPICS… ▪DDL –CREATE TABLE statements •Primary key definition •Foreign key definition •Other Constraints –ALTER –DROP ▪DML –INSERT •Adherence to referential integrity constraints and the order of insertion –Oracle Sequence –UPDATE (DML) –DELETE (DML) –COMMIT 35 Workshop Session 7, 9 and 10 – SQL INCLUDING BUT NOT LIMITED TO THESE TOPICS… ▪Single table retrieval with predicate ▪Join –Natural join –Outer join ▪Aggregate functions ▪Set Operators ▪Subquery ▪Oracle functions TO_CHAR, TO_DATE, NVL, UPPER, LOWER, ROUND 36 Workshop Session 9 PLSQL and Workshop Session 11 DB Connectivity, Web Technology INCLUDING BUT NOT LIMITED TO THESE TOPICS… ▪Web database connectivity –Understanding of the principles and ALL core concepts: •Database middleware •Web to database middleware •Using PHP to communicate with databases –must understand php code which relates to database –Database design frameworks •modern frameworks •ORM –Security → SQL Injection ▪FIT3171 – TRIGGER 37 Workshop Session 8 – Transaction Management INCLUDING BUT NOT LIMITED TO THESE TOPICS… ▪Transaction. ▪ACID properties. ▪Transaction problems. ▪Transaction management with locks. ▪Wait For Graphs ▪Restart and Recovery using Transaction Log. 欢迎咨询51作业君
